home / nyc_ll84

Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

5 rows where Calendar Year = 2023 and Property Type = "Other - Technology/Science" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Property Type 1

  • Other - Technology/Science · 5 ✖

Calendar Year 1

  • 2023 · 5 ✖

Borough 1

  • MANHATTAN 5
Link rowid Calendar Year ▲ Property ID Property Name Borough Address 1 Property Type Floor Area (ft2) Total Water Use (kgal) Indoor Water Use (kgal) Outdoor Water Use (kgal) Municipal Indoor Water (kgal) Municipal Outdoor Water (kgal) Municipal Mixed Water (kgal) Indoor Water Intensity (gal/ft2)
276464 276464 2023 8899918 61 9th Avenue MANHATTAN 61 9th Avenue Other - Technology/Science 156,571 4677.6 4677.6 0.0 4677.6 0.0 0.0  
283129 283129 2023 2712335 SL Green Realty Corporation 919 Third Avenue MANHATTAN 919 Third Avenue Other - Technology/Science 1,428,504 0.0 0.0 0.0 0.0 0.0 0.0  
283142 283142 2023 2712470 SL Green Realty Corporation 1515 Broadway MANHATTAN 1515 Broadway Other - Technology/Science 2,052,075 32590.4 32590.4 0.0 32590.4 0.0 0.0  
300655 300655 2023 5037090 LL84 - TRB (227 E 30th S) MANHATTAN 227 East 30th St Other - Technology/Science 182,506 4714.4 4714.4 0.0 4714.4 0.0 0.0  
301331 301331 2023 5857171 Nurses Residence: 3 E 101 St MANHATTAN 3 E 101 St Other - Technology/Science 71,740 0.0 0.0 0.0 0.0 0.0 0.0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE water(
  "Calendar Year" INT,
  "Property ID" TEXT,
  "Property Name" TEXT,
  Borough TEXT,
  "Address 1" TEXT,
  "Property Type" TEXT,
  "Floor Area (ft2)" TEXT,
  "Total Water Use (kgal)" REAL,
  "Indoor Water Use (kgal)" REAL,
  "Outdoor Water Use (kgal)" REAL,
  "Municipal Indoor Water (kgal)" REAL,
  "Municipal Outdoor Water (kgal)" REAL,
  "Municipal Mixed Water (kgal)" REAL,
  "Indoor Water Intensity (gal/ft2)" REAL
);
CREATE INDEX "idx_water_Calendar Year" ON [water] ("Calendar Year");
CREATE INDEX "idx_water_Property ID" ON [water] ("Property ID");
CREATE INDEX "idx_water_Borough" ON [water] ("Borough");
CREATE INDEX "idx_water_Property Type" ON [water] ("Property Type");
Powered by Datasette · Queries took 26.886ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability