calgary-ca/traffic-incidents-35ra-9556
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 1 month ago
Indexed 1 month ago

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.

 
Preview
  • traffic_incidents
     
     
     
     
     
Upstream Metadata