melbourne-vic-gov-au/onstreet-car-parking-sensor-data-2017-u9sa-j86i
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated over 3 years ago
Indexed 5 hours ago

On-street Car Parking Sensor Data - 2017

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 2017 calendar year.

Known data issues:

  1. There are 860 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 (April 2018) 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.

Data that is excluded:

In the 2017 car parking event data there are 3,858 records where the parking event goes into 2018 and ends at midnight.

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-2017-u9sa-j86i\".\"onstreet_car_parking_sensor_data_2017\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • onstreet_car_parking_sensor_data_2017
     
     
     
     
     
Upstream Metadata