melbourne-vic-gov-au/onstreet-car-parking-sensor-data-2012-vbe9-m4tk
Icon for Socrata external plugin
 
Readme
Updated 3 years ago
Indexed 3 hours ago

On-street Car Parking Sensor Data - 2012

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. This is the data for the 2012 calendar year.

Known data issues:

  1. There are 1,139,275 records that have the text ‘OLD’ at the end of the restriction in the field named ‘Sign’. This has been investigated and determined the text refers to one of two things, either:

· At the time of the parking event the restriction that has been captured is correct but when the data was extracted from the server (July 2017) the restriction had since changed.

· (Or) The particular sensor has since been replaced.

  1. There are a number of records that have a negative value in the duration in field ‘seconds’. This occurs due to a sensor detecting an arrival time being after the departure time.
  1. There are a number of records where the arrival and departure times have not been recorded. If the time has not been recorded the time is calculated from midnight of the arrival day to either midnight of the departure day or to the departure 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-2012-vbe9-m4tk\".\"onstreet_car_parking_sensor_data_2012\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • onstreet_car_parking_sensor_data_2012
     
Upstream Metadata