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 Calendar Year = 2020 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

Property Type 1

  • Other - Mall · 12 ✖

Calendar Year 1

  • 2020 · 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)
191775 191775 2020 4114283 Heaven 223 w 34th St MANHATTAN 213-223 w 34th st Other - Mall 62937 158.5 158.5 0.0 158.5 0.0 0.0  
192604 192604 2020 4409881 51-00 Northern Blvd - 24583 QUEENS 51-00 Northern Blvd Other - Mall 54000 0.0 0.0 0.0 0.0 0.0 0.0  
192970 192970 2020 4478227 Harlem USA MANHATTAN 300 West 125th Street Other - Mall 275000 2364.6 2364.6 0.0 2364.6 0.0 0.0  
197517 197517 2020 6287301 USP Apollo MANHATTAN 261 W 125 Street Other - Mall 29000 1503.4 1503.4 0.0 1503.4 0.0 0.0  
200521 200521 2020 6602699 IWS Management - 1875 Nostrand ave BROOKLYN 1875 Nostrand ave Other - Mall 34500 0.0 0.0 0.0 0.0 0.0 0.0  
200527 200527 2020 6602844 Lewis & Murphy Realty Inc - 6816 Main St QUEENS 6816 Main St Other - Mall 25518 0.0 0.0 0.0 0.0 0.0 0.0  
200528 200528 2020 6602848 Lewis & Murphy Realty Inc - 11313 Queens blvd QUEENS 11313 Queens blvd Other - Mall 25631 483.9 483.9 0.0 483.9 0.0 0.0  
202798 202798 2020 6706973 Rivoli Realty Corp.   188-02 to 188-22 Union Turnpike Other - Mall 29715 646.1 646.1 0.0 646.1 0.0 0.0  
203495 203495 2020 6789815 B-21 LLC   2101-2137 Broadway Other - Mall 25340 5559.5 5559.5 0.0 5559.5 0.0 0.0  
203718 203718 2020 6794254 502 86th St BROOKLYN 502 86th Street Other - Mall 32500 0.0 0.0 0.0 0.0 0.0 0.0  
205381 205381 2020 7153094 Richmond Ave STATEN IS 2385 RICHMOND AVE Other - Mall 38000 0.0 0.0 0.0 0.0 0.0 0.0  
206268 206268 2020 8862473 2918 Third Ave BRONX 2918 Third Ave Other - Mall 30000 1051.6 1051.6 0.0 1051.6 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");