San Francisco Data

Close
Author
OpenData
Description
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.
Category
Public Safety
Tags
sfpd, crime, police department, crime reports
Rating
Current value: 0 out of 5
Data Provided By
City and County of San Francisco
Source Link
http://www.sfgov.org
License
Public Domain Dedication and License
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

PdId
pdid
IncidntNum
incidntnum
Incident Code
incident_code
Category
category
Descript
descript
DayOfWeek
dayofweek
Date
date
Time
time
PdDistrict
pddistrict
Resolution
resolution
Address
address
X
x
Y
y
location
location
SF Find Neighborhoods 2 2
:@computed_region_6qbp_sg9q
Current Police Districts 2 2
:@computed_region_qgnn_b9vv
Current Supervisor Districts 2 2
:@computed_region_26cr_cadq
Analysis Neighborhoods 2 2
:@computed_region_ajp5_b2md
DELETE - Fire Prevention Districts 2 2
:@computed_region_yftq_j783
DELETE - Police Districts 2 2
:@computed_region_p5aj_wyqh
DELETE - Supervisor Districts 2 2
:@computed_region_rxqg_mtj9
DELETE - Zip Codes 2 2
:@computed_region_bh8s_q3mv
DELETE - Neighborhoods 2 2
:@computed_region_fyvs_ahh9
DELETE - 2017 Fix It Zones 2 2
:@computed_region_9dfj_4gjx
Civic Center Harm Reduction Project Boundary 2 2
:@computed_region_n4xg_c4py
Fix It Zones as of 2017-11-06 2 2
:@computed_region_4isq_27mq
DELETE - HSOC Zones 2 2
:@computed_region_fcz8_est8
Fix It Zones as of 2018-02-07 2 2
:@computed_region_pigm_ib2e
CBD, BID and GBD Boundaries as of 2017 2 2
:@computed_region_9jxd_iqea
Areas of Vulnerability, 2016 2 2
:@computed_region_6pnf_4xz7
Central Market/Tenderloin Boundary 2 2
:@computed_region_6ezc_tdp2
Central Market/Tenderloin Boundary Polygon - Updated 2 2
:@computed_region_h4ep_8xdi
HSOC Zones as of 2018-06-05 2 2
:@computed_region_nqbw_i6c3
OWED Public Spaces 2 2
:@computed_region_2dwj_jsy4
Neighborhoods 2
:@computed_region_jwn9_ihcz

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.