cityofchicago/311-service-requests-sanitation-code-complaints-me59-5fac
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 years ago
Indexed 1 month 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).

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cityofchicago/311-service-requests-sanitation-code-complaints-me59-5fac\".\"311_service_requests_sanitation_code_complaints\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 311_service_requests_sanitation_code_complaints
     
     
     
     
     
Upstream Metadata