ACTGOV Pedestrian Crossing Assets

<DIV STYLE="text-align:Left;"><P STYLE="margin:0 0 0 0;"><SPAN><SPAN>This point dataset shows the locations of Pedestrian Crossings 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 (Signalised Crossing, School Crossing, Wombat Crossing (Raised Platform), Zebra Crossing), the associated school if relevant, if it has high intensity or flashing lights and the associated traffic signal identification.</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-pedestrian-crossing-assets-jsrx-hw7i\".\"actgov_pedestrian_crossing_assets\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.