311 Service Requests - Tree Trims

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id uxic-zsuj
Name 311 Service Requests - Tree Trims
Attribution City of Chicago
Category Service Requests
Tags trees
Created 2011-09-30T09:03:58Z
Publication Date 2017-04-20T08:43:28Z

Description

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.

Columns

| Included | Schema Type | Field Name              | Name                    | Data Type     | Render Type   |
| ======== | =========== | ======================= | ======================= | ============= | ============= |
| Yes      | time        | creation_date           | Creation Date           | calendar_date | calendar_date |
| Yes      | series tag  | status                  | Status                  | text          | text          |
| No       |             | completion_date         | Completion Date         | calendar_date | calendar_date |
| Yes      | series tag  | service_request_number  | Service Request Number  | text          | text          |
| Yes      | series tag  | type_of_service_request | Type of Service Request | text          | text          |
| Yes      | series tag  | location_of_trees       | Location of Trees       | text          | text          |
| Yes      | series tag  | street_address          | Street Address          | text          | text          |
| Yes      | series tag  | zip_code                | ZIP Code                | text          | number        |
| No       |             | x_coordinate            | X Coordinate            | number        | number        |
| No       |             | y_coordinate            | Y Coordinate            | number        | number        |
| Yes      | series tag  | ward                    | Ward                    | text          | number        |
| Yes      | series tag  | police_district         | Police District         | text          | number        |
| Yes      | series tag  | community_area          | Community Area          | text          | number        |
| No       |             | latitude                | Latitude                | number        | number        |
| No       |             | longitude               | Longitude               | number        | number        |

Time Field

Value = creation_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = completion_date,x_coordinate,y_coordinate,latitude,longitude

Data Commands

series e:uxic-zsuj d:2017-04-20T08:41:21.000Z t:location_of_trees="LOCATION OF TREE(S)" t:status=STATUS t:service_request_number="SERVICE REQUEST NUMBER" t:type_of_service_request="TYPE OF SERVICE REQUEST" t:street_address="STREET ADDRESS" m:row_number.uxic-zsuj=1

series e:uxic-zsuj d:2010-06-15T00:00:00.000Z t:ward=13 t:zip_code=60629 t:police_district=8 t:status=Completed t:service_request_number=10-00862558 t:community_area=65 t:type_of_service_request="Tree Trim" t:street_address="7237 S AVERS AVE" m:row_number.uxic-zsuj=2

series e:uxic-zsuj d:2010-06-15T00:00:00.000Z t:location_of_trees=Parkway t:ward=18 t:zip_code=60652 t:police_district=8 t:status=Completed t:service_request_number=10-00861435 t:community_area=70 t:type_of_service_request="Tree Trim" t:street_address="7827 S TRUMBULL AVE" m:row_number.uxic-zsuj=3

Meta Commands

metric m:row_number.uxic-zsuj p:long l:"Row Number"

entity e:uxic-zsuj l:"311 Service Requests - Tree Trims" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/uxic-zsuj

property e:uxic-zsuj t:meta.view v:id=uxic-zsuj v:category="Service Requests" v:attributionLink=http://www.cityofchicago.org v:averageRating=0 v:name="311 Service Requests - Tree Trims" v:attribution="City of Chicago"

property e:uxic-zsuj t:meta.view.owner v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:displayName=cocadmin v:privilegesDisabled=false

property e:uxic-zsuj t:meta.view.tableauthor v:id=scy9-9wg4 v:profileImageUrlMedium=/api/users/scy9-9wg4/profile_images/THUMB v:profileImageUrlLarge=/api/users/scy9-9wg4/profile_images/LARGE v:screenName=cocadmin v:profileImageUrlSmall=/api/users/scy9-9wg4/profile_images/TINY v:roleName=administrator v:displayName=cocadmin v:privilegesDisabled=false

Top Records

| creation_date       | status    | completion_date     | service_request_number | type_of_service_request | location_of_trees   | street_address       | zip_code | x_coordinate     | y_coordinate     | ward | police_district | community_area | latitude           | longitude          | 
| =================== | ========= | =================== | ====================== | ======================= | =================== | ==================== | ======== | ================ | ================ | ==== | =============== | ============== | ================== | ================== | 
|                     | STATUS    |                     | SERVICE REQUEST NUMBER | TYPE OF SERVICE REQUEST | LOCATION OF TREE(S) | STREET ADDRESS       |          |                  |                  |      |                 |                |                    |                    | 
| 2010-06-15T00:00:00 | Completed | 2011-10-21T00:00:00 | 10-00862558            | Tree Trim               |                     | 7237 S AVERS AVE     | 60629    | 1151953.62467509 | 1856339.87741701 | 13   | 8               | 65             | 41.761662537751896 | -87.71864092116586 | 
| 2010-06-15T00:00:00 | Completed | 2012-10-24T00:00:00 | 10-00861435            | Tree Trim               | Parkway             | 7827 S TRUMBULL AVE  | 60652    | 1154740.32239948 | 1852493.35850165 | 18   | 8               | 70             | 41.75105196947029  | -87.70852966806123 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-25T00:00:00 | 10-00853312            | Tree Trim               | Parkway             | 1821 W EDDY ST       | 60657    | 1163494.90581942 | 1923598.31991667 | 47   | 19              | 5              | 41.94599213964815  | -87.67444914936094 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-26T00:00:00 | 10-00856362            | Tree Trim               | Parkway             | 10053 S EBERHART AVE | 60628    | 1181349.96050284 | 1838413.81057416 | 9    | 5               | 49             | 41.711844378036105 | -87.61145178817645 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-26T00:00:00 | 10-00858764            | Tree Trim               | Parkway             | 5234 W PENSACOLA AVE | 60641    | 1140676.79589838 | 1928421.76690904 | 38   | 16              | 15             | 41.95967881175858  | -87.75820260590397 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-27T00:00:00 | 10-00860705            | Tree Trim               | Parkway             | 4504 N HAZEL ST      | 60640    | 1169450.42570757 | 1930124.74318279 | 46   | 23              | 3              | 41.96377316813134  | -87.65236817807583 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-31T00:00:00 | 10-00857478            | Tree Trim               | Parkway             | 9157 S UNION AVE     | 60620    | 1173246.53016976 | 1844142.6461135  | 21   | 22              | 73             | 41.72774771271878  | -87.64095985991771 | 
| 2010-06-15T00:00:00 | Completed | 2011-10-31T00:00:00 | 10-00860381            | Tree Trim               | Parkway             | 8854 S LOWE AVE      | 60620    | 1173521.04801317 | 1846194.93280289 | 21   | 22              | 71             | 41.73337340306709  | -87.63989369033915 | 
| 2010-06-15T00:00:00 | Completed | 2011-11-01T00:00:00 | 10-00855789            | Tree Trim               | Parkway             | 9124 S LUELLA AVE    | 60617    | 1192762.4966149  | 1844910.16292461 | 7    | 4               | 48             | 41.72940084764093  | -87.56944558250703 |