Graffiti Removal Requests

Performance & Analytics Updated Oct 21, 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.77 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_id	3120337
service_request_parent_id	3120204
sap_notification_number
date_requested	2020-10-21 18:13:00.000
case_age_days	1
case_record_type	TSW
service_name	Graffiti
service_name_detail	Graffiti Removal
date_closed	2020-10-22
status	Referred
lat	32.75923204
lng	-117.19630046
street_address	4310 TAYLOR ST, San Diego, CA 92110, USA
zipcode	92110
council_district	2
comm_plan_code	24
comm_plan_name	OLD TOWN SAN DIEGO
park_name	PRESIDIO PARK
case_origin	Mobile
referred	This report has been referred to Park and Recreation at askparks@sandiego.gov
iamfloc	SS-026219
floc	SS-026219
public_description	Graffiti on retaining wall facing 8 east up on presidio de San diego

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	Data_type	Description
service_request_id	String	A unique identifier for each request that also serves as a customer's report number for tracking purposes
service_request_parent_id	String	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.
sap_notification_number	String	If the request is managed in the City's SAP system, this field will contain a unique identifier for the request used within SAP.
date_requested	Datetime	The date and time when the service request was made
case_age_days	Integer	The number of days, rounded to the nearest whole day, between request submission and request closure
case_record_type	String	A higher-level grouping of service names that corresponds to the City staff group responsible for responding to the request
service_name	String	A classification of the type of service to be performed
service_name_detail	String	Further detail on the type of service to be performed
date_closed	Date	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.
status	String	The current state of the service request
lat	Float	Latitude for request location
lng	Float	Longitude for request location
street_address	String	Street address for request location
zipcode	String	ZIP code for request location
council_district	String	If available, the council district where the service was requested
comm_plan_code	String	If available, a numeric code corresponding to the community where the service was requested
comm_plan_name	String	If available, the community name where the service was requested
park_name	String	If applicable, the park or open space area where the service was requested
case_origin	String	Method by which the requestor submitted the request
referred	String	When a case has a status of referred, this field indicates to where the case was referred
iamfloc	String	City asset functional location in current asset management system
floc	String	City asset functional location in legacy asset management system
public_description	String	The description submitted by the reporting party

PublisherPerformance & Analytics
Last Updated Oct 21, 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