311 Service Requests - Tree Debris

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.cityofchicago.org
Id mab8-y9h3
Name 311 Service Requests - Tree Debris
Attribution City of Chicago
Category Service Requests
Tags trees
Created 2011-09-30T09:06:05Z
Publication Date 2017-04-20T08:45:28Z

Description

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

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  | if_yes_where_is_the_debris_located_ | If Yes, where is the debris located? | text          | text          |
| Yes      | series tag  | current_activity                    | Current Activity                     | text          | text          |
| Yes      | series tag  | most_recent_action                  | Most Recent Action                   | 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:mab8-y9h3 d:2017-04-20T08:44:15.000Z t:most_recent_action="MOST RECENT ACTION" t:status=STATUS t:service_request_number="SERVICE REQUEST NUMBER" t:current_activity="CURRENT ACTIVITY" t:type_of_service_request="TYPE OF SERVICE REQUEST" t:street_address="STREET ADDRESS" t:if_yes_where_is_the_debris_located_="IF YES, WHERE IS THE DEBRIS LOCATED?" m:row_number.mab8-y9h3=1

series e:mab8-y9h3 d:2011-01-01T00:00:00.000Z t:ward=35 t:police_district=14 t:zip_code=60647 t:most_recent_action="*Complete the Service Request" t:status=Completed t:service_request_number=11-00001766 t:current_activity="Dispatch Clam" t:community_area=22 t:type_of_service_request="Tree Debris" t:street_address="2524 N MOZART ST" t:if_yes_where_is_the_debris_located_=Parkway m:row_number.mab8-y9h3=2

series e:mab8-y9h3 d:2012-01-01T00:00:00.000Z t:ward=9 t:police_district=22 t:zip_code=60628 t:most_recent_action="*Complete the Service Request" t:status=Completed t:service_request_number=12-00001807 t:current_activity="Dispatch Clam" t:community_area=73 t:type_of_service_request="Tree Debris" t:street_address="10132 S EGGLESTON AVE" t:if_yes_where_is_the_debris_located_=Parkway m:row_number.mab8-y9h3=3

Meta Commands

metric m:row_number.mab8-y9h3 p:long l:"Row Number"

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

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

property e:mab8-y9h3 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:mab8-y9h3 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 | if_yes_where_is_the_debris_located_  | current_activity | most_recent_action            | street_address         | zip_code | x_coordinate     | y_coordinate     | ward | police_district | community_area | latitude           | longitude          | 
| =================== | =============== | =================== | ====================== | ======================= | ==================================== | ================ | ============================= | ====================== | ======== | ================ | ================ | ==== | =============== | ============== | ================== | ================== | 
|                     | STATUS          |                     | SERVICE REQUEST NUMBER | TYPE OF SERVICE REQUEST | IF YES, WHERE IS THE DEBRIS LOCATED? | CURRENT ACTIVITY | MOST RECENT ACTION            | STREET ADDRESS         |          |                  |                  |      |                 |                |                    |                    | 
| 2011-01-01T00:00:00 | Completed       | 2011-01-04T00:00:00 | 11-00001766            | Tree Debris             | Parkway                              | Dispatch Clam    | *Complete the Service Request | 2524 N MOZART ST       | 60647    | 1156945.33866643 | 1916756.54337137 | 35   | 14              | 22             | 41.92735345762709  | -87.69870933383872 | 
| 2012-01-01T00:00:00 | Completed       | 2012-01-03T00:00:00 | 12-00001807            | Tree Debris             | Parkway                              | Dispatch Clam    | *Complete the Service Request | 10132 S EGGLESTON AVE  | 60628    | 1175293.29133151 | 1837607.05001364 | 9    | 22              | 73             | 41.70976771267409  | -87.63365681877502 | 
| 2012-01-01T00:00:00 | Completed       | 2012-01-03T00:00:00 | 12-00002563            | Tree Debris             | Alley                                | Dispatch Clam    | *Complete the Service Request | 362 E 89TH PL          | 60619    | 1180205.64151591 | 1845719.96819315 | 6    | 6               | 44             | 41.73191964410131  | -87.61541942144278 | 
| 2013-01-01T00:00:00 | Completed       | 2013-01-02T00:00:00 | 13-00000901            | Tree Debris             | Parkway                              | Dispatch Clam    | *Complete the Service Request | 9117 S URBAN AVE       | 60619    | 1178270.54451797 | 1844417.51018182 | 6    | 6               | 49             | 41.72838960811961  | -87.62254782298375 | 
| 2011-01-02T00:00:00 | Completed - Dup | 2011-01-04T00:00:00 | 11-00003981            | Tree Debris             | Parkway                              |                  |                               | 4102 N WOLCOTT AVE     | 60613    | 1162939.86399482 | 1927268.10909903 | 47   | 19              | 5              | 41.956073918430725 | -87.67638589575405 | 
| 2011-01-02T00:00:00 | Completed       | 2011-01-03T00:00:00 | 11-00004699            | Tree Debris             | Alley                                | Dispatch Clam    | *Complete the Service Request | 5005 W FOSTER AVE      | 60630    | 1142024.27000674 | 1934113.37317787 | 45   | 16              | 12             | 41.97527212775161  | -87.753106915463   | 
| 2011-01-02T00:00:00 | Completed       | 2011-01-04T00:00:00 | 11-00004573            | Tree Debris             | Parkway                              | Dispatch Clam    | *Complete the Service Request | 5055 W CRYSTAL ST      | 60651    | 1142433.81368532 | 1907849.68338768 | 37   | 25              | 25             | 41.90319442254708  | -87.75225553106478 | 
| 2012-01-02T00:00:00 | Completed       | 2012-01-03T00:00:00 | 12-00003746            | Tree Debris             | Alley                                |                  |                               | 5823 W SUPERIOR ST     | 60644    | 1137460.64980662 | 1904410.01240658 | 29   | 15              | 25             | 41.89384652397142  | -87.77060612900046 | 
| 2012-01-02T00:00:00 | Completed       | 2012-01-03T00:00:00 | 12-00005038            | Tree Debris             | Alley                                | Dispatch Clam    | *Complete the Service Request | 5832 N EAST CIRCLE AVE | 60631    | 1129204.09493102 | 1938425.07941851 | 41   | 16              | 10             | 41.9873324710467   | -87.80015328916164 |