Reports of non-emergency problems submitted to Get It Done

Performance & Analytics Updated May 24, 2026 Daily

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 Copy URL	CSV	31.26 MB
Get It Done Requests closed in 2026	Download Copy URL	CSV	57.74 MB
Get It Done Requests closed in 2025	Download Copy URL	CSV	131.20 MB
Get It Done Requests closed in 2024	Download Copy URL	CSV	140.53 MB
Get It Done Requests closed in 2023	Download Copy URL	CSV	136.81 MB
Get It Done Requests closed in 2022	Download Copy URL	CSV	112.10 MB
Get It Done Requests closed in 2021	Download Copy URL	CSV	116.74 MB
Get It Done Requests closed in 2020	Download Copy URL	CSV	108.61 MB
Get It Done Requests closed in 2019	Download Copy URL	CSV	117.79 MB
Get It Done Requests closed in 2018	Download Copy URL	CSV	71.66 MB
Get It Done Requests closed in 2017	Download Copy URL	CSV	59.37 MB
Get It Done Requests closed in 2016	Download Copy URL	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

Data preview - first row of dataset transposed
Field	Sample Value
service_request_parent_id	4452563
sap_notification_number	040300911797
date_requested	2024-06-24T14:44:00
case_age_days	699
case_record_type	TSW
service_name	Street Light Maintenance
service_name_detail	STREET LIGHT OUT
date_closed
status	In Process
lat	32.804639279075750
lng	-117.183046216738700
street_address	East Clairemont Athletic Area
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	PL-303713
floc	SS-019136
public_description	Two after dark park lights not working over sidewalks.

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	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 24, 2026
Update Frequency Daily
Date Issued May 26, 2016
Available Formats .CSV
License View License

311 Services Surveys Get It Done

Data & Analytics

data@sandiego.gov