Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

6 rows where Borough = "STATEN IS" and Property Type = "House of Worship" 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

  • House of Worship · 6 ✖

Borough 1

  • STATEN IS · 6 ✖
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)
30367 30367 2012 2815019 Lavelle Hall STATEN IS 300 Howard Avenue House of Worship 25700   0.0 0.0        
33632 33632 2012 3126882 Pious Society of St Paul STATEN IS 2187 Victory Blvd House of Worship 82375   0.0 0.0        
22569 22569 2011 3126882 Pious Soci STATEN IS 2187 Victory Blvd House of Worship 82,375              
22598 22598 2011 2815019 Lavelle Hall STATEN IS 300 Howard Avenue House of Worship 25,700              
22728 22728 2011 3117867 Gateway Ca STATEN IS 200 Boscombe Avenue House of Worship 61,673              
7778 7778 2010 2815019 Lavelle Hall STATEN IS 300 Howard Avenue House of Worship 25,700              

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