Intersection Safety Cameras

Intersection Safety Cameras (ISCs) are cameras that detect the travel speed of vehicular traffic. The ISC is also able to detect whether a vehicle fails to stop for the red light phase in a signalized intersection. ISCs are deployed at signalized intersections throughout the city with high collision rates and a history of serious injury or fatal collisions.

More information on this is available at: http://www.calgary.ca/cps/Pages/Traffic/Speed-on-green-and-red-light-cameras.aspx

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/intersection-safety-cameras-dv2f-necx\".\"intersection_safety_cameras\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.