Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

5 rows where Calendar Year = 2016 and Property Type = "Automobile Dealership" 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

Property Type 1

  • Automobile Dealership · 5 ✖

Calendar Year 1

  • 2016 · 5 ✖
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)
88577 88577 2016 2,820,270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE Automobile Dealership 65,625 0.0 0.0 0.0 0.0 0.0 0.0  
88578 88578 2016 2,820,273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE Automobile Dealership 91,256 0.0 0.0 0.0 0.0 0.0 0.0  
88579 88579 2016 4,124,879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave Automobile Dealership 137,456 0.0 0.0 0.0 0.0 0.0 0.0  
91943 91943 2016 5,224,698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd Automobile Dealership 60,485 69.6 69.6 0.0 69.6 0.0 0.0  
94650 94650 2016 5,236,998 open road manhattan llc   802 11 ave Automobile Dealership 228,000 0.0 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");