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 Calendar Year = 2016 and Property Type = "Strip 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 2

  • BRONX 5
  • STATEN IS 3

Property Type 1

  • Strip Mall · 10 ✖

Calendar Year 1

  • 2016 · 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)
78825 78825 2016 5,965,959 Broadway Plaza BRONX 5532 Broadway Strip Mall 114,723 0.0 0.0 0.0 0.0 0.0 0.0  
79014 79014 2016 5,038,341 Simone: 815 HUTCHINSON RIVER PARKWAY BRONX 815 HUTCHINSON RIVER PARKWAY, Strip Mall 305,970 0.0 0.0 0.0 0.0 0.0 0.0  
79029 79029 2016 4,259,004 Equity One 90-30 Metropolitan Ave   90-30 Metropolitan Strip Mall 64,868 669.6 669.6 0.0 669.6 0.0 0.0  
79122 79122 2016 5,889,721 Regency 171 W 230 St BRONX 171 W 230 St Strip Mall 114,473 5.2 5.2 0.0 5.2 0.0 0.0  
79751 79751 2016 5,877,641 814 WESTCHESTER AVENUE BRONX 814 WESTCHESTER AVENUE Strip Mall 55,000 2056.4 2056.4 0.0 2056.4 0.0 0.0  
81303 81303 2016 4,092,487 Bay Plaza Community Center, LLC BRONX 2100 Bartow Ave Strip Mall 539,647 0.0 0.0 0.0 0.0 0.0 0.0  
81450 81450 2016 3,091,477 Pergament 2795 STATEN IS 2795 Richmond Ave. Strip Mall 346,760 0.0 0.0 0.0 0.0 0.0 0.0  
90333 90333 2016 2,974,977 2712 Hylan Boulevard STATEN IS 2712 Hylan Boulevard Strip Mall 94,139 9151.0 9151.0 0.0 9151.0 0.0 0.0  
92878 92878 2016 4,722,760 River Plaza Building K1   40-64 225th Street Strip Mall 66,754 726.2 726.2 0.0 726.2 0.0 0.0  
94647 94647 2016 5,805,257 364 Bay Street STATEN IS 364 Bay Street Strip Mall 65,934 505.6 505.6 0.0 505.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");
Powered by Datasette · Queries took 1209.675ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability