Adaptive Roadways

To help provide Calgarians with the space needed to walk, run, skateboard and cycle, The City of Calgary has implemented an Adaptive Roadways Program (ARP). Under the program, road lanes are closed to motor vehicle traffic so they can be used by people who are walking, running, cycling, rollerblading and the like.

See <a href="https://www.calgary.ca/transportation/roads/traffic/traffic-safety-programs/adaptive-roadways-program-and-related-lane-closures.html">Adaptive Roadways Program and related lane closures</a> for more information.

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/adaptive-roadways-usjx-kn8w\".\"adaptive_roadways\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.