Austin Water - Residential Water Consumption
Monthly residential water consumption grouped by zip code, 2020 Census Tract FIPS, and customer class.
Census Tract Information: USA Census Tract Boundaries in Esri Living Atlas https://www.arcgis.com/home/item.html?id=20f5d275113e4066bf311236d9dcc3d4
Note: Data should be carefully reviewed to insure it is summarized at the level needed by the end user. For example, there are census tracts that overlap multiple postal codes.
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/austin-water-residential-water-consumption-sxk7-7k6z\".\"austin_water_residential_water_consumption\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
