Bicycle and Pedestrian Counts (2013-2016)

The bicycle count is one of the ways the Bicycle Program is monitoring and evaluating cycling data, in keeping with the Council approved Cycling Strategy. Pedestrian counts are included to monitor pathway traffic.

The City collects and monitors information on the number of bicycle riders, gender, age, and helmet use and will be reported on annually. Dependent on weather conditions and construction, count locations that were counted first in 2013 will be counted in future years in order to gauge trends about cycling. Additional count locations are added as resources become available. This dataset includes counts completed from 2013-2016.

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/bicycle-and-pedestrian-counts-20132016-ybd2-54bg\".\"bicycle_and_pedestrian_counts_20132016\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.