cityofchicago/performance-metrics-streets-sanitation-tree-debris-hwpp-nx6b
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 1 month ago

Performance Metrics - Streets & Sanitation - Tree Debris

After extreme weather events, the Bureau of Forestry Tree Emergency is deployed to remove plant debris blocking or cluttering the public way. This metric tracks the average number of days the Department of Streets and Sanitation (DSS) takes to complete tree debris removal requests per week. Median days to complete requests as well as total number of requests fulfilled per week are also available by mousing over columns. The Department of Streets & Sanitation responds to emergency tree debris removal requests logged by 311’s Customer Service Requests (CSR) system. The target response time for Tree Debris Removal is 1 day. For more information on open tree debris removal requests, see https://data.cityofchicago.org/d/mab8-y9h3

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-tree-debris-hwpp-nx6b\".\"performance_metrics_streets_sanitation_tree_debris\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • performance_metrics_streets_sanitation_tree_debris
     
     
     
     
     
Upstream Metadata