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

32 rows where Borough = "MANHATTAN" and Property Type = "Strip Mall" 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 10

  • 2017 6
  • 2019 4
  • 2020 4
  • 2021 4
  • 2022 4
  • 2024 4
  • 2023 3
  • 2013 1
  • 2014 1
  • 2018 1

Property Type 1

  • Strip Mall · 32 ✖

Borough 1

  • MANHATTAN · 32 ✖
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)
315668 315668 2024 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 535 La Guardia Place Strip Mall 33,738 3110.1 3110.1 0.0 3110.1 0.0 0.0  
316110 316110 2024 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47,292 0.0 0.0 0.0 0.0 0.0 0.0  
316111 316111 2024 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47,310 0.0 0.0 0.0 0.0 0.0 0.0  
342801 342801 2024 60614193 385 Broadway MANHATTAN 385 Broadway Strip Mall 33,491 0.0 0.0 0.0 0.0 0.0 0.0  
302302 302302 2023 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 543 LaGuardia Place Strip Mall 33,738 3001.5 3001.5 0.0 3001.5 0.0 0.0  
303220 303220 2023 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47,292 0.0 0.0 0.0 0.0 0.0 0.0  
303221 303221 2023 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47,310 0.0 0.0 0.0 0.0 0.0 0.0  
260052 260052 2022 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 543 LaGuardia Place Strip Mall 33,738 2497.8 2497.8 0.0 2497.8 0.0 0.0  
264348 264348 2022 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47,292 867.5 867.5 0.0 867.5 0.0 0.0  
264349 264349 2022 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47,310 0.0 0.0 0.0 0.0 0.0 0.0  
265353 265353 2022 6815615 4261 Broadway MANHATTAN 4261 Broadway Strip Mall 41,702 0.0 0.0 0.0 0.0 0.0 0.0  
218031 218031 2021 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 543 LaGuardia Place Strip Mall 33,738 2699.1 2699.1 0.0 2699.1 0.0 0.0  
220301 220301 2021 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47,292 590.6 590.6 0.0 590.6 0.0 0.0  
220302 220302 2021 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47,310 0.0 0.0 0.0 0.0 0.0 0.0  
229290 229290 2021 6815615 4261 Broadway MANHATTAN 4261 Broadway Strip Mall 41,702 0.0 0.0 0.0 0.0 0.0 0.0  
196173 196173 2020 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 543 LaGuardia Place Strip Mall 33738 2147.6 2147.6 0.0 2147.6 0.0 0.0  
196841 196841 2020 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47292 508.4 508.4 0.0 508.4 0.0 0.0  
196842 196842 2020 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47310 0.0 0.0 0.0 0.0 0.0 0.0  
204506 204506 2020 6815615 4261 Broadway MANHATTAN 4261 Broadway Strip Mall 41702 0.0 0.0 0.0 0.0 0.0 0.0  
168467 168467 2019 6233974 Copy Central / 535-555 LaGuardia Place MANHATTAN 543 LaGuardia Place Strip Mall 33,738 3461.3 3461.3 0.0 3461.3 0.0 0.0  
169195 169195 2019 6281283 2231-2239 Broadway MANHATTAN 2231-2239 Broadway Strip Mall 47,292 0.0 0.0 0.0 0.0 0.0 0.0  
169196 169196 2019 6281286 3781-3799 Broadway MANHATTAN 3781-3799 Broadway Strip Mall 47,310 0.0 0.0 0.0 0.0 0.0 0.0  
177978 177978 2019 6815615 4261 Broadway MANHATTAN 4261 Broadway Strip Mall 41,702 0.0 0.0 0.0 0.0 0.0 0.0  
143495 143495 2018 6233974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 2396.4 2396.4 0.0 2396.4 0.0 0.0  
117983 117983 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
118169 118169 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
118598 118598 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
119708 119708 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
121787 121787 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
122955 122955 2017 6,233,974 Copy Central - 543 LaGuardia Place MANHATTAN 543 La Guardia Place Strip Mall 31,040 3.0 3.0   3.0      
60115 60115 2014 4092487 Bay Plaza Community Center, LLC MANHATTAN 546 5th Avenue Strip Mall 500196 0.0 0.0   0.0     0.0
48858 48858 2013 4092487 Bay Plaza Community Center, LLC MANHATTAN 546 5th Avenue Strip Mall 500196 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 1143.977ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability