Snow and Ice Clearing Priority Routes
Snow clearing for Priority 1 (major roads such as Crowchild Trail, Glenmore Trail, Memorial Drive, 16 Avenue) and Priority 2 routes (collector roads, major community access roads, bus routes etc.)
Priority 1 Routes: Roads carrying more than 20,000 vehicles per day.
Snow Clearing Commitment: Priority 1 routes are cleared within 18 hours of snow ending.
Priority 2 Routes: Roads carrying 5,000-19,999 vehicles per day.
Snow Clearing Commitment: Priority 2 routes are cleared within 36 hours of snow ending.
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/snow-and-ice-clearing-priority-routes-4v8s-3kss\".\"snow_and_ice_clearing_priority_routes\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
