Annual Bike Counts (Super Tuesday)

This dataset contains observed bike counts from sites across the city. These counts are often referred to "Super Tuesday" and is Australia’s biggest annual commuter bike count. The count also contains information for gender, and movement flow of people on bikes.

There is a large number of fields captured for this dataset, which has been compiled into an attached <a href='https://data.melbourne.vic.gov.au/api/views/uyp8-7ii8/files/e877602b-759c-415f-bd9a-627ca6e81495?download=true&filename=Super%20Tuesday%20Bike%20Counts%20Metadata.pdf'>metadata document</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 \"melbourne-vic-gov-au/annual-bike-counts-super-tuesday-uyp8-7ii8\".\"annual_bike_counts_super_tuesday\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.