Performance Metrics - Streets & Sanitation - Rodent Baiting

In addition to performing regular scheduled preventative rodent control, the Department of Streets & Sanitation (DSS) responds to site-specific customer rat complaints logged through 311’s Customer Service Requests (CSR) system. This metric tracks the average number of days the DSS takes to complete rodent baiting requests per week. Median days to complete requests as well as total number of requests fulfilled per week are available by mousing over columns. The target response time for rodent baiting requests is within 7 days. For more information on open rat complaints, see https://data.cityofchicago.org/Government/311-Service-Requests-Rodent-Baiting-2011-/97t6-zrhs

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-rodent-ga2y-gwbs\".\"performance_metrics_streets_sanitation_rodent\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.