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

11 rows where Borough = "STATEN IS" and Property Type = "Social/Meeting Hall" 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 7

  • 2019 3
  • 2020 3
  • 2013 1
  • 2014 1
  • 2021 1
  • 2022 1
  • 2023 1

Property Type 1

  • Social/Meeting Hall · 11 ✖

Borough 1

  • STATEN IS · 11 ✖
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)
295527 295527 2023 21355608 DPR_3847_High Rock Visitors Center STATEN IS 200 Nevada Ave Social/Meeting Hall 544 0.0 0.0 0.0 0.0 0.0 0.0  
271414 271414 2022 21355608 DPR_3847_High Rock Park Buildings STATEN IS 200 Nevada Ave Social/Meeting Hall 15,600 0.0 0.0 0.0 0.0 0.0 0.0  
223808 223808 2021 21355608 DPR_3847_High Rock Park Buildings STATEN IS 200 Nevada Ave Social/Meeting Hall 15,600 0.0 0.0 0.0 0.0 0.0 0.0  
198020 198020 2020 6294515 DPR - 5112436 - High Rock Park Buildings (LL84) STATEN IS 200 Nevada Ave Social/Meeting Hall 15600 0.0 0.0 0.0 0.0 0.0 0.0  
208797 208797 2020 12344431 BBL 5-02359-0001: Staten Island Historical Society, CIG, DPR (LL84) STATEN IS 700 Rockland Ave Social/Meeting Hall 12237 0.0 0.0 0.0 0.0 0.0 0.0  
208904 208904 2020 12344577 BBL 5-03355-0001: DPR (LL84) STATEN IS 621 Father Capodanno Blvd Social/Meeting Hall 16100 0.0 0.0 0.0 0.0 0.0 0.0  
170547 170547 2019 6294515 DPR - 5112436 - High Rock Park Buildings (LL84) STATEN IS 200 Nevada Ave Social/Meeting Hall 15,600 0.0 0.0 0.0 0.0 0.0 0.0  
183058 183058 2019 12344431 BBL 5-02359-0001: Staten Island Historical Society, CIG, DPR (LL84) STATEN IS 700 Rockland Ave Social/Meeting Hall 12,237 0.0 0.0 0.0 0.0 0.0 0.0  
183167 183167 2019 12344577 BBL 5-03355-0001: DPR (LL84) STATEN IS 621 Father Capodanno Blvd Social/Meeting Hall 16,100 0.0 0.0 0.0 0.0 0.0 0.0  
54890 54890 2014 2815008 Campus Center STATEN IS 300 Howard Avenue Social/Meeting Hall 32253 0.0 0.0   0.0     0.0
42491 42491 2013 2815008 Campus Center STATEN IS 300 Howard Avenue Social/Meeting Hall 32253 0.0 0.0   0.0   0.0 0.0

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 1203.688ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability