Pedestrian & Cycling Cordon Counts

This dataset presents data collected as part of Pedal Power Cordon counts which are performed annually.

Details relating to the methodology used in the collection of data at each location is described in PDF documents which are accessible in the attached files of the dataset.

Data collection times of the columns are as follows:

AM: 07:00 to 10:00

PM: 16:00 to 19:00

Total: Sum of AM and PM counts

Note:

Data prior to 2015 is excluded due to the use of different survey sites and collection methodology. Data for site G14 is only available for 2017 and 2018, and no methodology details are currently available for this location.

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 \"data-act-gov-au/pedestrian-cycling-cordon-counts-cz2x-tuqb\".\"pedestrian_cycling_cordon_counts\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.