Pedestrian Counting System - Monthly (counts per hour)

This dataset contains hourly pedestrian counts since 2009 from pedestrian sensor devices located across the city. The data is updated on a monthly basis and can be used to determine variations in pedestrian activity throughout the day.

<p>The sensor_id column can be used to merge the data with the <a href="https://data.melbourne.vic.gov.au/Transport-Movement/Pedestrian-Counting-System-Sensor-Locations/h57g-5234">Pedestrian Counting System - Sensor Locations</a> dataset which details the location, status and directional readings of sensors. Any changes to sensor locations are important to consider when analysing and interpreting pedestrian counts over time.<p><b>Importants notes about this dataset:</b>

<br>• Where no pedestrians have passed underneath a sensor during an hour, a count of zero will be shown for the sensor for that hour.

<br>• Directional readings are not included, though we hope to make this available later in the year. Directional readings are provided in the <a href=" https://data.melbourne.vic.gov.au/d/d6mv-s43h">Pedestrian Counting System – Past Hour (counts per minute)</a> dataset.

<p>The <a href="https://www.melbourne.vic.gov.au/about-melbourne/research-and-statistics/city-population/Pages/pedestrian-counting-system.aspx">Pedestrian Counting System</a> helps to understand how people use different city locations at different times of day to better inform decision-making and plan for the future. A representation of pedestrian volume which compares each location on any given day and time can be found in our <a href="http://www.pedestrian.melbourne.vic.gov.au/?_ga=2.44607906.760678413.1541972518-340051665.1506055261">Online Visualisation</a>.<p><b>Related datasets: </b><br><b><a href=" https://data.melbourne.vic.gov.au/d/d6mv-s43h">Pedestrian Counting System – Past Hour (counts per minute)</a></b><br><b><a href="https://data.melbourne.vic.gov.au/d/h57g-5234">Pedestrian Counting System - Sensor Locations</a></b>

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/pedestrian-counting-system-monthly-counts-per-hour-b2ak-trbp\".\"pedestrian_counting_system_monthly_counts_per_hour\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.