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

Available Access Formats


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


  • 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