melbourne-vic-gov-au/super-sunday-bike-count-v9mu-dvfu
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 3 years ago
Indexed 5 hours ago

Super Sunday Bike Count

This dataset contains observed bike counts from sites across the city known as "Super Sunday". This is Australia’s biggest survey of recreational travel. Held annually in mid-November, the count looks at how runners, walkers, bike riders and other recreational users move around

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/v9mu-dvfu/files/6b45ebe1-0936-4006-b08e-78677c071934?download=true&filename=Super%20Sunday%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/super-sunday-bike-count-v9mu-dvfu\".\"super_sunday_bike_count\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • super_sunday_bike_count
     
     
     
     
     
Upstream Metadata