The following overview refers to the dataset posted here: https://data.sfgov.org/d/wg3w-h783

Summary

This dataset includes incident reports that have been filed as of January 1, 2018. These reports are filed by officers or self-reported by members of the public using SFPD’s online reporting system.  The reports are categorized into the following groups based on how the report was received and the type of incident:

  1. Initial Reports: the first report filed for an incident
  2. Coplogic Reports: incident reports filed by members of the public using SFPD’s online reporting system
  3. Vehicle Reports: any incident reports related to stolen and/or recovered vehicles

All incident reports must be approved by a supervising Sergeant or Lieutenant. Once a supervising officer has provided approval via electronic signature, no further changes can be made to the initial report. If changes or additional information is required, a supplemental report will be generated to provide updates.  For example, a supplemental report may be issued to show an arrest was made, a missing person was found, or to provide additional details of the property taken in a theft.  To differentiate between the initial and supplemental reports, a filter can be applied to the “Report Type Description” field.

Incident reports may be removed from the dataset if in compliance with court orders to seal records or for administrative purposes such as active internal affairs investigations and/or criminal investigations.

Incident reports do not necessarily capture all data surrounding policing and crime. This dataset does not, for example, capture citations (unless an associated incident report was written with the citation.) For example, a routine speeding ticket would generally not require an incident report, however, a speeding ticket that reveals a driver with a felony warrant leading to an arrest would require an incident report.

Multiple Incident Codes

Reported incidents can have one or more 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 would record two Incident Codes: (1) for the warrant and (2) for the discovery of narcotics.

When multiple Incident Codes exist, the Incident ID, Incident Number, and CAD Numbers remain the same and the Row ID field can be used as a unique identifier for each row of data.  An example is provided below.

Incident Datetime

Row ID

Incident ID

Incident Number

CAD Number

Incident Code

Incident Category

1/1/18 13:20

61902222223

60044

180999999

180222222

62050

Warrant

1/1/18 13:20

61903333320

60044

180999999

180222222

16710

Drug Offense

Mapping Coordinates

Coordinates provided within the dataset are anonymized and reflect the nearest intersection of each occurrence.    Some coordinates may be omitted 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 SFPD districts. These will be marked as “Out of SF” in the Police District column and do not have associated geographic information.

Privacy controls

All incident locations are shown at the intersection level only. Records are masked to minimize the risk of re-identification to an individual. Intersections used in the masking are associated with either 0 or greater than 11 premise addresses. A premise address is a specific place of work or residence.

Juvenile Data

Based on Government Code (GC) 6254 and California Welfare and Institutions Code § 827, identifying juvenile information will not be available in this dataset. Incidents with a resolution of “Cite or Arrest Juvenile” and/or “Exceptional Juvenile” have been removed from this dataset. In addition, the following Incident Codes have been removed from this dataset:

Incident Code

Incident Code Description

02010

Unlawful Sexual Intercourse with Minor

04147

Sexual Assault, Aggravated, of Child

13073

Minor, Abduction of for Prostitution

14010

Children, Annoy Or Molest

14015

Child Abuse, Sexual

14016

Sex Act, Agreement of Parent to Pay Minor Victim of

14017

Obscene Matter, Distribution to Minors

14044

Indecent Exposure (Juvenile victim)

14050

Oral Copulation, Unlawful (Juvenile Victim)

14070

Sodomy (Juvenile Victim)

15010

Child Under 14, Willful Abandonment or Nonsupport of

15015

Child, Inflicting Physical Pain, Mental Suffering, or Death

15016

Child Abuse, Exploitation

15017

Child Abuse, Pornography

15020

Persuading Child Under14 to Go Somewhere for Sex Act

15021

Kidnapping (Juvenile Victim)

15022

Kidnapping, Attempted (Juvenile Victim)

15030

Minor, Contributing To Delinquency of

15031

Tobacco Products, Selling or Furnishing to Minor

15032

Minor Purchasing or Receiving Tobacco Product

15040

Spouse, Cohabitee, Parent of Child in Common, Inflict Injury

15041

Elder Adult or Dependent Abuse (not Embezzlement or Theft)

15050

Child, Willful Desertion of

15051

Children, Abandonment & Neglect of (general)

15052

Child, Inflicting Injury Resulting in Traumatic Condition

15054

Harassing Child or Ward because of Person's Employment

15060

Child, Failure To Provide

15070

Parent, Indigent, Failure To Provide for

15080

Wife, Failure To Provide For

15090

Child, Drunk Habitually In Presence Of/Immoral Acts Before

15100

Child, Willful Cruelty To

15500

Juvenile Involved (secondary code)

16070

Marijuana, Encouraging Minor To Use

16140

Heroin, Encouraging Minor To Use

16250

Opiates, Encouraging Minor To Use

16350

Opium Derivative, Encouraging Minor To Use

16450

Hallucinogenic, Encouraging Minor To Use

16618

Opium, Encouraging Minor To Use

16628

Cocaine, Encouraging Minor To Use

16638

Methadone, Encouraging Minor To Use

16648

Amphetamine, Encouraging Minor To Use

16550

ENCOURAGE MINOR TO USE BARBITUATES

16658

Methamphetamine, Encouraging Minor To Use

16668

Controlled Substance, Encouraging Minor To Use

17010

Minor, False Evidence Of Age

17040

Minor Inside On-sale Licensed Premise

17050

Alcohol, Purchasing by Minor

17060

Alcohol, Possession Of By Minor

17080

Alcohol, Sale Of To Minor

17090

Alcohol, Sale Of To Minor In Bar

17100

Alcohol, Sale Of By Minor

26070

Child Concealment, Depriving Lawful Custodian

27180

Glue, Restricted, Selling to Juvenile

28091

Malicious Mischief, Juvenile Suspect

29010

Minor Beyond Parental Control

29020

Curfew Violation

29030

Juvenile in Danger Of Leading Immoral Life

29040

Minor, Destitute

29050

Escapee, Juvenile

29060

Glue Sniffing, Juvenile

29070

Habitual Truant

29080

Juvenile, Intoxicated

29081

Minor, Allowing to Drive Intoxicated or after 23103 VC Conviction

29082

Tattooing Person under 18

29083

Soliciting Minor to Commit Felony

29090

Parole Violation, Juvenile

29100

Runaway

29110

Minor Without Proper Parental Care

29120

Shelter

29130

Youth Court

29170

Truant, Habitual

64050

Child, Suspicious Act Towards

74010

Missing Juvenile

Field definitions

See definitions on the dataset landing page here: https://data.sfgov.org/d/wg3w-h783