Performance Metrics - Streets & Sanitation - Sanitation Code Complaints
The Department of Streets and Sanitation (DSS) 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. This metric tracks the average number of days the DSS takes to complete sanitation code violation requests per week. Median days to complete requests as well as total number of requests fulfilled per week are available by mousing over columns. Currently the performance target for completing sanitation code violation requests is 3 days. For more information on sanitation code complaints, see https://data.cityofchicago.org/d/me59-5fac
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/performance-metrics-streets-sanitation-sanitation-64yp-nqnb\".\"performance_metrics_streets_sanitation_sanitation\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.