Pay Stay zones linked to street segments

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

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

https://data.melbourne.vic.gov.au/Transport-Movement/Sign-plates-located-in-each-pay-stay-zone/wwkr-v8s7

and also the Pay Stay parking restrictions dataset

https://data.melbourne.vic.gov.au/Transport-Movement/Pay-Stay-parking-restrictions/ambt-72qg

The datasets can be joined on Pay Stay 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

For further information on Pay Stay https://www.paystay.com.au/

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/pay-stay-zones-linked-to-street-segments-7q9g-yyvg\".\"pay_stay_zones_linked_to_street_segments\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.