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

49 rows where Borough = "STATEN IS" and Property Type = "Library" 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), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Calendar Year 15

  • 2020 7
  • 2023 5
  • 2015 4
  • 2016 4
  • 2017 4
  • 2018 4
  • 2019 4
  • 2021 4
  • 2022 4
  • 2024 4
  • 2010 1
  • 2011 1
  • 2012 1
  • 2013 1
  • 2014 1

Property Type 1

  • Library · 49 ✖

Borough 1

  • STATEN IS · 49 ✖
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)
328819 328819 2024 21355506 NYPL_4683_New Dorp Branch Library STATEN IS 309 New Dorp Ln Library 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
328820 328820 2024 21355507 NYPL_4687_St. George Library Center STATEN IS 10 Hyatt St Library 19,280 0.0 0.0 0.0 0.0 0.0 0.0  
328821 328821 2024 21355508 NYPL_4688_Stapleton Branch Library STATEN IS 132 Canal St Library 10,860 0.0 0.0 0.0 0.0 0.0 0.0  
332596 332596 2024 33910536 NYPL_14330_Charleston Branch Library STATEN IS 225 Bricktown Way Library 10,205 0.0 0.0 0.0 0.0 0.0 0.0  
289672 289672 2023 33910536 NYPL_14330_Charleston Branch Library STATEN IS 225 Bricktown Way Library 10,205 0.0 0.0 0.0 0.0 0.0 0.0  
290975 290975 2023 15583885 Loretto Library STATEN IS 300 Howard Avenue Library 18,739 0.0 0.0 0.0 0.0 0.0 0.0  
295436 295436 2023 21355506 NYPL_4683_New Dorp Branch Library STATEN IS 309 New Dorp Ln Library 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
295437 295437 2023 21355507 NYPL_4687_St. George Library Center STATEN IS 10 Hyatt St Library 19,280 257.0 257.0 0.0 257.0 0.0 0.0  
295438 295438 2023 21355508 NYPL_4688_Stapleton Branch Library STATEN IS 132 Canal St Library 10,860 0.0 0.0 0.0 0.0 0.0 0.0  
257340 257340 2022 15583885 Loretto Library STATEN IS 300 Howard Avenue Library 18,739 0.0 0.0 0.0 0.0 0.0 0.0  
271324 271324 2022 21355506 NYPL_4683_New Dorp Branch Library STATEN IS 309 New Dorp Ln Library 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
271325 271325 2022 21355507 NYPL_4687_St. George Library Center STATEN IS 10 Hyatt St Library 19,280 134.3 134.3 0.0 134.3 0.0 0.0  
271326 271326 2022 21355508 NYPL_4688_Stapleton Branch Library STATEN IS 132 Canal St Library 10,860 0.0 0.0 0.0 0.0 0.0 0.0  
223706 223706 2021 21355506 NYPL_4683_New Dorp Branch Library STATEN IS 309 New Dorp Ln Library 12,000 35.9 35.9 0.0 35.9 0.0 0.0  
223707 223707 2021 21355507 NYPL_4687_St. George Library Center STATEN IS 10 Hyatt St Library 19,280 61.9 61.9 0.0 61.9 0.0 0.0  
223708 223708 2021 21355508 NYPL_4688_Stapleton Branch Library STATEN IS 132 Canal St Library 10,860 0.0 0.0 0.0 0.0 0.0 0.0  
225238 225238 2021 15583885 Loretto Library STATEN IS 300 Howard Avenue Library 18,739 0.0 0.0 0.0 0.0 0.0 0.0  
198396 198396 2020 6297270 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12000 31.9 31.9 0.0 31.9 0.0 0.0  
198397 198397 2020 6297272 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14477 24.0 24.0 0.0 24.0 0.0 0.0  
198398 198398 2020 6297273 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25029 187.8 187.8 0.0 187.8 0.0 0.0  
198484 198484 2020 6297479 NYPL - 5109138 - Mariners Harbor Library (LL84) STATEN IS 206 South Ave Library 10100 36.2 36.2 0.0 36.2 0.0 0.0  
209811 209811 2020 14887376 NYPL - 3106505 - Stapleton Branch Library (LL84) STATEN IS 132 Canal St Library 10860 0.0 0.0 0.0 0.0 0.0 0.0  
210841 210841 2020 15583885 Loretto Library STATEN IS 300 Howard Avenue Library 18739 0.0 0.0 0.0 0.0 0.0 0.0  
210842 210842 2020 15583885 Loretto Library STATEN IS 300 Howard Avenue Library 18739 0.0 0.0 0.0 0.0 0.0 0.0  
170973 170973 2019 6297270 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12,000 835.3 835.3 0.0 835.3 0.0 0.0  
170974 170974 2019 6297272 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14,477 348.6 348.6 0.0 348.6 0.0 0.0  
170975 170975 2019 6297273 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25,029 1433.1 1433.1 0.0 1433.1 0.0 0.0  
171099 171099 2019 6297479 NYPL - 5109138 - Mariners Harbor Library (LL84) STATEN IS 206 South Ave Library 10,100 562.4 562.4 0.0 562.4 0.0 0.0  
146010 146010 2018 6297270 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
146011 146011 2018 6297272 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14,477 0.0 0.0 0.0 0.0 0.0 0.0  
146012 146012 2018 6297273 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25,029 0.0 0.0 0.0 0.0 0.0 0.0  
146134 146134 2018 6297479 NYPL - 5109138 - Mariners Harbor Library (LL84) STATEN IS 206 South Ave Library 10,100 0.0 0.0 0.0 0.0 0.0 0.0  
103052 103052 2017 6,297,272 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14,477              
106509 106509 2017 6,297,270 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12,000              
106798 106798 2017 6,297,273 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25,029              
106803 106803 2017 6,297,479 NYPL - 5109138 - Mariner s Harbor Library (LL84) STATEN IS 206 South Ave Library 10,100              
85475 85475 2016 4,629,672 NYPL - 5052750 - New Dorp Branch Library (LL84) STATEN IS 309 New Dorp Ln Library 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
85476 85476 2016 4,629,674 NYPL - 5060744 - Richmondtown Branch Library (LL84) STATEN IS 200 Clarke Ave Library 14,477 0.0 0.0 0.0 0.0 0.0 0.0  
85477 85477 2016 4,629,675 NYPL - 5000030 - St. George Library Center (LL84) STATEN IS 10 Hyatt St Library 25,029 0.0 0.0 0.0 0.0 0.0 0.0  
85595 85595 2016 4,629,873 NYPL - 5109138 - Mariner s Harbor Library (LL84) STATEN IS 206 South Ave Library 10,100 0.0 0.0 0.0 0.0 0.0 0.0  
75012 75012 2015 4629672 NYPL - 5052750 - New Dorp Branch Library STATEN IS 309 New Dorp Ln Library 12000 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75013 75013 2015 4629674 NYPL - 5060744 - Richmondtown Branch Library STATEN IS 200 Clarke Ave Library 14477 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75014 75014 2015 4629675 NYPL - 5000030 - St. George Library Center STATEN IS 10 Hyatt St Library 25029 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75130 75130 2015 4629873 NYPL - 5109138 - Mariners Harbor Library STATEN IS 206 South Ave Library 10100 0.0 0.0 0.0 0.0 0.0 0.0 0.0
54898 54898 2014 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18739 0.0 0.0   0.0     0.0
42498 42498 2013 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18739 0.0 0.0   0.0   0.0 0.0
30375 30375 2012 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18739   0.0 0.0        
22597 22597 2011 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18,739              
7779 7779 2010 2815089 Loreto Memorial Library STATEN IS 300 Howard Avenue Library 18,739              

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