Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

9 rows where Calendar Year = 2013 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), Municipal Mixed Water (kgal), Indoor Water Intensity (gal/ft2)

Borough 2

Property Type 1

  • Automobile Dealership · 9 ✖

Calendar Year 1

  • 2013 · 9 ✖
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)
38490 38490 2013 2671527 Manhattan Ford Lincoln MANHATTAN 787 11th Avenue Automobile Dealership 411845 3272.4 0.0   0.0   3272.4 0.0
39426 39426 2013 2707343 MBM, 514 11th Avenue MANHATTAN 514 11th Avenue Automobile Dealership 411153 0.0 0.0   0.0   0.0 0.0
42940 42940 2013 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE Automobile Dealership 65625 0.0 0.0   0.0   0.0 0.0
42941 42941 2013 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE Automobile Dealership 91256 0.0 0.0   0.0   0.0 0.0
43405 43405 2013 2848475 10170 - General Motors Worldwide QUEENS 39-10 43rd Street Automobile Dealership 89000 572.6 0.0   0.0   0.0 0.0
44120 44120 2013 3029926 MBM, 770 11th Ave MANHATTAN 770 11th Avenue Automobile Dealership 330000 0.0 0.0   0.0   0.0 0.0
44400 44400 2013 3104030 711 11 AVENUE MANHATTAN 711 11 AVENUE Automobile Dealership 115500 116.9 116.9   116.9   0.0 1.01
47238 47238 2013 3856170 GIRT Realty LLC MANHATTAN 547 West 47th Street Automobile Dealership 50207 763.0 0.0   0.0   763.0 0.0
47243 47243 2013 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue Automobile Dealership 75000 886.9 886.9   886.9   0.0 11.83

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