About this Dataset

311 Service Requests - Graffiti Removal - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, 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.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:58.450449
Tags: 311, graffiti, historical, service-requests

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_graffiti_removal__7419c05e.table_1

70 MB
1,052,679 rows
18 columns

CREATE TABLE table_1 (
  "creation_date" TIMESTAMP,
  "status" VARCHAR,
  "completion_date" TIMESTAMP,
  "service_request_number" VARCHAR,
  "type_of_service_request" VARCHAR,
  "what_type_of_surface_is_the_graffiti_on" VARCHAR  -- What Type Of Surface Is The Graffiti On?,
  "where_is_the_graffiti_located" VARCHAR  -- Where Is The Graffiti Located?,
  "street_address" VARCHAR,
  "zip_code" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "ward" DOUBLE,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "ssa" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);