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

12 rows where Calendar Year = 2012 and Property Type = "Public Assembly" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Indoor Water Use (kgal)

Borough 5

  • QUEENS 5
  • MANHATTAN 3
  • STATEN IS 2
  • BRONX 1
  • BROOKLYN 1

Property Type 1

  • Public Assembly · 12 ✖

Calendar Year 1

  • 2012 · 12 ✖
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)
23771 23771 2012 2630425 Apollo Theater MANHATTAN 253 W. 125th St. Public Assembly 64400   0.0 0.0        
31018 31018 2012 2827343 Sunset LG Realty LLC BROOKLYN 699 92nd Street Public Assembly 332127   18978.4 0.0        
31026 31026 2012 2827557 1440 Story LLC BRONX 1440 Story Ave Public Assembly 80313   2505.8 0.0        
32020 32020 2012 2969010 141 East Service Road STATEN IS 141 East Service Road Public Assembly 71485   0.0 0.0        
34256 34256 2012 3305728 Schwartz Brothers: 114-03 Queens Blvd QUEENS 114-03 Queens Blvd Public Assembly 53550   267.6 0.0        
35866 35866 2012 3544252 125 West 14th Street MANHATTAN 125 West 14th Street Public Assembly 67000   0.0 0.0        
35869 35869 2012 3544255 224 East 47th Street MANHATTAN 224 East 47th Street Public Assembly 152476   0.0 0.0        
35871 35871 2012 3544306 238-10 Hillside Avenue QUEENS 238-10 Hillside Avenue Public Assembly 54500   0.0 0.0        
35872 35872 2012 3544307 32-23 Queens Boulevard QUEENS 32-23 Queens Boulevard Public Assembly 53150   0.0 0.0        
35874 35874 2012 3544309 3939 Richmond Avenue STATEN IS 3939 Richmond Avenue Public Assembly 46020   0.0 0.0        
35877 35877 2012 3544326 89-25 Parsons Boulevard QUEENS 89-25 Parsons Boulevard Public Assembly 103900   0.0 0.0        
35923 35923 2012 3550340 Studio Square NYC QUEENS 35-37 36th Street Public Assembly 65904   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 936.131ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability