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/Service-Requests-311-/Graffiti-SF311-Reports/vyt7-q4b9

Available Access Formats

API OData CSV JSON RDF RSS XLS XLSX XML

Sources and Modeling

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

Logical Model

Calculated Columns & Calculations

Name DAX Expression Type
Opened Date Key =DATE(YEAR([Opened]),MONTH([Opened]),DAY([Opened])) Calculated Column
Opened Time Key =TIME(HOUR([Opened]),MINUTE([Opened]),SECOND([Opened])) Calculated Column
Closed Date Key =DATE(YEAR([Closed]),MONTH([Closed]),DAY([Closed])) Calculated Column
Closed Time Key =TIME(HOUR([Closed]),MINUTE([Closed]),SECOND([Closed])) Calculated Column
Graffiti Count Graffiti Count:=COUNTROWS(‘Graffiti_SF311_Reports’) Calculation

Examples for Reference

Open Data Bits – San Francisco Graffiti Reports Open Data

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