Parking zones linked to street segments

This dataset contains each parking zone and the street segment that it is linked to. The parking zone can go across multiple street segments and also one street segment can have multiple parking zones.

This data can be linked to both the sign plate parking zone dataset.

https://data.melbourne.vic.gov.au/Transport/Sign-plates-located-in-each-Parking-zone/36jw-e4ss

The dataset(s) can be joined on parking zone.

To create a spatial dataset the street segment can be joined with the road corridor dataset on the street segment id.

https://data.melbourne.vic.gov.au/Property-Planning/Road-corridors/9mdh-8yau

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/parking-zones-linked-to-street-segments-efqn-hcbk\".\"parking_zones_linked_to_street_segments\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.