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 = 2010 and Property Type = "Health Care: Outpatient" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 2

Property Type 1

  • Health Care: Outpatient · 5 ✖

Calendar Year 1

  • 2010 · 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)
4792 4792 2010 2503315 660 MANHATTAN 660 First Avenue Health Care: Outpatient 112,000              
4793 4793 2010 1789746 Clinical Cancer Center MANHATTAN 160 E 34th Street Health Care: Outpatient 85,000              
5794 5794 2010 2790349 Audubon Realty Properties LLC MANHATTAN 21 Audubon Avenue Health Care: Outpatient 75,000              
5886 5886 2010 2663193 The FEGS Weinberg Center BRONX 3600 Jerome Avenue Health Care: Outpatient 77,220              
6557 6557 2010 2382101 Breast & Imaging Center MANHATTAN 300 E 65 St Health Care: Outpatient 236,086              

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