home / nyc_ll84

Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

9 rows where Borough = "MANHATTAN" 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

Calendar Year 3

  • 2011 4
  • 2012 3
  • 2010 2

Property Type 1

  • House of Worship · 9 ✖

Borough 1

  • MANHATTAN · 9 ✖
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)
24602 24602 2012 2657294 Chinatown Corps MANHATTAN 225 Bowery House of Worship 64760   0.0 0.0        
33898 33898 2012 3136028 Saint Thomas Church MANHATTAN 1 West 53rd Street House of Worship 51047   0.0 0.0        
34147 34147 2012 3250660 1047 Amsterdam Avenue MANHATTAN 1047 Amsterdam Avenue House of Worship 241550   0.0 0.0        
12704 12704 2011 2812870 Church of MANHATTAN 415 West 59th St House of Worship 77,098              
13164 13164 2011 3121252 Holy Spirit Association for the Unification of World Christianity / HSA-UWC MANHATTAN 4 W 43rd Street House of Worship                
13247 13247 2011 3136028 Saint Thomas Church MANHATTAN 1 West 53rd Street House of Worship 51,047              
13739 13739 2011 3121128 Christ Chu MANHATTAN 520 Park Avenue House of Worship 47,354              
4241 4241 2010 2657294 Chinatown Corps MANHATTAN 223-225 Bowery House of Worship 64,760              
9989 9989 2010 2793010 Bethel Gospel Assembly, Inc. MANHATTAN 1832 Madison Avenue House of Worship 139,404              

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");
Powered by Datasette · Queries took 1896.79ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability