Total Gallons of Water Pumped per Capita per Day (GPCD)

This dataset calculates the annual average gallons of water pumped per capita per day (GPCD) as a measure of Austin’s water conservation efforts over time. GPCD is calculated as the total water pumped annually from Austin Water's potable water treatment plants, divided by Austin Water's estimated potable service area population and the number of days in the year.

Data sources: Austin Water potable treatment plant meters, U.S. Census Bureau, City of Austin Customer Care & Billing System (CC&B), and the City of Austin Demographer.

View more details and insights related to this dataset on the story page:

https://data.austintexas.gov/stories/s/y6fs-auex

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 \"datahub-austintexas-gov/total-gallons-of-water-pumped-per-capita-per-day-cr3t-b72z\".\"total_gallons_of_water_pumped_per_capita_per_day\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.