property_code_enforcements 1.0.1

Property Code Enforcements Data

The property_code_enforcements data package contains the date, infraction description, infraction status, and address of reported infractions downloaded from the code enforcement data from CincyInsights.

Infraction addresses were matched to known residential addresses and parcel identifiers in Hamilton County using addr.

Infraction-level data were excluded if they (1) had a status of "Closed - No Violation", "Closed - No Violations Found", "Duplicate Case", or "Closed - Duplicate Complaint", or (2) did not contain a property address number/name.

There were 535,686 infractions reported between 1999-09-17 and 2024-08-09.

• 335,077 (63%) were matched to a single residential address in Hamilton County and were matched to a parcel identifier.
• Note that in the case of condominiums, addresses are matched one-to-one, but are matched to multiple parcel identifiers.
• The 850 (0.2%) infractions that were matched to more than one address and 199,759 (37%) that were not matched are missing parcel identifier.

Resources

• City of Cincinnati code enforcement data dictionary
• City of Cincinnati code enforcement guide
• City of Cincinnati common housing code violations

cagis_parcels 1.1.1

CAGIS Parcels Data

The cagis_parcels tabular-data-resource contains parcel identifiers, parcel addresses, and parcel characteristics downloaded from the Cincinnati Area Geographic Information System (CAGIS).

Auditor parcel-level data were excluded if they (1) did not contain a parcel identifier, (2) did not contain a property address number/name, or (3) had a duplicated parcel identifier.

Parcels with the following land use categories are included in the data resource and others are excluded.
These were selected to reflect residential usages of parcels.

land_use
single family dwelling
condominium unit
two family dwelling
apartment, 4-19 units
landominium
three family dwelling
condo or pud garage
other residential structure
metropolitan housing authority
apartment, 40+ units
apartment, 20-39 units
manufactured home
office / apartment over
boataminium
other commercial housing
mobile home / trailer park
lihtc res

Some of the parcel characteristics do not make sense in certain contexts and should not be interpreted incorrectly; for example, the value of a parcel for a multi-family or multi-unit housing structure shouldn’t be compared to the value of a parcel for a single-family household for the purposes of assesing individual-level SES.

auditor_online_parcels 0.2.1

Hamilton County Auditor Online Data

The hamilton_online_parcels tabular data resource contains parcel characteristics scraped from Hamilton County Auditor Online and linked to the parcel identifers in the cagis_parcels data package.
Characteristics include the "parcel id", "year built", "number of total rooms", "number of bedrooms", "number of full bathrooms", "number of half bathrooms", and a "market total value" (named online_total_market_value to distinguish it from the market total value in cagis_parcels).

In general, online_market_total_value is based on values extracted from the Hamilton County Auditor's online website and is preferred over market_total_value derived from historical building records maintained by CAGIS in cagis_parcels.

parcel 1.0.0

parcel is now a data repository for parcel-level data in Hamilton County, Ohio.

previous R package infrastructure has been removed, but the package can be installed from a past release.

property_code_enforcements 1.0.0

property_code_enforcements-v1.0.0

make cagis_addr chr

cagis_parcels 1.1.0

cagis_parcels-v1.1.0

add title for cagis parcel data too

auditor_online_parcels 0.2.0

auditor_online_parcels-v0.2.0

add title

parcel 0.11.1

What's Changed

• update python dependencies to include csvdedupe and scikit-learn v1.3.0 by @erikarasnick in #44

Full Changelog: 0.11.0...0.11.1

parcel 0.11.0

• update CAGIS and auditor online data for 2024 (State of Ohio rappraised all properties in 2023 for the 2024 tax year)
• parcel file now includes the centroid latitude and longitude coordinates
• use updated version of reticulate package (1.3.1) to specify versions of python dependencies in the DESCRIPTION file

parcel 0.10.1

What's Changed

• export link_apt and fix bug by @cole-brokamp in #41