Litter Traps

Litter traps are devices that retain ‘gross pollutants’ (litter and debris greater than 5mm) They are available in several configurations and designs.

This dataset can be used in conjunction with the drainpipe dataset https://data.melbourne.vic.gov.au/Assets-Infrastructure/Drainpipes/3bff-vaa5

The stormwater pit dataset:

https://data.melbourne.vic.gov.au/Assets-Infrastructure/Stormwater-Pits/psq9-yz4x

and also the pumping station dataset:

https://data.melbourne.vic.gov.au/Assets-Infrastructure/Pumping-Station/55z9-zqzu

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 \"melbourne-vic-gov-au/litter-traps-4spx-8bh5\".\"litter_traps\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.