Buildings on Track to Meet Washington Clean Buildings Standards

The Washington State Clean Buildings Act (RCW 19.27A.210) requires commercial buildings over 50,000 square feet meet energy use intensity targets or a financial investment in energy reduction threshold. Five County owned buildings and one complex are required to comply. Our target for 2023 is to have 3 buildings meet this standard, our target for 2024 is 4 buildings, and our target for 2025 is 5 buildings.

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/buildings-on-track-to-meet-washington-clean-ivnj-andr\".\"buildings_on_track_to_meet_washington_clean\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.