Decrease Water Consumption (GPCD)

Gallons Per Capita Per Day (GPCD) is a metric used by many communities to measure water use (consumption). It is an effective tool to measure conservation efficiency over time. GPCD varies across communities due to several factors, including differences in climate, demographics, water-use accounting practices and economic conditions. The City of Henderson has achieved reductions in potable water use per capita with the permanent adoption of the City's water conservation regulations and enforcement practices. Further conservation is needed to achieve long-term conservation goals. The City is committed to decreasing potable GPCD to 184 by 2024.

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 \"performance-cityofhenderson/decrease-water-consumption-gpcd-equp-qmdc\".\"decrease_water_consumption_gpcd\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.