311 Service Requests - Sanitation Code Complaints - Historical
As described in http://bit.ly/311HistoricalPost, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.
All open sanitation code complaints made to 311 and all requests completed since January 1, 2011. The Department of Streets and Sanitation investigates and remedies reported violations of Chicago’s sanitation code. Residents may request service for violations such as overflowing dumpsters and garbage in the alley.
311 sometimes receives duplicate sanitation code complaints. Requests that have been labeled as duplicates are in the same geographic area as a previous request and have been entered into 311’s Customer Service Request (CSR) system at around the same time. Duplicate complaints are labeled as such in the status field, as either "Open - Dup" or "Completed - Dup."
Data Owner: Streets and Sanitation (http://www.cityofchicago.org/content/city/en/depts/streets.html).
Time Period: January 1, 2011 to present.
Frequency: Data is updated daily.
Related Applications: 311 Service Request Status Inquiry (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=createsrquery2) and Report Sanitation Code Complaint (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=locform&invSRType=SCB&invSRDesc=Sanitation%20Code%20Violation&locreq=Y&stnumreqd=Y).
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Police District | police_district | police_district | Number | |
| Community Area | community_area | community_area | Number | |
| Latitude | latitude | latitude | Number | |
| Longitude | longitude | longitude | Number | |
| Y Coordinate | y_coordinate | y_coordinate | Number | |
| Type of Service Request | type_of_service_request | type_of_service_request | Text | |
| Service Request Number | service_request_number | service_request_number | Text | |
| Creation Date | creation_date | creation_date | Calendar date | |
| Location (address) | location_address | location_address | Text | |
| Wards | :@computed_region_43wa_7qmu | :@computed_region_43wa_7qmu | Number | |
| ZIP Code | zip_code | zip_code | Number | |
| Street Address | street_address | street_address | Text | |
| Location | location | location | Point | |
| Ward | ward | ward | Number | |
| X Coordinate | x_coordinate | x_coordinate | Number | |
| Location (zip) | location_zip | location_zip | Text | |
| Location (state) | location_state | location_state | Text | |
| Census Tracts | :@computed_region_bdys_3d7i | :@computed_region_bdys_3d7i | Number | |
| Community Areas | :@computed_region_vrxf_vc4k | :@computed_region_vrxf_vc4k | Number | |
| Zip Codes | :@computed_region_6mkv_f3dw | :@computed_region_6mkv_f3dw | Number | |
| Historical Wards 2003-2015 | :@computed_region_awaf_s7ux | :@computed_region_awaf_s7ux | Number | |
| Location (city) | location_city | location_city | Text | |
| Completion Date | completion_date | completion_date | Calendar date | |
| Status | status | status | Text | |
| What is the Nature of this Code Violation? | whatis_the_nature_of_this_code_violation | whatis_the_nature_of_this_code_violation | Text |