About this Dataset

311 Service Requests - Tree Trims - 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 and completed tree trim requests made to 311 since January 1, 2011. The Department of Streets and Sanitation maintains all trees growing in the public way and performs regular maintenance trimming in response to 311 requests. Crisis trimming is performed on an emergency basis in response to hazardous conditions such as broken or hanging branches. Requests that have been labeled as Duplicates are in the same geographic area and have been entered into 311’s Customer Service Requests (CSR) system at around the same time as a previous request. Duplicate requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:30.472001
Tags: 311, historical, service-requests, trees

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_tree_trims_historical.table_1

25.15 MB
362,957 rows
16 columns

CREATE TABLE table_1 (
  "creation_date" TIMESTAMP,
  "status" VARCHAR,
  "completion_date" TIMESTAMP,
  "service_request_number" VARCHAR,
  "type_of_service_request" VARCHAR,
  "location_of_trees" 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
);