cityofchicago/311-service-requests-tree-debris-historical-mab8-y9h3
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 5 years ago
Indexed 1 month ago

311 Service Requests - Tree Debris - 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 tree debris removal requests made to 311 and all requests completed since January 1, 2011. Large piles of branches or bushes may be picked up by the Department of Streets and Sanitation.

311 sometimes creates duplicate requests for tree debris removal. When there is an open tree debris request, a duplicate request is created when the exact same address and the exact same service request type are used. Streets and Sanitation responds to the initial request opened and closes the duplicates. A forestry "Clam" is the name of the vehicle the Forestry Bureau deploys to collect tree debris.

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

                                Request Tree Debris Removal (https://servicerequest.cityofchicago.org/web_intake_chic/Controller?op=locform&invSRType=SEL&invSRDesc=Tree%20Debris&locreq=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-tree-debris-historical-mab8-y9h3\".\"311_service_requests_tree_debris_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 311_service_requests_tree_debris_historical
     
     
     
     
     
Upstream Metadata