311 Service Requests - Graffiti Removal - Historical

data.cityofchicago.org | Last Updated 7 Mar 2019

As described in http://bit.ly/311HistoricalPost, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only. All open graffiti removal requests made to 311 and all requests completed since January 1, 2011. The Department of Streets & Sanitation's Graffiti Blasters crews offer a vandalism removal service to private property owners. Graffiti Blasters employ "blast" trucks that use baking soda under high water pressure to erase painted graffiti from brick, stone and other mineral surfaces. They also use paint trucks to cover graffiti on the remaining surfaces. Organizations and residents may report graffiti and request its removal. 311 sometimes receives duplicate requests for graffiti removal. 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 reports/requests are labeled as such in the Status field, as either "Open - Dup" or "Completed - Dup." Data is updated daily.

Tags: graffiti, historical

This dataset has the following 18 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
Creation Datecreation_datecalendar_date
Statusstatustext
Completion Datecompletion_datecalendar_date
Service Request Numberservice_request_numbertext
Type of Service Requesttype_of_service_requesttext
What Type of Surface is the Graffiti on?what_type_of_surface_is_the_graffiti_on_text
Where is the Graffiti located?where_is_the_graffiti_located_text
Street Addressstreet_addresstext
ZIP Codezip_codenumber
X Coordinatex_coordinatenumber
Y Coordinatey_coordinatenumber
Wardwardnumber
Police Districtpolice_districtnumber
Community Areacommunity_areanumber
SSAssatextSpecial Service Areas are local tax districts that fund expanded services and programs, to foster commercial and economic development, through a localized property tax. In other cities these areas are sometimes called Business Improvement Districts (BIDs). This portal contains a map of all Chicago SSAs
Latitudelatitudenumber
Longitudelongitudenumber
Locationlocationlocation