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

20 rows where Calendar Year = 2019 and Property Type = "Other - Mall" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Borough 5

  • QUEENS 5
  • BRONX 4
  • BROOKLYN 4
  • MANHATTAN 4
  • STATEN IS 1

Property Type 1

  • Other - Mall · 20 ✖

Calendar Year 1

  • 2019 · 20 ✖
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)
160255 160255 2019 2814714 2201 Nostrand Ave BROOKLYN 2201 Nostrand Ave Other - Mall 665,112 0.0 0.0 0.0 0.0 0.0 0.0  
163658 163658 2019 4114283 Heaven 223 w 34th St MANHATTAN 213-223 w 34th st Other - Mall 62,937 273.4 273.4 0.0 273.4 0.0 0.0  
164573 164573 2019 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54,000 0.0 0.0 0.0 0.0 0.0 0.0  
164805 164805 2019 4413933 132-07 14th Avenue - 24578 QUEENS 132-07 14th Avenue Other - Mall 154,000 4896.7 4896.7 0.0 4896.7 0.0 0.0  
164988 164988 2019 4478227 Harlem USA MANHATTAN 300 West 125th Street Other - Mall 275,000 6443.0 6443.0 0.0 6443.0 0.0 0.0  
168263 168263 2019 6224968 3rd Avenue MANHATTAN 2226 3rd Avenue Other - Mall 33,736 216.1 216.1 0.0 216.1 0.0 0.0  
169944 169944 2019 6287301 USP Apollo MANHATTAN 261 W 125 Street Other - Mall 29,000 3051.3 3051.3 0.0 3051.3 0.0 0.0  
171002 171002 2019 6297353 EDC - 3071521 - Moore Street Market (LL84) BROOKLYN 110 Moore St Other - Mall 15,000 12037.7 12037.7 0.0 12037.7 0.0 0.0  
173309 173309 2019 6602699 IWS Management - 1875 Nostrand ave BROOKLYN 1875 Nostrand ave Other - Mall 34,500 0.0 0.0 0.0 0.0 0.0 0.0  
173315 173315 2019 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 25,518 0.0 0.0 0.0 0.0 0.0 0.0  
173316 173316 2019 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25,631 0.0 0.0 0.0 0.0 0.0 0.0  
175856 175856 2019 6701581 Marshall's BRONX 352 Baychester Avenue Other - Mall 44,716 0.0 0.0 0.0 0.0 0.0 0.0  
175998 175998 2019 6706973 Rivoli Realty Corp.   188-02 to 188-22 Union Turnpike Other - Mall 29,715 1157.6 1157.6 0.0 1157.6 0.0 0.0  
176809 176809 2019 6789815 B-21 LLC   2101-2137 Broadway Other - Mall 25,340 74.8 74.8 0.0 74.8 0.0 0.0  
177076 177076 2019 6794254 502 86th St BROOKLYN 502 86th Street Other - Mall 32,500 431.7 431.7 0.0 431.7 0.0 0.0  
178956 178956 2019 7139624 3706 Third Avenue - 35822 BRONX 3706 Third Avenue Other - Mall 56,200 4146.4 4146.4 0.0 4146.4 0.0 0.0  
178980 178980 2019 7153094 Richmond Ave STATEN IS 2385 RICHMOND AVE Other - Mall 38,000 0.0 0.0 0.0 0.0 0.0 0.0  
180024 180024 2019 8862473 2918 Third Ave BRONX 2918 Third Ave Other - Mall 30,000 588.5 588.5 0.0 588.5 0.0 0.0  
181117 181117 2019 10512257 PANTZA REALTY CORP QUEENS 23-18 31ST STREET Other - Mall 37,589 791.0 791.0 0.0 791.0 0.0 0.0  
182733 182733 2019 11987154 90 East 170 Street BRONX 90 East 170 Street Other - Mall 41,201 94.9 94.9 0.0 94.9 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 23.876ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability