2012 Bike Normalized Volume

The data represented in this map are 2-way volumes collected from spring to fall between 2007 & 2012. The data came from a variety of sources, and 6 hour counts were factored to 16 hours using screenline data.

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/2012-bike-normalized-volume-w5s3-yvk5\".\"2012_bike_normalized_volume\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.