Graffiti Removal Requests

Performance & Analytics Updated Aug 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	5618718
service_request_parent_id	5682142
sap_notification_number
date_requested	2026-03-09T11:34:00
case_age_days	50
case_record_type	TSW ROW
service_name	Graffiti - Code Enforcement
service_name_detail	Commercial Property
date_closed	2026-04-28
status	Referred
lat	32.753506225971410
lng	-117.134506205206280
street_address	2719 Howard Ave
zipcode	92104
council_district	3
comm_plan_code	28
comm_plan_name	NORTH PARK
park_name	NORTH PARK CP
case_origin	Mobile
referred	Your request has been forwarded to: wcm_gid@sandiego.gov. For information about your request 05682142 contact wcm_gid@sandiego.gov
iamfloc	SS-020673
floc	SS-020673
public_description	Graffiti on wall in the North Park area.

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 Aug 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