Pothole Repair Requests
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 |
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
| Field | Sample Value |
|---|---|
| service_request_id | 5380295 |
| service_request_parent_id | |
| sap_notification_number | 040301040156 |
| date_requested | 2025-09-17 21:05:00.000 |
| case_age_days | 1 |
| case_record_type | TSW |
| service_name | Pothole |
| service_name_detail | |
| date_closed | 2025-09-18 |
| status | Referred |
| lat | 32.93558343 |
| lng | -117.22806908 |
| street_address | 11922 Carmel Creek Rd, San Diego, CA 92130, USA |
| zipcode | 92130 |
| council_district | 1 |
| comm_plan_code | 21 |
| comm_plan_name | CARMEL VALLEY |
| park_name | CARMEL VALLEY CVREP |
| case_origin | Web |
| referred | Your request has been referred to SDG&E. To contact SDG&E, please call 800-411-7343. For emergencies, dial 9-1-1. |
| iamfloc | SS-006390-PV1 |
| floc | SS-006390-PV1 |
| public_description | Metal doors protruding in roadway causing significant vehicle / tire damage risk - see attached photos || LOCATION: Carmel Creek Road just before Shaw Ridge Road || LANE: Right hand turn lane || DIRECTION: Eastbound |
Understand the data
Each field in the data is defined in the table below. Use this information to inform usage of the data.
Download dictionaryData Dictionary
| Field | Data_type | Description | Possible_values |
|---|---|---|---|
| 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
Data & Analytics
data@sandiego.gov