Spreading Grounds Centralized Monthly Capture

Centralized stormwater capture facilities are engineered features located in specific locations that perform well at capturing large flows when available. In general, these facilities can capture and infiltrate more than 100 acre-feet per year.

This dataset shows the monthly yield for centralized stormwater capture across LA city for use in the stormwater dashboard and sustainable city pLAn.

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/spreading-grounds-centralized-monthly-capture-cy8h-q3bu\".\"spreading_grounds_centralized_monthly_capture\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.