calgary-ca/intersection-safety-cameras-dv2f-necx
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 10 days ago
Indexed 38 minutes ago

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.

 
Preview
  • intersection_safety_cameras
     
     
     
     
     
Upstream Metadata