Performance Metrics - Streets & Sanitation - Garbage Cart Requests

The City of Chicago provides heavy-duty plastic 96-gallon garbage carts to single-family residences and apartment buildings of four units or less. This metric tracks the average number of days the Department of Streets and Sanitation (DSS) takes to complete new garbage cart 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 a new garbage cart request is 7 days. For more information on garbage cart requests, see https://data.cityofchicago.org/d/9ksk-na4q

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-garbage-6htv-6453\".\"performance_metrics_streets_sanitation_garbage\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.