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

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

Borough 2

  • MANHATTAN 7
  • QUEENS 2

Property Type 1

  • Automobile Dealership · 9 ✖

Calendar Year 1

  • 2014 · 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)
52252 52252 2014 2707343 MBM, 514 11th Avenue MANHATTAN 514 11th Avenue Automobile Dealership 411153 0.0 0.0   0.0     0.0
55204 55204 2014 2820270 706 MANHATTAN LLC MANHATTAN 706 11 AVENUE Automobile Dealership 65625 0.0 0.0   0.0     0.0
55205 55205 2014 2820273 Potamkin Developement LLC MANHATTAN 2495 2 AVENUE Automobile Dealership 91256 0.0 0.0   0.0     0.0
56272 56272 2014 3029926 MBM, 770 11th Ave MANHATTAN 770 11th Avenue Automobile Dealership 330000 0.0 0.0   0.0     0.0
58748 58748 2014 3789317 Major World CDJR, LLC QUEENS 50-30 northern blvd Automobile Dealership 60000 0.0 0.0   0.0     0.0
58779 58779 2014 3856170 GIRT Realty LLC MANHATTAN 547 West 47th Street Automobile Dealership 50207 755.4 0.0   0.0     0.0
58784 58784 2014 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue Automobile Dealership 75000 904.3 904.3   904.3     12.06
60147 60147 2014 4124879 POTAMKIN HY HOLDINGS LLC MANHATTAN 2485 2nd ave Automobile Dealership 137456 0.0 0.0   0.0     0.0
61817 61817 2014 4411921 Honda Showroom QUEENS 139-07 Hillside Avenue Automobile Dealership 47000 50334.8 50334.8   50334.8     1070.95

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 249.089ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability