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

15 rows where Calendar Year = 2023 and Property Type = "Other - Education" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal), Municipal Mixed Water (kgal)

Borough 4

  • BRONX 5
  • MANHATTAN 4
  • BROOKLYN 3
  • QUEENS 2

Property Type 1

  • Other - Education · 15 ✖

Calendar Year 1

  • 2023 · 15 ✖
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)
272282 272282 2023 6675149 Jacob Shafran - 1164 Garrison ave BRONX 1164 Garrison ave Other - Education 32,135 0.0 0.0 0.0 0.0 0.0 0.0  
280176 280176 2023 1633736 X989 (OECID: 0201285; BBL: 2031060028) BRONX 2007 Mapes Avenue Other - Education 9,600 0.0 0.0 0.0 0.0 0.0 0.0  
280817 280817 2023 1836818 K905 (OECID: 0301645; BBL: 3083930001) BROOKLYN 7151 Avenue T Other - Education 9,600 245.6 245.6 0.0 245.6 0.0 0.0  
284831 284831 2023 2961640 Jewish Theological Seminary MANHATTAN 3080 Broadway Other - Education 277,000 2724.4 0.0 0.0 0.0 0.0 2724.4  
291271 291271 2023 16002690 35 East 125th Street - data MANHATTAN 35 East 125th Street Other - Education 92,969 0.0 0.0 0.0 0.0 0.0 0.0  
293805 293805 2023 21353845 DPR_10075_Comfort Station to K286 BROOKLYN 2525 Haring St Other - Education 395 0.0 0.0 0.0 0.0 0.0 0.0  
293810 293810 2023 21353853 DOE_10116_K516 AF BROOKLYN 6565 Flatlands Ave Other - Education 4,800 0.0 0.0 0.0 0.0 0.0 0.0  
293836 293836 2023 21353879 CUNY CC > BCC_353_Bronx CC: Greenhouse   185 West 108th St Other - Education 265 0.0 0.0 0.0 0.0 0.0 0.0  
294060 294060 2023 21354105 CIG > WCS BZ_9347_Bronx Zoo: Education Trailer #1 BRONX 2300 Southern Blvd Other - Education 750 0.0 0.0 0.0 0.0 0.0 0.0  
294207 294207 2023 21354252 CIG > NYBG_11795_NYBG: Picnic Pavilions BRONX 2670 Dr. Theodore Kazimiroff Blvd Other - Education 2,700 0.0 0.0 0.0 0.0 0.0 0.0  
294209 294209 2023 21354255 CIG > NYBG_11798_NYBG: Edible Academy BRONX 2662 Southern Blvd Other - Education 8,070 0.0 0.0 0.0 0.0 0.0 0.0  
294584 294584 2023 21354634 CIG > QBG_11871_QBG: Education Building QUEENS 43-50 Main St Other - Education 2,617 0.0 0.0 0.0 0.0 0.0 0.0  
296165 296165 2023 24896821 434 Sixth Avenue MANHATTAN 434 Sixth Avenue Other - Education 28,920 1135.5 1135.5 0.0 1135.5 0.0 0.0  
300905 300905 2023 5049424 Eldridge T. Gerry Clubhouse MANHATTAN 321 EAST 111 STREET Other - Education 50,646 170.6 170.6 0.0 170.6 0.0 0.0  
304248 304248 2023 6312077 Marion McMahon Abbe Clubhouse QUEENS 133-01 41st Road Other - Education 38,989 489.4 489.4 0.0 489.4 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 1279.849ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability