Icon for Socrata external plugin
Open repository in Console
Updated 1 year ago
Indexed 3 hours ago

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="">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="">Pedestrian Counting System – Past Hour (counts per minute)</a> dataset.

<p>The <a href="">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="">Online Visualisation</a>.<p><b>Related datasets: </b><br><b><a href="">Pedestrian Counting System – Past Hour (counts per minute)</a></b><br><b><a href="">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 \
    -H "Content-Type: application/json" \
{"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 

See the Splitgraph documentation for more information.

  • pedestrian_counting_system_monthly_counts_per_hour
Upstream Metadata