Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

6 rows where Calendar Year = 2011 and Property Type = "Recreation" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1

Borough 3

Property Type 1

  • Recreation · 6 ✖

Calendar Year 1

  • 2011 · 6 ✖
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)
10939 10939 2011 2825073 Coles Sports and Recreation Center MANHATTAN 181 Mercer Street Recreation 177,109              
14319 14319 2011 2783462 The Jewish MANHATTAN 1109 5th Avenue Recreation 85,000              
17000 17000 2011 2638756 Coffey Spo BRONX 463 East Fordham Road Recreation 232,391              
21971 21971 2011 2810224 Carnesecca QUEENS 8000 Utopia Parkway Recreation 247,424              
21977 21977 2011 2810357 Jack Kaise QUEENS 8000 Utopia Parkway Recreation 144,000              
21984 21984 2011 2810361 Taffner Fi QUEENS 8000 Utopia Parkway Recreation 43,000              

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");