On-street Car Parking Sensor Data - 2018

The City of Melbourne has installed in-ground parking bay sensors in most CBD parking bays. These sensors record when a vehicle arrives and when it departs. Each record also includes the parking restriction for the bay and whether the vehicle has overstayed that restriction. An event will include if a vehicle was present or not which can determine stay time and vacancy time.

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/onstreet-car-parking-sensor-data-2018-5532-ig9r\".\"onstreet_car_parking_sensor_data_2018\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.