melbourne-vic-gov-au/city-activities-and-planned-works-txcy-uafv
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 5 hours ago

City Activities and Planned Works

This dataset contains active and planned activities across the City of Melbourne area. Activities include city works (such as proposed road closures, footpath works or reserved parking permits) and event bookings. The information is derived from permits which are issued by City of Melbourne.

Each activity includes geo-spatial information to indicate the general area of the activity. The spatial information is not indicative of the activity size as the activity may only take up a small portion of the area for the entry.

The start and end date fields indicate that the event/activity is expected to occur within this time range. The actual activity may be active for significantly shorter duration than the start and end dates.

Additional column value information can be found in the attachment (.xlsx) below.

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/city-activities-and-planned-works-txcy-uafv\".\"city_activities_and_planned_works\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • city_activities_and_planned_works
     
     
     
     
     
Upstream Metadata