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

10 rows where Borough = "STATEN IS" and Property Type = "Other - Technology/Science" 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 4

  • 2019 3
  • 2020 3
  • 2021 3
  • 2015 1

Property Type 1

  • Other - Technology/Science · 10 ✖

Borough 1

  • STATEN IS · 10 ✖
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)
234755 234755 2021 4509454 CO/GLC 34310/355 FOREST AVE/STATEN ISLAND/NY STATEN IS 355 FOREST AVE Other - Technology/Science 75,510 54.0 54.0 0.0 54.0 0.0 0.0  
234757 234757 2021 5062466 CO/GLC 34246/5180 AMBOY RD/STATEN ISLAND/NY STATEN IS 5180 AMBOY RD Other - Technology/Science 46,400 2385.0 2385.0 0.0 2385.0 0.0 0.0  
234761 234761 2021 6283329 CO/GLC 34215/42 NEW DORP LN/STATEN ISLAND/NY STATEN IS 42 NEW DORP LN Other - Technology/Science 28,768 11.0 11.0 0.0 11.0 0.0 0.0  
193064 193064 2020 4509454 CO/GLC 34310/355 FOREST AVE/STATEN ISLAND/NY STATEN IS 355 FOREST AVE Other - Technology/Science 75510 150.0 150.0 0.0 150.0 0.0 0.0  
194284 194284 2020 5062466 CO/GLC 34246/5180 AMBOY RD/STATEN ISLAND/NY STATEN IS 5180 AMBOY RD Other - Technology/Science 46400 2620.0 2620.0 0.0 2620.0 0.0 0.0  
197405 197405 2020 6283329 CO/GLC 34215/42 NEW DORP LN/STATEN ISLAND/NY STATEN IS 42 NEW DORP LN Other - Technology/Science 28768 4652.0 4652.0 0.0 4652.0 0.0 0.0  
165098 165098 2019 4509454 CO/GLC 34310/355 FOREST AVE/STATEN ISLAND/NY STATEN IS 355 FOREST AVE Other - Technology/Science 75,510 698.0 698.0 0.0 698.0 0.0 0.0  
166433 166433 2019 5062466 CO/GLC 34246/5180 AMBOY RD/STATEN ISLAND/NY STATEN IS 5180 AMBOY RD Other - Technology/Science 46,400 2499.0 2499.0 0.0 2499.0 0.0 0.0  
169822 169822 2019 6283329 CO/GLC 34215/42 NEW DORP LN/STATEN ISLAND/NY STATEN IS 42 NEW DORP LN Other - Technology/Science 28,768 7090.0 7090.0 0.0 7090.0 0.0 0.0  
74565 74565 2015 4628987 DOITT - 5999999 - DoITT Facility STATEN IS 11 Storer Ave Other - Technology/Science 18160 0.0 0.0 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 24.336ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability