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 Borough = "QUEENS" and Property Type = "Education" 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), Indoor Water Use (kgal)

Calendar Year 3

Property Type 1

  • Education · 8 ✖

Borough 1

  • QUEENS · 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)
22989 22989 2012 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Education 92705   0.0 0.0        
28977 28977 2012 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609247   5314.1 0.0        
34335 34335 2012 3321105 NY School of Urban Ministry QUEENS 31-10 47th Street Education 70000   0.0 0.0        
34411 34411 2012 3332502 Congregation YGS QUEENS 74-10 88th Street Education 66713   0.0 0.0        
20516 20516 2011 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247              
21534 21534 2011 1819837 Center for QUEENS 15-30 Petracca Place Education 92,705 10.0 10.0         114.89
722 722 2010 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Education                
9155 9155 2010 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247              

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