Prohibited Roads for Temporary Signs

This dataset identifies the roads in the City of Calgary where temporary signage is prohibited under the Temporary Signs on Highway Bylaw 29M97. The identified roads are effective Jan 1, 2024.

*Notice of pilot to run from May 1st to October 31st, 2024. There is a data subset provided on the map that shows previously prohibited roadways that we will allow signage to be installed at for the duration of the pilot.

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/prohibited-roads-for-temporary-signs-vcep-crn9\".\"prohibited_roads_for_temporary_signs\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.