For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.
Data Source Link

https://data.sfgov.org/Public-Safety/SFPD-Reported-Incidents-2003-to-Present/dyj4-n68b

Available Access Formats

FTP CSV

Sources and Modeling

Note: There are separate tables for each year of data such as ‘sfpd_incident_2012’, ‘sfpd_incident_2013’, etc. These tables must be appended to one another for multi-year analyses.

Row Color Derived Column
Row Color Column Not Used by Open Data Bits

Logical Model

Hierarchies

  • Category > Descript

Calculated Columns & Calculations

Name DAX Expression Type
Incident Count COUNT:=COUNTROWS(‘sfpd_incident’) Calculation

Examples for Reference

Open Data Bits – San Francisco Police Department Reported Incidents Open Data

Open Data Bits – San Francisco Graffiti Reports and SFPD Reported Incidents Data Mashup