This R code generates the Hamilton County Property Code Enforcement (hamilton_property_code_enforcement) data resource. A census tract-level rate of property code enforcements per household is derived from code enforcement data from CincyInsights (contributed and maintained by CAGIS).
See metadata.md for detailed metadata and schema information.
Read this CSV file into R directly from the release with:
readr::read_csv("https://github.com/geomarker-io/hamilton_property_code_enforcement/releases/download/0.1.3/hamilton_property_code_enforcement.csv")
Metadata can be imported from the accompanying tabular-data-resource.yaml file by using {CODECtools}.
Housing code violations with a DATA_STATUS_DISPLAY of “Closed - No Violation”, “Closed - No Violations Found”, “Duplicate Case”, or “Closed - Duplicate Complaint” were excluded.
The number of households per tract was estimated by summing the number of households per block in each tract from the 2020 census.