Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

10 rows where Borough = "STATEN IS" and Property Type = "College/University (Campus-Level)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2)

Calendar Year 3

Property Type 1

  • College/University (Campus-Level) · 10 ✖

Borough 1

  • STATEN IS · 10 ✖
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)
27937 27937 2012 2750759 Wagner College STATEN IS 631 Howard Avenue College/University (Campus-Level) 834490   6419.4 0.0        
30366 30366 2012 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue College/University (Campus-Level) 38000   244.6 0.0        
30370 30370 2012 2815047 Mahoney Hall STATEN IS 300 Howard Avenue College/University (Campus-Level) 12982   2667.4 0.0        
22599 22599 2011 2815047 Mahoney Hall STATEN IS 300 Howard Avenue College/University (Campus-Level) 12,982              
22602 22602 2011 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue College/University (Campus-Level) 38,000              
22621 22621 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue College/University (Campus-Level) 834,490              
22622 22622 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue College/University (Campus-Level) 834,490              
22623 22623 2011 2750759 Wagner Col STATEN IS 631 Howard Avenue College/University (Campus-Level) 834,490              
7774 7774 2010 2815016 Da Silva Academic Center STATEN IS 300 Howard Avenue College/University (Campus-Level) 38,000              
7780 7780 2010 2815047 Mahoney Hall STATEN IS 300 Howard Avenue College/University (Campus-Level) 12,982              

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