Green Infrastructure Water Capture Capacity

Green infrastructure is designed to capture and infiltrate or filter stormwater runoff through natural systems. This dataset is used in combination with precipitation numbers to update the stormwater dashboard (in progress) and Sustainable City pLAn. It is refreshed as new projects are created.

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 \"lacity/green-infrastructure-water-capture-capacity-pdbw-x3k8\".\"green_infrastructure_water_capture_capacity\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.