Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

8 rows where Calendar Year = 2010 and Property Type = "Mall (Strip Mall and Enclosed)" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 4

Property Type 1

  • Mall (Strip Mall and Enclosed) · 8 ✖

Calendar Year 1

  • 2010 · 8 ✖
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)
4935 4935 2010 2706284 LaGuardia Center QUEENS 43-02 Ditmars Blvd Mall (Strip Mall and Enclosed)                
5511 5511 2010 2770620 Forest Mall   1351 & 1377 Forest Ave Mall (Strip Mall and Enclosed) 108,283              
7415 7415 2010 2678643 Atlantic Center BROOKLYN 197 Fort Greene Place Mall (Strip Mall and Enclosed) 392,000              
7416 7416 2010 2642783 Atlantic Terminal BROOKLYN 200 Fort Green Pl. Mall (Strip Mall and Enclosed) 372,667              
7417 7417 2010 2678637 Bruckner BRONX 845 White Plains Rd. Mall (Strip Mall and Enclosed) 114,425              
7421 7421 2010 2678649 Northern QUEENS 48-18 Northern Blvd. Mall (Strip Mall and Enclosed) 217,599              
7422 7422 2010 2678650 Queens Place Mall QUEENS 88-01 Queens Blvd Mall (Strip Mall and Enclosed) 398,993              
7423 7423 2010 2678669 Richmond Avenue STATEN IS 2505-2535 Richmond Ave. Mall (Strip Mall and Enclosed) 76,000              

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");