About this Dataset

311 Service Requests - Tree Debris - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, 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).
Organization: City of Chicago
Last updated: 2020-11-10T16:55:08.721903
Tags: 311, historical, service-requests, trees

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_tree_debris_historical.table_1

11.97 MB
163414 rows
18 columns


CREATE TABLE table_1 (
  "creation_date" TIMESTAMP,
  "status" VARCHAR,
  "completion_date" TIMESTAMP,
  "service_request_number" VARCHAR,
  "type_of_service_request" VARCHAR,
  "if_yes_where_is_the_debris_located" VARCHAR,
  "current_activity" VARCHAR,
  "most_recent_action" VARCHAR,
  "street_address" VARCHAR,
  "zip_code" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "ward" DOUBLE,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);