This repository contains these data packages (and source code used to create them):
Click the links to be taken to the most recent release version of each data package and download the parquet data files and README. Alternatively, import parquet data packages directly with the dpkg R package.
The city of Cincinnati provides publicly available data associated with events reported at the household-level. However, to maintain the privacy of inviduals and households, the addresses are adminstratively masked, meaning the public data reports a street range, rather than an exact house (e.g., 12XX Main Street represents all houses numbered between 1200 and 1299 on Main Street.)
The address_x provided by the city is converted to possible street range lines from the census bureau using text matching for street names and comparison of street number ranges. It is possible for an address_x range to have more than one intersection census street range file, which are unionized to one street range geometry.
Below is a map of the total number of crime incidents and shotspotter reports for each street range approximation.
Helderop E, Nelson JR, Grubesic TH. ‘Unmasking’ masked address data: A medoid geocoding solution. MethodsX. 2023;10:102090. doi:10.1016/j.mex.2023.102090