Get It Done Reports

Reports of non-emergency problems submitted by users of Get It Done

sandiego.gov-get_it_done-1.1.2. Modified 2022-05-20T21:17:32

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

The Get It Done program allows residents and visitors 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.

This data package combines multiple years of the source data into a single file and adds a WKT format geometry.

Contacts

Data Dictionary

gid_requests | gid_rast

gid_requests

Column NameData TypeDescription
indexinteger
service_request_idintegerA unique identifier for each request that also serves as a customer’s report number for tracking purposes
service_request_parent_idintegerIf 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_numberintegerIf the request is managed in the City’s SAP system, this field will contain a unique identifier for the request used within SAP.
date_requesteddatetime
case_age_daysintegerThe number of days, rounded to the nearest whole day, between request submission and request closure
case_record_typestringA higher-level grouping of service names that corresponds to the City staff group responsible for responding to the request
service_namestringA classification of the type of service to be performed
date_closeddatetime
statusstringThe current state of the service request
latnumberLatitude for request location
lngnumber
street_addresstext
zipcodeinteger
council_districtintegerIf available, the council district where the service was requested
comm_plan_codeintegerIf available, a numeric code corresponding to the community where the service was requested
comm_plan_namestringIf available, the community name where the service was requested
park_namestringIf applicable, the park or open space area where the service was requested
case_originstringMethod by which the requestor submitted the request
referredstringWhen a case has a status of referred, this field indicates to where the case was referred
public_descriptionstringThe description submitted by the reporting party
iamflocstring
flocstring
geometrystring
in_countystring

gid_rast

Column NameData TypeDescription
service_codestring
geometrystring

References

Urls used in the creation of this data package.

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


gid_requests_df =  pd.read_csv('http://library.metatab.org/sandiego.gov-get_it_done-1.1.2/data/gid_requests.csv')
gid_rast_df =  pd.read_csv('http://library.metatab.org/sandiego.gov-get_it_done-1.1.2/data/gid_rast.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiego.gov-get_it_done-1.1.2.zip')

# Create Dataframes
gid_requests_gdf = pkg.resource('gid_requests').geoframe()
gid_rast_gdf = pkg.resource('gid_rast').geoframe()