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

2020-06-11

Version

2020-06-11

Update Frequency

Quarterly

Temporal Coverage

2018-2020

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 2020, 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-05-01T01:00:00Wednesday2019-06-12T20:27:00810975190424067191634131IIInitial15200Offences Against The Family And ChildrenOtherDomestic Violence (secondary only)Open or Active40TH AVE \ IRVING ST27789000TaravalSunset/Parkside437.7625694-122.49962749999999
2019-06-22T07:45:00Saturday2019-06-22T08:05:00814655190450880191730737IIInitial64020Non-CriminalOtherMental Health DetentionOpen or Active06TH ST \ MINNA ST24285000SouthernSouth of Market637.78053539-122.4081608
2019-06-03T16:16:00Monday2019-06-03T16:16:00807698190397016191533509ISInitial Supplement75000Missing PersonMissing PersonFound PersonOpen or ActiveEGBERT AVE \ INGALLS ST20447000BayviewBayview Hunters Point1037.72159985-122.39074529999999
2018-11-16T16:34:00Friday2018-11-16T16:34:00738579180870806183202539ISInitial Supplement15041Offences Against The Family And ChildrenFamily OffensesElder Adult or Dependent Abuse (not Embezzlement or Theft)Cite or Arrest AdultMERCHANT ST \ KEARNY ST24773000CentralChinatown337.79485953-122.40487560000001
2019-05-27T02:25:00Monday2019-05-27T02:55:00805092190378555191470256IIInitial4134AssaultSimple AssaultBatteryOpen or ActiveLAGUNA ST \ UNION ST26583000NorthernMarina237.79771621-122.430559
2018-11-07T03:50:00Wednesday2018-11-15T11:28:00737958180867364183191559IIInitial5151BurglaryBurglary - OtherBurglary, Non-residential, Forcible EntryOpen or Active03RD ST \ MINNA ST24609000CentralFinancial District/South Beach637.78582921-122.40148980000001
2019-08-15T12:45:00Thursday2019-08-15T17:23:00834895190601215192273186IIInitial6244Larceny TheftLarceny - From VehicleTheft, From Locked Vehicle, >$950Open or ActiveGEARY BLVD \ PRESIDIO AVE26834000RichmondLone Mountain/USF237.78248803-122.44582050000001
2019-08-07T07:45:00Wednesday2019-08-07T07:47:00831653190575999192190726IIInitial64085Other MiscellaneousOtherInvestigative DetentionOpen or ActiveSTEVENSON ST \ 07TH ST \ ODD FELLOWS WAY24319000TenderloinSouth of Market637.78000587-122.41193340000001
2018-11-15T15:56:00Thursday2018-11-15T15:56:00738297180841766183192626ISInitial Supplement75025Non-CriminalNon-CriminalSearch Warrant ServiceCite or Arrest AdultEDDY ST \ SCOTT ST26075000NorthernWestern Addition537.78080177-122.4372601
2019-06-29T16:52:00Saturday2019-06-29T16:52:00816797190470292191802774IIInitial65010Traffic Violation ArrestTraffic Violation ArrestTraffic Violation ArrestCite or Arrest AdultCOLUMBUS AVE \ BEACH ST25598000CentralRussian Hill237.80678011-122.4195772