Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

7 rows where Calendar Year = 2012 and Property Type = "Lodging" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 3

Property Type 1

  • Lodging · 7 ✖

Calendar Year 1

  • 2012 · 7 ✖
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)
24387 24387 2012 2651692 thestanton MANHATTAN 196 stanton street Lodging 66371   0.0 0.0        
24937 24937 2012 2664412 Tillary Street Shelter BROOKLYN 200 Tillary Street Lodging 60460   0.0 0.0        
26787 26787 2012 2714174 New York Athletic Club MANHATTAN 180 Central Park South Lodging 400000   0.0 0.0        
28829 28829 2012 2795018 Belt Park Associates   153-90 Rockaway Boulavard Lodging 70690   0.0 0.0        
31921 31921 2012 2961856 175-15 Rockaway Blvd.   175-15 149 road Lodging 71482   0.0 0.0        
33493 33493 2012 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Lodging 69345   0.0 0.0        
33981 33981 2012 3187683 599 Ralph Ave BROOKLYN 599 Ralph Ave Lodging 65125   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");