2021 Community Path Audit Defect 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. To supplement the asset performance information, the audit also captured potential defects for further investigation by a suitably qualified officer. The findings from this audit represent a snapshot in time and don’t reflect the current situation.

This dataset identifies potential defects requiring further investigation by a qualified officer. Community path defects are managed in an ongoing manner through the Transport Canberra and City Services Asset Management System.

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-defect-export-vk2f-ky5t\".\"2021_community_path_audit_defect_export\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.