Tree Trims Requested by 311 Service

This dataset shows the tree trims request reported by the 311 Service. It includes all open requests and all completed requests since December 03, 2011.

Complexity

Get The Data

For getting access to data download links please read and accept the end-user license agreement.

Your Data License

Research
Non-Commercial, Share-Alike, Attribution Free Forever
Commercial
Commercial Use, Remix & Adapt, White Label Log in to download

Description

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.”

About this Dataset

Data Info

Date Created	2011-09-30
Last Modified	2019-10-09
Version	2019-10-09
Update Frequency	Quarterly
Temporal Coverage	2011-2019
Spatial Coverage	City Of Chicago
Source	John Snow Labs; Data City Of Chicago;
Source License URL
Source License Requirements	N/A
Source Citation	N/A
Keywords	Tree Trims, 311 Service Request, Street and Sanitation, Trees Growing, Tree Trimming, Broken Trees, Broken Branches, Trees
Other Titles	Tree Trimming in Chicago, Trees in Public Areas

Data Fields

Name	Description	Type	Constraints
Creation_Date	Date Service Request was received	date	-
Status	Status of the Service Request (Completed, Completed-Dup)	string	-
Completion_Date	Date Service Request was received	date	-
Service_Request_Number	A unique Service Request number for reporting	string	-
Location_of_Trees	Location of the requested trees	string	-
Street_Address	Address Street number of the tree	string	-
ZIP_Code	Zip Code of building	integer	level : Nominal
Ward_Number	Ward number assigned with physical address	integer	level : Nominal
Police_District	Police District number of physical address	integer	level : Nominal
Community_Area	Indicates the community area where the tree trimming was requested. Chicago has 77 community areas.	integer	level : Nominal
Latitude	Latitude Location	number	-
Longitude	Longitude Location	number	-

Data Preview

Creation Date	Status	Completion Date	Service Request Number	Location of Trees	Street Address	ZIP Code	Ward Number	Police District	Community Area	Latitude	Longitude
2010-06-15	Completed	2011-10-21	10-00862558		7237 S AVERS AVE	60629	13	8	65	41.76166254	-87.71864092
2010-06-15	Completed	2012-10-24	10-00861435	Parkway	7827 S TRUMBULL AVE	60652	18	8	70	41.75105197	-87.70852967
2010-06-15	Completed	2011-10-25	10-00853312	Parkway	1821 W EDDY ST	60657	47	19	5	41.94599214	-87.67444915
2010-06-15	Completed	2011-10-26	10-00856362	Parkway	10053 S EBERHART AVE	60628	9	5	49	41.71184438	-87.61145179
2010-06-15	Completed	2011-10-26	10-00858764	Parkway	5234 W PENSACOLA AVE	60641	38	16	15	41.95967881	-87.75820261
2010-06-15	Completed	2011-10-27	10-00860705	Parkway	4504 N HAZEL ST	60640	46	23	3	41.96377317	-87.65236818
2010-06-15	Completed	2011-10-31	10-00857478	Parkway	9157 S UNION AVE	60620	21	22	73	41.72774771	-87.64095986
2010-06-15	Completed	2011-10-31	10-00860381	Parkway	8854 S LOWE AVE	60620	21	22	71	41.7333734	-87.63989369
2010-06-15	Completed	2011-11-01	10-00855789	Parkway	9124 S LUELLA AVE	60617	7	4	48	41.72940085	-87.56944558
2010-06-15	Completed	2012-11-02	10-00854370	Parkway	7241 W MYRTLE AVE	60631	41	16	10	41.99354352	-87.80829481

Others titles

Keywords