Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

5 rows where Calendar Year = 2011 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 · 5 ✖

Calendar Year 1

  • 2011 · 5 ✖
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)
12398 12398 2011 2714174 New York Athletic Club MANHATTAN 180 Central Park South Lodging 400,000              
18410 18410 2011 3187683 599 Ralph BROOKLYN 599 Ralph Ave Lodging 65,125              
18607 18607 2011 2664412 Tillary Street Shelter BROOKLYN 200 Tillary Street Lodging 60,460              
22449 22449 2011 3121307 175-21 149 Avenue QUEENS 175-21 149 Avenue Lodging 69,345              
22450 22450 2011 2961856 175-15 Rockaway Blvd.   175-15 149 road Lodging 71,482              

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