Performance Metrics - Streets & Sanitation - Graffiti Removal
Dataset
| Name | Value |
|---|---|
| Catalog | Link |
| Metadata | Link |
| Data: JSON | 100 Rows |
| Data: CSV | 100 Rows |
| Host | data.cityofchicago.org |
| Id | qcfn-tiw7 |
| Name | Performance Metrics - Streets & Sanitation - Graffiti Removal |
| Attribution | City of Chicago |
| Category | Administration & Finance |
| Tags | performance metrics, service delivery, graffiti |
| Created | 2011-09-22T14:18:26Z |
| Publication Date | 2012-07-16T14:58:35Z |
Description
The Department of Streets & Sanitation’s (DSS) Graffiti Blasters crews offer a vandalism removal service to private property owners. This metric tracks the average number of days DSS takes to complete graffiti removal requests per week. Median days to complete requests as well as total number of requests fulfilled per week are available by mousing over columns. Currently the performance target for completing a graffiti removal request is 10 days. For more information on graffiti removal requests, see https://data.cityofchicago.org/d/hec5-y4x5
Columns
| Included | Schema Type | Field Name | Name | Data Type | Render Type |
| ======== | ============== | ================================================ | ================================================ | ========= | =========== |
| Yes | time | week | Week | text | text |
| Yes | numeric metric | average_days_to_complete_graffiti_removal | Average Days to Complete Graffiti Removal | number | number |
| Yes | numeric metric | total_completed_requests | Total Completed Requests | number | number |
| Yes | numeric metric | median_days_to_complete_graffiti_removal_request | Median Days to Complete Graffiti Removal Request | number | number |
| Yes | numeric metric | target_response_time_days_ | Target Response Time (Days) | number | number |
Time Field
Value = week
Format & Zone = ww,yyyy
Data Commands
series e:qcfn-tiw7 d:2011-04-03T00:00:00.000Z m:average_days_to_complete_graffiti_removal=6.62 m:median_days_to_complete_graffiti_removal_request=2 m:total_completed_requests=2966 m:target_response_time_days_=10
series e:qcfn-tiw7 d:2011-04-10T00:00:00.000Z m:average_days_to_complete_graffiti_removal=4.95 m:median_days_to_complete_graffiti_removal_request=2 m:total_completed_requests=2722 m:target_response_time_days_=10
series e:qcfn-tiw7 d:2011-04-17T00:00:00.000Z m:average_days_to_complete_graffiti_removal=6.67 m:median_days_to_complete_graffiti_removal_request=2 m:total_completed_requests=2602 m:target_response_time_days_=10
Meta Commands
metric m:average_days_to_complete_graffiti_removal p:float l:"Average Days to Complete Graffiti Removal" t:dataTypeName=number
metric m:total_completed_requests p:integer l:"Total Completed Requests" t:dataTypeName=number
metric m:median_days_to_complete_graffiti_removal_request p:integer l:"Median Days to Complete Graffiti Removal Request" t:dataTypeName=number
metric m:target_response_time_days_ p:integer l:"Target Response Time (Days)" t:dataTypeName=number
entity e:qcfn-tiw7 l:"Performance Metrics - Streets & Sanitation - Graffiti Removal" t:attribution="City of Chicago" t:url=https://data.cityofchicago.org/api/views/qcfn-tiw7
property e:qcfn-tiw7 t:meta.view v:id=qcfn-tiw7 v:category="Administration & Finance" v:attributionLink=http://www.cityofchicago.org/performance v:averageRating=0 v:name="Performance Metrics - Streets & Sanitation - Graffiti Removal" v:attribution="City of Chicago"
property e:qcfn-tiw7 t:meta.view.owner v:id=vi9p-p863 v:screenName="Eric Phillips" v:displayName="Eric Phillips"
property e:qcfn-tiw7 t:meta.view.tableauthor v:id=vi9p-p863 v:screenName="Eric Phillips" v:displayName="Eric Phillips"
Top Records
| week | average_days_to_complete_graffiti_removal | total_completed_requests | median_days_to_complete_graffiti_removal_request | target_response_time_days_ |
| ===================== | ========================================= | ======================== | ================================================ | ========================== |
| April 3 - 9, 2011 | 6.62 | 2966 | 2 | 10 |
| April 10 - 16, 2011 | 4.95 | 2722 | 2 | 10 |
| April 17 - 23, 2011 | 6.67 | 2602 | 2 | 10 |
| April 24 - 30, 2011 | 3.9 | 3201 | 1 | 10 |
| May 1 - 7, 2011 | 3.76 | 2791 | 2 | 10 |
| May 8 - 14, 2011 | 4.1 | 2860 | 1 | 10 |
| May 15 - 21, 2011 | 3.28 | 2751 | 1 | 10 |
| May 22 - 28, 2011 | 3.15 | 2839 | 1 | 10 |
| May 29 - June 4, 2011 | 3.82 | 2087 | 1 | 10 |
| June 5 - 11, 2011 | 3.69 | 2869 | 1 | 10 |