Mayor's ED No.5 GPCD Target Progress

This metric measures the average total daily water use in Los Angeles, divided by the total number of residents. As this figure includes commercial, industrial, and institutional water use, this figure does not represent the average personal daily use of an individual Angeleno.

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/mayors-ed-no5-gpcd-target-progress-ubph-b4it\".\"mayors_ed_no5_gpcd_target_progress\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.