Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

8 rows where Calendar Year = 2015 and Property Type = "Laboratory" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 3

Property Type 1

  • Laboratory · 8 ✖

Calendar Year 1

  • 2015 · 8 ✖
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)
62674 62674 2015 1230813 Zuckerman MANHATTAN 415 E 68 St Laboratory 743935 0.0 0.0 0.0 0.0 0.0 0.0 0.0
62675 62675 2015 1230818 Rockefeller Research Lab MANHATTAN 430 E 67 St Laboratory 327993 0.0 0.0 0.0 0.0 0.0 0.0 0.0
64484 64484 2015 2731805 170 East Gunhill Road BRONX 170 East Gunhill Road Laboratory 180000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
68203 68203 2015 4143131 LL84 Smilow MANHATTAN 522 First Avenue Laboratory 360423 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74277 74277 2015 4628649 OCME - 1087242 - OCME Center for Forensic Sciences MANHATTAN 421 East 26th St Laboratory 330000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74576 74576 2015 4628999 DOHMH - 1020610 - Public Health Laboratory MANHATTAN 455 1st Ave Laboratory 324505 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74963 74963 2015 4629596 NYPD - 4215603 - NYPD Police Laboratory   Classified Laboratory 132500 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75036 75036 2015 4629750 CIG - 3029723 - BBG Technical Services Center BROOKLYN 109 Montgomery St Laboratory 21523 0.0 0.0 0.0 0.0 0.0 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");