Data Description: This data set contains records for recycling cart ‘tips.’ RFID tag readers record when a City of Cincinnati recycling cart is ‘tipped,’ meaning it is picked up/lifted by a recycling truck. The table contains all addresses in the City of Cincinnati and identifies addresses with a City of Cincinnati recycle bin, which are tracked by an RFIDTAG. The Cartlift field indicates how many time the recycling cart was ‘tipped’ in a given month.

Data Creation: Data generated by RFID tag readers when City of Cincinnati recycling cart is picked up/lifted by a recycling truck

Data Created By: Office of Environment and Sustainability

Refresh Frequency: Daily

CincyInsights: The City of Cincinnati maintains an interactive dashboard portal, CincyInsights in addition to our Open Data in an effort to increase access and usage of city data. This data set has an associated dashboard available here: https://insights.cincinnati-oh.gov/stories/s/gd3w-zpnu

Data Dictionary: A data dictionary providing definitions of columns and attributes is available as an attachment to this dataset.

Processing: The City of Cincinnati is committed to providing the most granular and accurate data possible. In that pursuit the Office of Performance and Data Analytics facilitates standard processing to most raw data prior to publication. Processing includes but is not limited: address verification, geocoding, decoding attributes, and addition of administrative areas (i.e. Census, neighborhoods, police districts, etc.).

Data Usage: For directions on downloading and using open data please visit our How-to Guide: https://data.cincinnati-oh.gov/dataset/Open-Data-How-To-Guide/gdr9-g3ad

Date Range: August 2019 - November 2022
66,717 rows dropped due to incomplete data from RFID reader (2% of total rows in data set)

This data comes from RFID readers on recycling trucks that scan recycling carts which contain a unique RFID tag on each cart. Every time an RFID tag is read by the recycling truck a row is recorded in the data set. The account number in the data set is the account number that the cart belongs to. Each account number may have a varying number of carts.

The account number used by the recycling company is also an ID used in our databases for referring to addresses. In our address database each record has an account number (aka address_guid) and an addressid. The important thing to note is that some addressid's may have multiple account numbers (aka addr_guid's). For example, some condo complexes have an account number (aka addr_guid) for every unit in the complex. This does not mean that every building with multiple units will have multiple account numbers for each addressid.

The columns that contain information on the type of residence the address is have data that was pulled in November 2022. This may have implications when looking at historical data structure types. For example, an account number was a one family dwelling in 2019 but remodeled and reclassified as a 4-family dwelling in 2022. The records where this is the case however should be small.

The dataset contains tips from all recycling accounts, so commercial and municipal account tips will also appear in the dataset. This will need to be accounted for when analyzing and filters may need to be applied to look at specific groups such as residential single family dwellings.

Column Info:
ADDR_TYPE:
ADR = Address
BLD = Building
PAR = Parcel
CON = CONDO

Category:
Specifies if the address is classified as "Residential" or "Commercial" use for example.

Description:
A more granular description of the address for example Category could be "Residential" and Description could be "Single Family Dwelling"