SFPD Incident Report

$179 / year

This dataset includes police incident reports filed by officers and by individuals through self-service online reporting for non-emergency cases. Reports included are those for incidents that occurred starting January 1, 2018 onward and have been approved by a supervising officer.

Categories: , ,
Complexity

Incident reports filed by officers are approved by a supervising officer. Once approved and electronically signed by a Sergeant or Lieutenant, no further information is added to the initial report. A supplemental report for additional information or clarification is generated if necessary.

Reports can come from one of three sources. These are discernable through the “Report Type Description” and “Report Type Code” field:
1. Initial: The first report filed for the incident
2. Vehicle: A special incident report related to stolen and/or recovered vehicles
3. Coplogic: Filed online by an individual

Incidents can have one or many associated Incident Codes. For example, an officer may have a warrant for an arrest and while making the arrest discovers narcotics in the individual’s possession. The officer will record an incident code for the warrant as well as the discovery of narcotics.

Coordinates are provided within the dataset where feasible. Coordinates could be missing for the following reasons:
1. Invalid addresses – addresses submitted by officers pass through validation, however, the online submission does not validate addresses on entry. While best efforts are made to match those to valid addresses when loading to the Crime Data Warehouse, there are still technical limitations to fixing all poorly formed addresses.
2. Addresses for incidents outside of SF – some cases are referred from outside San Francisco Police Department (SFPD) districts, these will be marked as Out of SF in the Police District column and not have associated geographic information.

Date Created

2018-09-06

Last Modified

2019-05-20

Version

2019-05-20

Update Frequency

Daily

Temporal Coverage

2019

Spatial Coverage

San Francisco

Source

John Snow Labs; San Francisco Police Department;

Source License URL

Source License Requirements

N/A

Source Citation

N/A

Keywords

San Francisco Crimes, San Francisco Incidents, Incidents of Crime, Crime Victims, Criminal Offenses, Offenses, Police Incidents, San Francisco Offenses

Other Titles

Crimes in San Francisco in 2019, All Reported Incidents in San Francisco

NameDescriptionTypeConstraints
Incident_Date_TimeThe date and time when the incident occurreddatetime-
Incident_DayThe day of the week incident occurredstring-
Report_Date_TimeDistinct from Incident_Date_Time, Report_Date_Time is when the report was filed.datetime-
Incident_IDThis is the system generated identifier for incident reports. An incident report can have multiple incident codes associated. Thus, this identifier, while unique to the report, will be duplicated within this dataset to represent those 1 to many relationships when they exist. Incident IDs and Incident Numbers both uniquely identify reports, but Incident Numbers are what are used and referenced in the cases and report documents.integerlevel : Nominal
Incident_NumberThe number issued on the report, sometimes interchangeably referred to as the Case Numberintegerlevel : Nominal
CAD_NumberThe Computer Aided Dispatch is the system used by the Department of Emergency Management (DEM) to dispatch officers and other public safety personnel. CAD Numbers are assigned by the DEM system and linked to relevant incident reports (Incident Number). Not all Incidents will have a CAD Number. Reports filed online via Coplogic ( see field: Filed Online) will not have a CAD Number and certain other reports not filed through the DEM system will also not have these numbers.integerlevel : Nominal
Report_Type_CodeA system code for report types, these have corresponding descriptions within the dataset.string-
Report_Type_DescriptionThe description of the report type can be one of Initial: Initial; Initial Supplement; Vehicle Initial; Vehicle Supplement; Coplogic Initial; Coplogic Supplementstring-
Is_Filed_OnlinePolice reports filed online for non-emergency cases.boolean-
Incident_CodeIncident Codes are the system codes to describe a type of incident. A single incident report can have one or many incident types associated. In those cases you will see multiple rows representing a unique combination of the Incident ID and Incident Code.integerlevel : Nominal
Incident_CategoryA category mapped on to the Incident Code used in statistics and reporting. Mappings provided by the Crime Analysis Unit of the Police Department.string-
Incident_SubcategoryA subcategory mapped on to the Incident Code used in statistics and reporting. These nest inside the Category field. Mappings provided by the Crime Analysis Unit of the Police Department.string-
Incident_DescriptionThe description of the incident that corresponds with the Incident Code. These are generally self-explanatory.string-
ResolutionThe resolution of the incident at the time of the report. Can be one of: - Cite or Arrest Adult - Cite or Arrest Juvenile - Exceptional Adult - Exceptional Juvenile - Open or Active - Unfounded Note: once a report is filed the resolution does not change on the filed report later.string-
IntersectionThe 2 or more street names that intersect closest to the original incident separated by a forward slash (). Note, the possible intersections will only include those that satisfy the privacy controls.string-
Centerline_Node_NetworkThe unique identifier of the intersection for reference back to other related basemap datasets.integerlevel : Nominal
Police_DistrictThe Police District reflecting current boundaries (boundaries changed in 2015).string-
Analysis_NeighborhoodThe Department of Public Health and the Mayor's Office of Housing and Community Development, with support from the Planning Department, created 41 neighborhoods by grouping 2010 Census tracts, using common real estate and resident definitions for the purpose of providing consistency in the analysis and reporting of socio-economic, demographic, and environmental data, and data on City-funded programs and services.string-
Supervisor_DistrictThere are 11 members elected to the Board of Supervisors in San Francisco, each representing a geographic district. The Board of Supervisors is the legislative body for San Francisco. The districts are numbered 1 through 11.integerlevel : Nominal
LatitudeThe latitude of the location where the incident occurrednumber-
LongitudeThe longitude of the location where the incident occurrednumber-
Incident_Date_TimeIncident_DayReport_Date_TimeIncident_IDIncident_NumberCAD_NumberReport_Type_CodeReport_Type_DescriptionIs_Filed_OnlineIncident_CodeIncident_CategoryIncident_SubcategoryIncident_DescriptionResolutionIntersectionCenterline_Node_NetworkPolice_DistrictAnalysis_NeighborhoodSupervisor_DistrictLatitudeLongitude
2019-03-13T07:22:00Wednesday2019-03-13T07:22:00779258190180764190720570IIInitial26030ArsonArsonArsonOpen or ActiveSouthern
2019-05-12T06:50:00Sunday2019-05-12T06:57:00800063190339397191320597IIInitial26030ArsonArsonArsonCite or Arrest AdultSouthern
2019-04-14T12:00:00Sunday2019-04-22T18:00:00793278190286942191123218IIInitial9027FraudFraudFalse PersonationOpen or ActiveTaraval
2019-05-09T18:42:00Thursday2019-05-11T13:01:00799848190337642191311399IIInitial4134AssaultSimple AssaultBatteryOpen or ActivePark
2019-04-22T14:35:00Monday2019-04-22T14:40:00793248190286306191122424IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveMission
2019-04-22T18:40:00Monday2019-04-22T18:43:00793291190287194191123366IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveCentral
2019-04-07T07:00:00Sunday2019-04-22T00:22:00792935190284689191120036IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveCentral
2019-04-22T05:40:00Monday2019-04-22T05:45:00792976190284930191120443IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveCentral
2019-04-22T08:15:00Monday2019-04-22T14:18:00793195190286124191122335IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveBayview
2019-04-22T13:57:00Monday2019-04-22T14:06:00793272190286130191122246IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveTaraval