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

14 rows where Calendar Year = 2012 and Property Type = "Recreation" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1, Indoor Water Use (kgal)

Borough 5

  • QUEENS 4
  • BROOKLYN 3
  • BRONX 2
  • MANHATTAN 2
  • STATEN IS 2

Property Type 1

  • Recreation · 14 ✖

Calendar Year 1

  • 2012 · 14 ✖
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)
23898 23898 2012 2638756 Coffey Sportplex BRONX 463 East Fordham Road Recreation 232391   0.0 0.0        
29912 29912 2012 2810224 Carnesecca Arena QUEENS 8000 Utopia Parkway Recreation 247424   13472.2 0.0        
29954 29954 2012 2810357 Jack Kaiser Stadium QUEENS 8000 Utopia Parkway Recreation 144000   7840.5 0.0        
29955 29955 2012 2810361 Taffner Field House QUEENS 8000 Utopia Parkway Recreation 43000   2340.5 0.0        
30974 30974 2012 2825073 Coles Sports and Recreation Center MANHATTAN 181 Mercer Street Recreation 177109   0.0 0.0        
33925 33925 2012 3167378 1121 Bedford Avenue BROOKLYN 1121 Bedford Avenue Recreation 65000   0.0 0.0        
33926 33926 2012 3167399 1401 Flatbush Avenue   1401 Flathbush Avenue Recreation 25545   0.0 0.0        
33927 33927 2012 3167436 2 Castle Hill Avenue BRONX 2 Castle Hill Avenue Recreation 30700   0.0 0.0        
33928 33928 2012 3167474 651 Broadway STATEN IS 651 Broadway Recreation 39233   0.0 0.0        
33929 33929 2012 3167480 69-02 64th Street QUEENS 69-02 64th Street Recreation 18600   0.0 0.0        
33930 33930 2012 3167482 99 Meserole Avenue BROOKLYN 99 Meserole Avenue Recreation 40000   0.0 0.0        
34352 34352 2012 3325368 LA Fitness STATEN IS 145 East Service Rd. Recreation 51609   1946.3 0.0        
35154 35154 2012 3526401 Vertical Projects, LLC MANHATTAN 330 East 61st Street Recreation 115000   0.0 0.0        
35876 35876 2012 3544325 570 Jamaica Avenue BROOKLYN 570 Jamaica Avenue Recreation 47200   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 548.782ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability