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.