About this Dataset

Police Department Incident Reports: Historical 2003 To May 2018

For up to date data starting in 2018, please go to the new dataset at: https://data.sfgov.org/d/wg3w-h783

As of May 2018, the feed from the legacy mainframe CABLE was discontinued. It was extremely prone to issues and caused many delays in data accessibility. The new dataset linked above comes from the Crime Data Warehouse, a more reliable data system maintained by the Police Department.

This data will undergo a minor update to conform more closely to the schema of the new dataset. We will post a change notice when that work is planned. This change will not include adding new fields or backfilling data. It is provided as is. We are keeping data from the two systems separate to make it transparent to data users that there were fundamental changes.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:55.948475
Tags: crime, crime-reports, police-department, sfpd

Tables

Table 1

@usgov.city_of_san_francisco_police_department_incident_repor_919b9112.table_1

103.51 MB
2,073,322 rows
36 columns

CREATE TABLE table_1 (
  "pdid" BIGINT,
  "incidntnum" BIGINT,
  "incident_code" BIGINT,
  "category" VARCHAR,
  "descript" VARCHAR,
  "dayofweek" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "pddistrict" VARCHAR,
  "resolution" VARCHAR,
  "address" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "location" VARCHAR,
  "data_loaded_at" VARCHAR,
  "sf_find_neighborhoods_2_2" DOUBLE,
  "current_police_districts_2_2" DOUBLE,
  "current_supervisor_districts_2_2" DOUBLE,
  "analysis_neighborhoods_2_2" DOUBLE,
  "delete_fire_prevention_districts_2_2" DOUBLE  -- DELETE - Fire Prevention Districts 2–2,
  "delete_police_districts_2_2" DOUBLE  -- DELETE - Police Districts 2–2,
  "delete_supervisor_districts_2_2" DOUBLE  -- DELETE - Supervisor Districts 2–2,
  "delete_zip_codes_2_2" DOUBLE  -- DELETE - Zip Codes 2–2,
  "delete_neighborhoods_2_2" DOUBLE  -- DELETE - Neighborhoods 2–2,
  "delete_2017_fix_it_zones_2_2" DOUBLE  -- DELETE - 2017 Fix It Zones 2–2,
  "civic_center_harm_reduction_project_boundary_2_2" DOUBLE,
  "fix_it_zones_as_of_2017_11_06_2_2" DOUBLE,
  "delete_hsoc_zones_2_2" DOUBLE  -- DELETE - HSOC Zones 2–2,
  "fix_it_zones_as_of_2018_02_07_2_2" DOUBLE,
  "cbd_bid_and_gbd_boundaries_as_of_2017_2_2" DOUBLE  -- CBD, BID And GBD Boundaries As Of 2017–2 2,
  "areas_of_vulnerability_2016_2_2" DOUBLE  -- Areas Of Vulnerability, 2016–2 2,
  "central_market_tenderloin_boundary_2_2" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated_2_2" DOUBLE  -- Central Market/Tenderloin Boundary Polygon - Updated 2–2,
  "hsoc_zones_as_of_2018_06_05_2_2" DOUBLE,
  "owed_public_spaces_2_2" DOUBLE,
  "neighborhoods_2" DOUBLE
);