2021 Community Path Audit Export

As part of the Jobs for Canberrans Fund, announced in 2020, an audit occurred of bike paths and footpaths in Canberra. The audit was primarily focused on asset performance data to inform future asset management activities. The findings from this audit represent a snapshot in time and don’t reflect the current situation.

This dataset identifies the asset management recommendation for all audited paths and if the path segment had any vegetation encroachment. Asset management recommendations have been categorised as per below.

• As new;

• Portions within segment monitored under routine maintenance program; or

• Portions within segment are potential candidates for renewal/rehabilitation under planned program

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 \"data-act-gov-au/2021-community-path-audit-export-e4ai-j3mg\".\"2021_community_path_audit_export\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.