Graffiti Removal Requests

Performance & Analytics Updated May 11, 2026 Daily

About this dataset

Requests for graffiti removal received by the Get It Done program.

Get the data

Browse the table below for all files available for this dataset

Data Downloads

File name	Download actions	File Format	File size
Graffiti Removal Requests	Download Copy URL	CSV	66.23 MB

View a data sample

Showing 1 transposed sample row. Download the full dataset or a view to get the data.

Data Sample

Data preview - first row of dataset transposed
Field	Sample Value
service_request_parent_id	3262636
sap_notification_number
date_requested	2021-03-02T16:32:00
case_age_days	1
case_record_type	TSW
service_name	Graffiti
service_name_detail	Graffiti Removal
date_closed	2021-03-03
status	Referred
lat	32.690563600885520
lng	-117.117025146661000
street_address	3603 Birch St
zipcode	92113
council_district	8
comm_plan_code	37
comm_plan_name	Southeastern San Diego
park_name	SOUTH CREST TRAILS NP
case_origin	Mobile
referred	This report has been referred to Park and Recreation at askparks@sandiego.gov
iamfloc	SS-004257
floc	SS-004257
public_description	Graffiti on bridge floor past the skate park.

Understand the data

Each field in the data is defined in the table below. Use this information to inform usage of the data.

Download dictionary

Data Dictionary

Data dictionary - field definitions for this dataset
field	description	data_type
service_request_id	A unique identifier for each request that also serves as a customer's report number for tracking purposes	String
service_request_parent_id	If the request has been determined to be a duplicate of an existing, open request, the original request is the parent and subsequent requests are children. All children will have the service_request_id of the parent in this field.	String
sap_notification_number	If the request is managed in the City's SAP system, this field will contain a unique identifier for the request used within SAP.	String
date_requested	The date and time when the service request was made	Datetime
case_age_days	The number of days, rounded to the nearest whole day, between request submission and request closure	Integer
case_record_type	A higher-level grouping of service names that corresponds to the City staff group responsible for responding to the request	String
service_name	A classification of the type of service to be performed	String
service_name_detail	Further detail on the type of service to be performed	String
date_closed	The date and time when the service request was last modified. For requests with a status of closed or referred, this will be the date the request was closed or referred.	Date
status	The current state of the service request	String
lat	Latitude for request location	Float
lng	Longitude for request location	Float
street_address	Street address for request location	String
zipcode	ZIP code for request location	String
council_district	If available, the council district where the service was requested	String
comm_plan_code	If available, a numeric code corresponding to the community where the service was requested	String
comm_plan_name	If available, the community name where the service was requested	String
park_name	If applicable, the park or open space area where the service was requested	String
case_origin	Method by which the requestor submitted the request	String
referred	When a case has a status of referred, this field indicates to where the case was referred	String
iamfloc	City asset functional location in current asset management system	String
floc	City asset functional location in legacy asset management system	String
public_description	The description submitted by the reporting party	String
specify_the_issue	Detail on the type of illegal dumping service request. This field is only available in the illegal dumping specific dataset.	String

PublisherPerformance & Analytics
Last Updated May 11, 2026
Update Frequency Daily
Date Issued Jun 13, 2017
Available Formats .CSV
License View License

311 Services Surveys Get it Done

Data & Analytics

data@sandiego.gov