Annual Water Use at Washington Clean Buildings Act Tier 1 and 2 Buildings

This data represents all water used at Pierce County owned Washington Clean Buildings Act (WCBA) Tier 1 and 2 buildings, which includes all County buildings that are larger than 20,000 Square Feet.

All water usage data is collected from utility bills.

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 \"internal-open-piercecountywa-gov/annual-water-use-at-washington-clean-buildings-act-wma7-x5q2\".\"annual_water_use_at_washington_clean_buildings_act\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.