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.