San Diego Police Calls for Service, linked to related datasets

sandiego.gov-police_calls_for_service-1.1.1. Modified 2020-06-17T23:58:13

Resources

sdpd_calls_dispositions. San Diego Police Calls for Service, 2015 to 2020
sdpd_beats. San Diego Police beats
sdpd_call_type. San Diego Police call type codes
sdpd_calls_for_service. San Diego Police Calls for Service, 2015 to 2020
ct_map. Map from call type descriptions to simpler call types.

Documentation

This dataset links to the San Dieg Police Calls for Service datasets, from multiple years, combine the years and lints to the destriptions of disposition codes and beat neighborhoods.

Caveats and Adjustments

The meaning of the numbers in the day_of_week column has changed from earlier to later years. Earlier years use values from 0 to 6, while later years use vlaues from 1 to 7. Because of this, the day_of_week vlaues have been re-calculated to the span from 0 to 6, where 0 is Monday and 6 is Sunday.

Documentation Links

Priority codes

Contacts

Wrangler
Eric Busboom, Civic Knowledge

Data Dictionary

sdpd_calls_dispositions | sdpd_beats | sdpd_calls_for_service | sdpd_call_type | ct_map

sdpd_calls_dispositions

Column Name	Data Type	Description
disposition	string
description	string

sdpd_beats

Column Name	Data Type	Description
beat	string
neighborhood	string

sdpd_calls_for_service

Column Name	Data Type	Description
incident_num	string
date_time	datetime
day_of_week	integer
address_number_primary	integer
address_dir_primary	string
address_road_primary	string
address_sfx_primary	string
address_dir_intersecting	string
address_road_intersecting	string
address_sfx_intersecting	string
call_type	string
disposition	string
beat	string
priority	integer

sdpd_call_type

Column Name	Data Type	Description
call_type	string
description	string

ct_map

Column Name	Data Type	Description
call_type_desc	string
simple_ct	string

References

Urls used in the creation of this data package.

calls_for_service_source_2015. San Diego Police Calls for Service, 2015
calls_for_service_source_2016. San Diego Police Calls for Service, 2016
calls_for_service_source_2017. San Diego Police Calls for Service, 2017
calls_for_service_source_2018. San Diego Police Calls for Service, 2018
calls_for_service_source_2019. San Diego Police Calls for Service, 2019
calls_for_service_source_2020. San Diego Police Calls for Service, 2020
disp_codes_2017. Disposition Codes, prior to October 17, 2017
disp_codes. Current disposition codes
beat_codes. Beat Neighborhood Codes
call_type_codes. Call type codes

Packages

s3 s3://library.metatab.org/sandiego.gov-police_calls_for_service-1.1.1.csv
csv http://library.metatab.org/sandiego.gov-police_calls_for_service-1.1.1.csv
source https://github.com/metatab-packages/policedata-collection.git

Accessing Packages in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/sandiego.gov-police_calls_for_service-1.1.1.csv')

# Create Dataframes
sdpd_calls_dispositions_df = pkg.resource('sdpd_calls_dispositions').dataframe()
sdpd_beats_df = pkg.resource('sdpd_beats').dataframe()
sdpd_call_type_df = pkg.resource('sdpd_call_type').dataframe()
sdpd_calls_for_service_df = pkg.resource('sdpd_calls_for_service').dataframe()
ct_map_df = pkg.resource('ct_map').dataframe()