internal-open-piercecountywa-gov/energy-use-at-county-facilities-cz5g-rbpz
Icon for Socrata external plugin
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.

 
Preview
  • energy_use_at_county_facilities
     
     
     
     
     
Upstream Metadata