Road Construction Projects
Transportation Infrastructure (TI) is responsible for many of the major road construction projects that take place in Calgary. Major road construction projects include construction of new roadways, rehabilitation and upgrades to existing roadways, intersection upgrades, and installation of interchanges.
Other road construction projects taking place in Calgary may be the responsibility of the Roads Business Unit or the Province of Alberta. The Province oversees the operation and maintenance of Deerfoot Trail and is constructing the Calgary Ring Road.
For more information on Provincial road projects visit <a href="http://www.transportation.alberta.ca/4.htm">Alberta Transportation.</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 \"calgary-ca/road-construction-projects-sizs-hgef\".\"road_construction_projects\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.