Open repository in Console
Readme
Updated over 4 years ago
‧ Indexed 1 month ago
Energy Use at County Facilities
Energy data represents all electricity used at Pierce County Facilities, excluding the wastewater treatment plants and distributed pump houses.
Water use data represents water used at Pierce County Facilities with an associated bill. Water data collection has proven to be more inconsistent. Steps are being taken to improve the granularity and accuracy of our water data collection.
All data is collected from utility bills and is entered into software where it is normalized by month and by fluctuations in the weather.
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/energy-use-at-county-facilities-cz5g-rbpz\".\"energy_use_at_county_facilities\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.
Upstream Metadata