Traffic Incidents
This is an unofficial archive of traffic incidents within Calgary. Traffic incidents are traffic disruptions affecting traffic flow, such as traffic signal issues, hazardous road conditions, stalled vehicles, and unverified, unreported traffic collisions. This data is based off unrecorded imagery where traffic cameras are present. There may be gaps in the data due to system or script malfunction. For more information, see the <a href="http://www.calgary.ca/Transportation/Roads/Pages/Traffic/Advisories-closures-and-detours/Calgary-traffic-report.aspx">Calgary Traffic Report page</a>.
Querying over HTTP
Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:
curl https://data.splitgraph.com/sql/query/ddn \ -H "Content-Type: application/json" \ -d@-<<EOF {"sql": " SELECT * FROM \"calgary-ca/traffic-incidents-35ra-9556\".\"traffic_incidents\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.