cityofchicago/311-service-requests-sanitation-code-complaints-me59-5fac
Icon for Socrata external plugin
 
Readme
Updated over 3 years ago
Indexed 39 minutes ago

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

NameSocrata field nameColumn name in sgr mountData typeDescription
Police Districtpolice_districtpolice_districtNumber
Community Areacommunity_areacommunity_areaNumber
LatitudelatitudelatitudeNumber
LongitudelongitudelongitudeNumber
Y Coordinatey_coordinatey_coordinateNumber
Type of Service Requesttype_of_service_requesttype_of_service_requestText
Service Request Numberservice_request_numberservice_request_numberText
Creation Datecreation_datecreation_dateCalendar date
Location (address)location_addresslocation_addressText
Wards:@computed_region_43wa_7qmu:@computed_region_43wa_7qmuNumber
ZIP Codezip_codezip_codeNumber
Street Addressstreet_addressstreet_addressText
LocationlocationlocationPoint
WardwardwardNumber
X Coordinatex_coordinatex_coordinateNumber
Location (zip)location_ziplocation_zipText
Location (state)location_statelocation_stateText
Census Tracts:@computed_region_bdys_3d7i:@computed_region_bdys_3d7iNumber
Community Areas:@computed_region_vrxf_vc4k:@computed_region_vrxf_vc4kNumber
Zip Codes:@computed_region_6mkv_f3dw:@computed_region_6mkv_f3dwNumber
Historical Wards 2003-2015:@computed_region_awaf_s7ux:@computed_region_awaf_s7uxNumber
Location (city)location_citylocation_cityText
Completion Datecompletion_datecompletion_dateCalendar date
StatusstatusstatusText
What is the Nature of this Code Violation?whatis_the_nature_of_this_code_violationwhatis_the_nature_of_this_code_violationText
 
Preview
  • 311_service_requests_sanitation_code_complaints
     
Upstream Metadata