Package 'codec'

Convert a data frame, name, and description into a CoDEC table

Description

CoDEC Specifications:

1. The data must include a census tract identifier column (i.e., census_tract_id_2010, or census_tract_id_2020). The column must contain 11-digit GEOID identifiers for every census tract in Hamilton County, OH.

2. Data must be structured in a tidy format such that each row is an observation for a specific census tract at a specific year (and month). This means that the data includes a year column (year), an integer year representing the vintage of the data (e.g. 2021). The data can optionally include a month column (month), an integer month of the year.

3. The name must only contain lower case alphanumeric characters, -, or ⁠_⁠

4. The description should be markdown text and the first line must contain the title of the CoDEC data table as a level one header (e.g., ⁠# My Community Data⁠). Titles must be less than 80 characters.

Usage

as_codec_tbl(x, name, description = character())

Arguments

x	data.frame or tibble meeting CoDEC data specifications above
name	name of CoDEC table
description	markdown text describing the CoDEC table

Value

a codec_tbl object

Examples

tibble::tibble(
  census_tract_id_2020 = cincy_census_geo("tract", "2020")$geoid,
  n_things = 823,
  year = 2024L
) |>
  as_codec_tbl(
    name = "n_things",
    "# Number of Things\n Number of things were averaged by census tract using the survey from 2024"
  )

---

Cincy address geographies

Description

CAGIS data (see install_cagis_data()) provides a list of all addresses in Hamilton County. Addresses are filtered for the following criteria:

• use only addresses that have STATUS of ASSIGNED or USING and are not orphaned (ORPHANFLG == "N")

• omit addresses with ADDRTYPEs that are milemarkers (MM), parks (PAR), infrastructure projects (PRJ), cell towers (CTW), vacant or commercial lots (LOT), and other miscellaneous non-residential addresses (MIS, RR, TBA)

• s2 cell is derived from LONGITUDE and LATITUDE fields in CAGIS address database

Usage

cincy_addr_geo()

Value

a simple features object with columns cagis_address, cagis_address_place, cagis_address_type, cagis_s2, cagis_parcel_id, cagis_is_condo, and a geometry column (s2_geography)

Examples

cincy_addr_geo()

---

Cincy census tracts and block groups

Description

Read tract and block group ("bg") geographies from the online Census TIGER/Line files into R

Usage

cincy_census_geo(
  geography = c("tract", "bg"),
  vintage = as.character(2024:2013)
)

cincy_county_geo(vintage = as.character(2024:2013))

Arguments

geography	which type of cincy census geography to return
vintage	a character vector of a year corresponding to the vintage of TIGER/Line data

Details

Compressed shapefiles are downloaded from TIGER into an R user data directory and will be cached for use across other R sessions (see ?dpkg::stow for more details).

Value

a simple features object with a geographic identifier column (geoid) and a geometry column (s2_geography)

Examples

cincy_census_geo("tract", "2024")
cincy_census_geo("bg", "2020")
cincy_county_geo("2024")

---

cincy_city_geo()

Description

cincy_city_geo()

Usage

cincy_city_geo()

Examples

cincy_city_geo()

---

Cincy neighborhood geographies

Description

CAGIS data (see install_cagis_data()) provides community council boundaries, but these boundaries can overlap and do not align with census geographies or ZIP codes. By default, the statistical neighborhood approximations are instead returned, which are calculated by aggregating census tracts into 50 matching neighborhoods.

Usage

cincy_neighborhood_geo(
  geography = c("statistical_neighborhood_approximations", "community_council")
)

Arguments

geography

which type of cincy neighborhood geography to return

Value

a simple features object with a geographic identifier column (geoid) and a geometry column (s2_geography)

Examples

cincy_neighborhood_geo("statistical_neighborhood_approximations")
cincy_neighborhood_geo("community_council")

---

Cincy ZIP Code Tabulation Areas

Description

Read ZIP Code Tabulation Areas (ZCTAs) geographies from the online Census TIGER/Line files into R

Usage

cincy_zcta_geo(vintage = as.character(2024:2013))

Arguments

vintage

a character vector of a year corresponding to the vintage of TIGER/Line data

Value

a simple features object with a geographic identifier column (geoid) and a geometry column (s2_geography)

Examples

cincy_zcta_geo()

---

Coerce a CoDEC data table into a simple features object

Description

The name of the census tract column in the CoDEC data table is used to add the appropriate census tract s2 geography column.

Usage

codec_as_sf(x)

Arguments

x	a CoDEC data table

Details

Tract identifers do not change across decennial censuses, but the digital representation of their boundaries may be improved over time. Here, data tables using 2010 tract identifers use the TIGER/Line 2019 tract shapefiles and data tables using 2020 tract identifiers use the TIGER/Line 2020 tract shapefiles

Value

a simple features object with a geometry column (s2_geography) in addition to the columns in x

Examples

codec_as_sf(codec_read("property_code_enforcements"))

---

CoDEC colors

Description

CoDEC colors

Usage

codec_colors(n = NULL)

Arguments

n	a numeric vector of color numbers or character vector of color names; if NULL returns named vector of available colors

Examples

plot(1:8, rep(1, 8), col = codec_colors(1:8),
  pch = 19, cex = 10, axes = FALSE, xlab = "", ylab = "")
text(1:8, rep(1.1, 8), labels = names(codec_colors()))

---

Spatially interpolate community-level data

Description

Census block-level weights are used to spatially interpolate CoDEC data packages from the census tract-level to other Cincy geographies.

Usage

codec_interpolate(from, to, weights = c("pop", "homes", "area"))

Arguments

from	a CoDEC data package
to	A simple features object returned by one of the ⁠cincy_*_geo()⁠ functions (i.e., cincy_census_geo(), cincy_neighborhood_geo(), or cincy_zcta_geo()')
weights	which census block-level weights to use; see details

Details

Block-level total population (pop), total number of homes (homes), or total land area (area) from the 2020 Census can be chosen to use for the weights. Geospatial intersection happens after transforming geographies to epsg:5072. See codec_as_sf() for adding geography to a CoDEC data package. Variables beginning with "n_" are interpolated using a weighted sum; all other variables are interpolated using a weighted mean.

Value

a tibble with a new geographic identifier column for the to target geography (geoid) in addition to the (interpolated) columns in from

Examples

codec_interpolate(codec_read("acs_measures"),
                  cincy_neighborhood_geo())
codec_interpolate(codec_read("property_code_enforcements"),
                  cincy_census_geo("tract", "2019"))

---

Read and list CoDEC tables in the CoDEC online data catalog

Description

The CoDEC online data catalog is hosted on GitHub alongside the source code for this package.

• Use codec_read() as a shortcut to read a CoDEC table into R as a codec_tbl object (see ?as_codec_tbl)

• Use codec_list() as a shortcut to list available CoDEC table pins

• Use codec_board() as a shortcut to create a pin board object to use with the pins package (see ?pins::pins)

Usage

codec_read(
  name,
  board = codec_board(version = packageVersion("codec")),
  cache = NULL,
  use_cache_on_failure = rlang::is_interactive(),
  headers = NULL
)

codec_list(board = codec_board())

codec_board(
  version = "v3.0.0-rc1",
  cache = NULL,
  use_cache_on_failure = rlang::is_interactive(),
  headers = NULL
)

Arguments

name	The name of the CoDEC table in the online CoDEC data catalog.
board	The CoDEC board to read from. Don't change this unless you want to read from an older version of the online data catalog.
cache	Cache path. Every board requires a local cache to avoid downloading files multiple times. The default stores in a standard cache location for your operating system, but you can override if needed.
use_cache_on_failure	If the pin fails to download, is it ok to use the last cached version? Defaults to is_interactive() so you'll be robust to poor internet connectivity when exploring interactively, but you'll get clear errors when the code is deployed.
headers	Named character vector for additional HTTP headers (such as for authentication). See connect_auth_headers() for Posit Connect support.
version	specify a version of the online data catalog using a commit SHA, tag, or branch of geomarker-io/codec

Details

The pin for each CoDEC table has versions (see ?pins::pin_versions), but codec_board() can be used to specify a state of the online data catalog based on the version of the codec package. (See examples)

Value

For codec_read(), a codec_tbl object (see as_codec_tbl())

For codec_list(), a character vector CoDEC table names

For codec_board(), a pins_board object

Examples

# list available CoDEC tables
codec_list()

# read a CoDEC table and inspect its metadata
d <- codec_read("traffic")
head(d)
attr(d, "title")
message(attr(d, "description"))

# change the defaults for codec_board() to read from older versions
codec_board("v3.0.0-rc1") |>
  pins::pin_versions("property_code_enforcements")

---

Install CAGIS GIS database

Description

This installs the CAGIS Open Data GIS database (.gdb) into the data directory for the codec package. Once downloaded, it will be reused across R sessions on the same computer. The geodatabase contains many layers that are updated quarterly. (Historical geodatabases are not available here.)

Usage

install_cagis_data(
  cagis_data_url =
    "https://www.cagis.org/Opendata/Quarterly_GIS_Data/CAGISOpenDataQ1_2025.gdb.zip"
)

Arguments

cagis_data_url

the url to the CAGIS Open Data .gdb.zip file; this changes quarterly, so check for something more recent if the file cannot be found

See Also

This function is called by cincy_neighborhood_geo(), cincy_city_geo() and others that import individual layers.

Examples

install_cagis_data()
sf::st_layers(install_cagis_data())$name

---