Pothole Repair Requests

Performance & Analytics Updated Aug 12, 2026 Daily

About this dataset

Requests for pothole repair 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
Pothole Repair Requests	Download Copy URL	CSV	37.99 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	2841779
service_request_parent_id
sap_notification_number	040300226839
date_requested	2020-01-05T09:42:00
case_age_days	473
case_record_type	TSW
service_name	Pothole
service_name_detail
date_closed	2021-04-22
status	Closed
lat	32.730558900000000
lng	-117.148830800000000
street_address	1900 PARK BL
zipcode	92101
council_district	3
comm_plan_code	1
comm_plan_name	Balboa Park
park_name	BALBOA PARK
case_origin	Mobile
referred	This report has been referred to Park and Recreation at askparks@sandiego.gov
iamfloc	SS-021192-PV1
floc	SS-021192-PV1
public_description	Pot holes sb park and zoo pl.

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 12, 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