Icon for Socrata external plugin
Open repository in Console
Updated 6 months ago
Indexed 3 hours ago

Certified Sustainable Buildings

This data set combines information from eight sustainable building certification programs, including two City regulatory programs, to show the extent and location of sustainable buildings in Cambridge.

For inclusion in this data set, a building must meet at least one of the following criteria: receive approval from the City’s Article 22 regulatory process; receive certification from the Passive House program; receive certification from Enterprise Green Communities; or receive LEED certification under a LEED system that requires the whole building to meet sustainability standards.

Some buildings meet two or more of these criteria. Information provided about the applicable sustainable building programs for qualifying buildings includes certification levels, certification types, ratings, or scores. Additionally, this data set contains information about other certifications (ENERGY STAR, Fitwel, and WELL) that may apply to covered buildings. If a covered building participates in the City’s BEUDO regulatory process, this data set indicates that. More specific information about BEUDO building energy usage can be found in the separate BUEDO data set.

In this dataset, we use Cambridge GIS Building IDs as unique identifiers for certified sustainable buildings. Building IDs refer to one physical structure, even if there are multiple street addresses associated with that structure.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"cambridgema-gov/certified-sustainable-buildings-4wmm-yatk\".\"certified_sustainable_buildings\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • certified_sustainable_buildings
Upstream Metadata