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-10-11

Version

2019-10-11

Update Frequency

Quarterly

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-08-15T11:41:00Thursday2019-10-01T14:06:00854240196208089IICoplogic InitialTrue6374Larceny TheftLarceny Theft - OtherTheft, Other Property, >$950Open or ActiveCentral
2019-09-17T22:00:00Tuesday2019-10-02T22:01:00854266196208205IICoplogic InitialTrue6374Larceny TheftLarceny Theft - OtherTheft, Other Property, >$950Open or ActiveOut of SF
2019-10-04T14:25:00Friday2019-10-04T16:13:00854426190746203192772728.0IIInitial3474RobberyRobbery - OtherRobbery, Att., W/ ForceOpen or ActiveBALBOA ST \ GREAT HWY28009000.0RichmondOuter Richmond1.037.77507596-122.5112949
2019-10-03T19:30:00Thursday2019-10-03T23:25:00854197190744514192764437.0IIInitial6244Larceny TheftLarceny - From VehicleTheft, From Locked Vehicle, >$950Open or ActiveMARKET ST \ RESERVOIR ST25877000.0MissionCastro/Upper Market8.037.7687705-122.4274621
2019-10-04T16:53:00Friday2019-10-04T16:53:00854463190746532192772932.0IIInitial51040Non-CriminalNon-CriminalAided CaseOpen or Active42ND AVE \ CLEMENT ST \ VETERANS DR27919000.0RichmondOuter Richmond1.037.78117677-122.5030865
2019-10-02T14:10:00Wednesday2019-10-02T22:59:00854257196208142IICoplogic InitialTrue6224Larceny TheftLarceny - From VehicleTheft, From Unlocked Vehicle, >$950Open or ActiveSTOCKTON ST \ NORTH POINT ST25478000.0CentralNorth Beach3.037.80696291-122.4104976
2019-10-03T23:30:00Thursday2019-10-03T23:31:00854227190744586192764446.0IIInitial12030Weapons OffenseWeapons OffenseWeapon, Deadly, Imitation or Laser Scope, ExhibitingCite or Arrest AdultAL SCOMA WAY \ JEFFERSON ST35066000.0CentralNorth Beach3.037.80797873-122.4177159
2019-10-04T14:40:00Friday2019-10-04T14:51:00854450190746059192772346.0IIInitial26080Other MiscellaneousOtherConspiracyOpen or Active17TH AVE \ CLEMENT ST27502000.0RichmondOuter Richmond1.037.78240595-122.4763066
2019-10-04T13:35:00Friday2019-10-04T15:49:00854440190746184192772064.0IIInitial19089Disorderly ConductOtherIncident On School GroundsOpen or ActiveFOREST VIEW DR \ EUCALYPTUS DR23125000.0TaravalLakeshore7.037.73107997-122.4835449
2019-10-04T00:00:00Friday2019-10-04T11:07:00854357190745409192770635.0VIVehicle Initial7025Motor Vehicle TheftMotor Vehicle TheftVehicle, Stolen, TruckOpen or ActiveGARRISON AVE \ SCHWERIN ST20369000.0InglesideVisitacion Valley10.037.70921035-122.4119682