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

13 rows where Calendar Year = 2018 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 3

  • MANHATTAN 6
  • QUEENS 4
  • BROOKLYN 3

Property Type 1

  • Automobile Dealership · 13 ✖

Calendar Year 1

  • 2018 · 13 ✖
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)
135127 135127 2018 2820270 706 Manhattan LLC MANHATTAN 706 11th Avenue Automobile Dealership 65,625 0.0 0.0 0.0 0.0 0.0 0.0  
135128 135128 2018 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue Automobile Dealership 91,256 0.0 0.0 0.0 0.0 0.0 0.0  
137605 137605 2018 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue Automobile Dealership 75,000 0.0 0.0 0.0 0.0 0.0 0.0  
138526 138526 2018 4124879 Potamkin Hy Holdings LLC MANHATTAN 2485 2nd Avenue Automobile Dealership 137,456 462.7 462.7 0.0 462.7 0.0 0.0  
141465 141465 2018 5224698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd Automobile Dealership 60,485 78.5 78.5 0.0 78.5 0.0 0.0  
146747 146747 2018 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street Automobile Dealership 35,522 0.0 0.0 0.0 0.0 0.0 0.0  
149521 149521 2018 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue Automobile Dealership 135,000 0.0 0.0 0.0 0.0 0.0 0.0  
152586 152586 2018 6798925 36-11 Northern Blvd QUEENS 36-11 Northern Blvd Automobile Dealership 30,000 171.6 171.6 0.0 171.6 0.0 0.0  
153556 153556 2018 6819514 BRAM - 40-40 Northern Boulevard QUEENS 40-40 Northern Boulevard Automobile Dealership 37,610 1206.6 1206.6 0.0 1206.6 0.0 0.0  
153557 153557 2018 6819515 BRAM - 6401 6th Avenue BROOKLYN 6401 6th Avenue Automobile Dealership 35,350 0.0 0.0 0.0 0.0 0.0 0.0  
153558 153558 2018 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue Automobile Dealership 34,746 1805.0 1805.0 0.0 1805.0 0.0 0.0  
153625 153625 2018 6820852 160 Van Brunt Street BROOKLYN 160 Van Brunt Street Automobile Dealership 68,932 0.0 0.0 0.0 0.0 0.0 0.0  
154608 154608 2018 7468642 95-10 Ditmars Blvd QUEENS 2201 95 St Automobile Dealership 143,934 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");
Powered by Datasette · Queries took 1547.036ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability