Intersection Safety Device Locations
This dataset represents the approximate drive lane(s) and the direction of enforcement, of intersections where Intersection Safety Devices are operational. Intersection Safety Devices enforce red light infractions and speed on green infractions.
Note: To avoid some confusion of location, efforts were made to shift the geo-location to one side or the other side of a roadway to more clearly indicate the lane(s) of travel and direction of travel and set back from the actual intersection.
For more information please see https://www.edmonton.ca/transportation/traffic_safety/automated-enforcement.
See also the 2021 Annual Report, prepared by the Safe Mobility Automated Traffic Enforcement team, at <a href="https://www.edmonton.ca/sites/default/files/public-files/2021-Automated-Traffic-Enforcement-Report.pdf?utm_source=opendata&utm_medium=portal&utm_campaign=description">https://www.edmonton.ca/sites/default/files/public-files/2021-Automated-Traffic-Enforcement-Report.pdf</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 \"edmonton-ca/intersection-safety-device-locations-7fnd-72gr\".\"intersection_safety_device_locations\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.