Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

26 rows where Borough = "QUEENS" 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) · 26 ✖

Borough 1

  • QUEENS · 26 ✖
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)
28524 28524 2012 2788606 RSA 76-01 147 Street QUEENS 76-01 147th St College/University (Campus-Level) 83794   0.0 0.0        
29919 29919 2012 2810269 St. John Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 142700   7767.2 0.0        
29922 29922 2012 2810276 St. Albert Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 175800   9572.2 0.0        
29923 29923 2012 2810281 Belson Hall/Finley Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 215389   11727.1 0.0        
29925 29925 2012 2810284 College of Pharmacy QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4416   240.1 0.0        
29939 29939 2012 2810307 St. Augustine Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 168600   9176.5 0.0        
29940 29940 2012 2810313 Sullivan Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 72438   3943.5 0.0        
29947 29947 2012 2810335 Belson Stadium QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4435   241.6 0.0        
29952 29952 2012 2810354 D'Angelo Center QUEENS 8000 Utopia Parkway College/University (Campus-Level) 120000   6534.5 0.0        
21923 21923 2011 2788606 RSA QUEENS 76-01 147th St College/University (Campus-Level) 83,794              
21959 21959 2011 2810281 Belson Hal QUEENS 8000 Utopia Parkway College/University (Campus-Level) 215,389              
21960 21960 2011 2810269 St. John H QUEENS 8000 Utopia Parkway College/University (Campus-Level) 142,700              
21963 21963 2011 2810354 D'Angelo C QUEENS 8000 Utopia Parkway College/University (Campus-Level) 120,000              
21965 21965 2011 2810307 St. August QUEENS 8000 Utopia Parkway College/University (Campus-Level) 168,600              
21973 21973 2011 2810276 St. Albert QUEENS 8000 Utopia Parkway College/University (Campus-Level) 175,800              
21974 21974 2011 2810335 Belson Sta QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4,435              
21976 21976 2011 2810313 Sullivan H QUEENS 8000 Utopia Parkway College/University (Campus-Level) 72,438              
21980 21980 2011 2810284 College of QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4,416              
8314 8314 2010 2810281 Belson Hall/Finley Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 215,389              
8316 8316 2010 2810335 Belson Stadium QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4,435              
8321 8321 2010 2810284 College of Pharmacy QUEENS 8000 Utopia Parkway College/University (Campus-Level) 4,416              
8324 8324 2010 2810354 D'Angelo Center QUEENS 8000 Utopia Parkway College/University (Campus-Level) 120,000              
8336 8336 2010 2810276 St. Albert Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 175,800              
8338 8338 2010 2810307 St. Augustine Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 168,600              
8339 8339 2010 2810269 St. John Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 142,700              
8342 8342 2010 2810313 Sullivan Hall QUEENS 8000 Utopia Parkway College/University (Campus-Level) 72,438              

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