home / nyc_ll84

GHG trend — one building over all years

Replace 12345 with any Property ID. Then click Visualize → Bar or Line → X=Calendar Year, Y=Total GHG or GHGI.

Custom SQL query (hide)

SELECT
    "Calendar Year",
    "Property Name",
    "Total GHG (MtCO2e)",
    "GHGI (kgCO2e/m2)",
    "Direct GHG (MtCO2e)",
    "Indirect GHG (MtCO2e)",
    "Site EUI (kBtu/ft2)"
FROM ghg
WHERE "Property ID" = '12345'
ORDER BY "Calendar Year"

Edit SQL

0 results

Powered by Datasette · Queries took 0.518ms