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.68 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_parent_id | |
| sap_notification_number | 040300139377 |
| date_requested | 2019-06-20T07:06:00 |
| case_age_days | 672 |
| case_record_type | TSW |
| service_name | Pothole |
| service_name_detail | |
| date_closed | 2021-04-22 |
| status | Closed |
| lat | 32.759143600000000 |
| lng | -117.193938800000010 |
| street_address | 2681 Presidio Dr, San Diego, CA 92108, USA |
| zipcode | 92110 |
| council_district | 2 |
| comm_plan_code | 24 |
| comm_plan_name | Old Town San Diego |
| park_name | PRESIDIO PARK |
| case_origin | Web |
| referred | This report has been referred to Park and Recreation at askparks@sandiego.gov |
| iamfloc | SS-022362-PV1 |
| floc | SS-022362-PV1 |
| public_description | Several bike-destroying potholes on the uphill lane present HAZARDOUS BICYCLING CONDITIONS. Just avoiding the lookie-loo tourists not paying attention to the road is dangerous enough for cyclists, and these potholes force cyclists into worse dangerous situations. PLEASE REPAVE THIS BUSY ROAD. |
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 | 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
Data & Analytics
data@sandiego.gov