Reports of non-emergency problems submitted to Get It Done
About this dataset
Reports received by the Get it Done program. Get It Done receives and routes reports for certain types of non-emergency problems.
The Get It Done program allows people to report certain types of non-emergency problems to the City using the Get It Done mobile app, web app, or by telephone. This dataset contains all Get It Done reports the City has received since the program launched in May 2016.
The scope of this data is limited to information from the reports users submit through Get It Done. This data does not include details about any work performed to fix a problem or the date and time work was completed. Reports that are referred outside of the Get It Done system have a status of “Referred”.
Please note that this data includes every user-submitted report and should not be considered an official record of City maintenance work. For example, users might submit problems that have already been reported, that are the responsibility of another government agency or private business, that cannot be found or verified, or that are already scheduled to be fixed in a long-term maintenance plan. The details about how the City addressed each report are outside of the scope of this dataset.
If you have any questions about this data, please contact pandatech@sandiego.gov. If you have questions about your Get It Done report, please refer to your confirmation email.
Get the data
Browse the table below for all files available for this dataset
Data Downloads
| File name | Download actions | File Format | File size |
|---|---|---|---|
| Open Get It Done Requests | Download |
CSV |
31.62 MB |
| Get It Done Requests closed in 2026 | Download |
CSV |
60.40 MB |
| Get It Done Requests closed in 2025 | Download |
CSV |
131.20 MB |
| Get It Done Requests submitted in Council District (CD) 1 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 2 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 3 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 4 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 5 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 6 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 7 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 8 | Download |
CSV |
|
| Get It Done Requests submitted in Council District (CD) 9 | Download |
CSV |
|
| Get It Done Requests closed in 2024 | Download |
CSV |
140.53 MB |
| Get It Done Requests closed in 2023 | Download |
CSV |
136.81 MB |
| Get It Done Requests closed in 2022 | Download |
CSV |
112.10 MB |
| Get It Done Requests closed in 2021 | Download |
CSV |
116.74 MB |
| Get It Done Requests closed in 2020 | Download |
CSV |
108.61 MB |
| Get It Done Requests closed in 2019 | Download |
CSV |
117.79 MB |
| Get It Done Requests closed in 2018 | Download |
CSV |
71.66 MB |
| Get It Done Requests closed in 2017 | Download |
CSV |
59.37 MB |
| Get It Done Requests closed in 2016 | Download |
CSV |
14.23 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 | 5077970 |
| service_request_parent_id | 5041836 |
| sap_notification_number | 040300939022 |
| date_requested | 2025-01-18T15:40:00 |
| case_age_days | 499 |
| case_record_type | Parks & Recreation |
| service_name | Parks Issue |
| service_name_detail | Path/Walkway/Road Pavement/Pothole |
| date_closed | |
| status | In Process |
| lat | 32.803257761808420 |
| lng | -117.183414187861500 |
| street_address | 3451 Mount Acadia Blvd |
| zipcode | 92111 |
| council_district | 2 |
| comm_plan_code | 6 |
| comm_plan_name | CLAIREMONT MESA |
| park_name | E CLAIREMONT ATHL AREA |
| case_origin | Mobile |
| referred | |
| iamfloc | SS-019161-SO1 |
| floc | SS-019161 |
| public_description | 01/05/2025: 01/05/25: An injury occurred at East Clairemont Athletic field near the baseball field and snack bar. An umpire was walking and tripped on uneven concrete. He fell and sliced his hand open. Went to ED for sutures. The concrete is very uneven from tree roots. Very dangerous |
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 Aug 16, 2026
- Update Frequency Daily
- Date Issued May 26, 2016
- Available Formats .CSV
- License View License
Data & Analytics
data@sandiego.gov