San Diego Police Calls for Service

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 | Packages | Documentation| Contacts| References| Data Dictionary

Resources

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.

Contacts

Data Dictionary

sdpd_calls_dispositions | sdpd_beats | sdpd_calls_for_service | sdpd_call_type | ct_map

sdpd_calls_dispositions

Column NameData TypeDescription
dispositionstring
descriptionstring

sdpd_beats

Column NameData TypeDescription
beatstring
neighborhoodstring

sdpd_calls_for_service

Column NameData TypeDescription
incident_numstring
date_timedatetime
day_of_weekinteger
address_number_primaryinteger
address_dir_primarystring
address_road_primarystring
address_sfx_primarystring
address_dir_intersectingstring
address_road_intersectingstring
address_sfx_intersectingstring
call_typestring
dispositionstring
beatstring
priorityinteger

sdpd_call_type

Column NameData TypeDescription
call_typestring
descriptionstring

ct_map

Column NameData TypeDescription
call_type_descstring
simple_ctstring

References

Urls used in the creation of this data package.

Packages

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()