layer_0

ACT ESA incidents, 2008 2010. Incident locations have been generalised to the centroid of the suburb in which they fall. This is one of a suite of datasets showing ACT ESA incidents between 2004 and 2016. Note that due to difference in the data export and upload process, incident counts may differ from those shown in the ESA annual report.

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/layer0-gr55-39d9\".\"layer0\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.