Water Capture by Method

Though it doesn't rain often in Los Angeles, the city has various means of capturing rainfall to increase our local water supply. This dataset shows how much water we've capturing cumulatively this season as well as today.

It is calculated through a script that is available on github here (https://github.com/CityOfLosAngeles/WaterCapture). When it rains, the dataset will update with new rows every hour.

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/water-capture-by-method-xe35-4wsy\".\"water_capture_by_method\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.