ACTGOV Pipe Assets

<DIV STYLE="text-align:Left;"><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>This polyline dataset shows the locations of Stormwater Pipes in the Australian Capital Territory. </SPAN></SPAN></P><P /><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>These assets are either owned or managed by City Services, Transport Canberra and City Services Directorate (TCCS). Assets managed and / or owned privately, by other ACT Government Directorates or by the Federal Government may not be included.</SPAN></SPAN></P><P /><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>Attributes include location description, suburb, ownership, maintained by, asset sub type (Large Pipe, Medium Pipe, Small Pipe, Very Large Pipe), material, pip diameter, length and grade, up and down invert levels and joint type.</SPAN></SPAN></P><P /><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>These assets are captured and maintained in the asset database through the works as executed (WAE) handover process or field audits.</SPAN></SPAN></P><P /><P STYLE="margin:0 0 0 0;"><SPAN>For additional information, please see the relevant municipal infrastructure standard (https://www.cityservices.act.gov.au/plan-and-build/standards-codes-and-guidelines/municipal-infrastructure-design-standards-mis).</SPAN></P></DIV>

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/actgov-pipe-assets-q6t6-qkb9\".\"actgov_pipe_assets\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.