CDPH Environmental Complaints

data.cityofchicago.org | Last Updated 21 Aug 2024

Environmental complaints received by the Department of Environment (DOE) from January 1993 to December 31, 2011 and by the Department of Public Health (CDPH) since January 1, 2012. On January 1, 2012, the DOE was disbanded and all its inspection, permitting, and enforcement authorities were transferred to the CDPH. Data fields requiring description are detailed below. COMPLAINT ID: This is the unique identifier of the complaint incident. COMPLAINT TYPE: Specifies the type of complaint. CDPH complaint types are “Abandoned Site”, “Air Pollution Work Order”, “Asbestos Work Order”, “Construction and Demolition”, “Toxics Hazardous Materials Work Order”, ”Illegal Dumping Work Order”, “Noise Complaint”, “Permits Issued by DOE Work Order”, “Recycling Work Order”, “Service Stations/Storage Tanks Work Order”, “Vehicle Idling Work Order”, and “Water Pollution.” For consistency, historic DOE complaint types were renamed to match the most appropriate CDPH complaint type. DOE complaint types that had no matches are designated as “Other.” MAPPED LOCATION: Contains latitude/longitude coordinates of the site as determined through the Chicago Open Data Portal’s geocoding engine. In instances where the facility address is a range, the lower number (the value in the “Street Number From” column) is used for geocoding. For example, for the range address 1000-1005 S Wabash Ave, the Mapped Location would be the coordinates for 1000 S Wabash Ave. INSPECTOR: Contains the badge or ID number of the inspector or engineer who conducted the compliant inspection. COMPLAINT DATE: Date complaint was received by the department. COMPLAINT DETAIL: Brief description of the nature of the complaint. INSPECTION LOG: This is the inspector’s narrative log of the complaint inspection. DATA SOURCE: The city department that collected the data.

Tags: environmental complaints

This dataset has the following 17 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
COMPLAINT IDcomplaint_idtextThe unique identifier of the complaint incident. For Historic Department of Environment records, this ID is prefixed with "DOECOMP".
COMPLAINT TYPEcomplaint_typetextSpecifies the type of complaint work order.
ADDRESSaddresstext
STREET NUMBER FROMstreet_numbernumberThe numerical portion of the address. For ranged address, this is the lower number of the range.
STREET NUMBER TOstreet_number_tonumberThis is the upper number of a ranged address. This value is blank if the address is not a ranged address.
DIRECTIONdirectiontextThe direction (N,S,E,W) portion of the address.
STREET NAMEstreet_nametextStreet name portion of the address.
STREET TYPEstreet_typetextThe street suffix (e.g. ST = Street, AVE= Avenue, BLVD=Boulevard)
INSPECTORinspectortextThe inspector badge number or employee ID of the inspector or engineer who conducted the inspection.
COMPLAINT DATEcomplaint_datecalendar_dateThe date the complaint was received by the department.
COMPLAINT DETAILcomplaint_detailtextBrief description of the nature of the complaint.
INSPECTION LOGinspection_logtextThis is the inspector’s narrative log of the complaint inspection.
DATA SOURCEdata_sourcetextThe city department that collected the data.
Modified Datemodified_datecalendar_date
LATITUDElatitudenumber
LONGITUDElongitudenumber
LOCATIONlocationpoint