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

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

Calendar Year 5

  • 2017 7
  • 2018 2
  • 2016 1
  • 2019 1
  • 2024 1

Property Type 1

  • Other - Education · 12 ✖

Borough 1

  • STATEN IS · 12 ✖
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)
315427 315427 2024 6208789 Monsignor Farrell High School / Rectory Regional STATEN IS 2820 Amboy Road Other - Education 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
173013 173013 2019 6579407 D & M King Realty LLC - 300 West Service rd STATEN IS 300 West Service rd Other - Education 47,862 0.0 0.0 0.0 0.0 0.0 0.0  
135620 135620 2018 2978589 port richmond STATEN IS 281 port richmond avenue Other - Education 49,000 816.9 816.9 0.0 816.9 0.0 0.0  
148202 148202 2018 6579407 D & M King Realty LLC - 300 West Service rd STATEN IS 300 West Service rd Other - Education 47,862 0.0 0.0 0.0 0.0 0.0 0.0  
95093 95093 2017 2,978,589 port richmond STATEN IS 281 port richmond avenue Other - Education 49,000 102.0 102.0   102.0      
96021 96021 2017 2,978,589 port richmond STATEN IS 281 port richmond avenue Other - Education 49,000 102.0 102.0   102.0      
107902 107902 2017 6,236,830 St. Sylvester Church STATEN IS 864 Targee Street Other - Education 66,567 285.4 285.4   285.4      
121153 121153 2017 6,579,407 300 West Service rd - D & M King Realty LLC STATEN IS 300 West Service rd Other - Education 47,862              
125450 125450 2017 6,579,407 300 West Service rd - D & M King Realty LLC STATEN IS 300 West Service rd Other - Education 47,862              
126202 126202 2017 6,579,407 300 West Service rd - D & M King Realty LLC STATEN IS 300 West Service rd Other - Education 47,862              
127658 127658 2017 6,579,407 300 West Service rd - D & M King Realty LLC STATEN IS 300 West Service rd Other - Education 47,862              
94468 94468 2016 2,978,589 port richmond STATEN IS 281 port richmond avenue Other - Education 49,000 108467.5 108467.5 0.0 108467.5 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 1228.223ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability