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

24 rows where Calendar Year = 2020 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)

Borough 4

  • QUEENS 10
  • BROOKLYN 7
  • MANHATTAN 6
  • BRONX 1

Property Type 1

  • Automobile Dealership · 24 ✖

Calendar Year 1

  • 2020 · 24 ✖
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)
188808 188808 2020 2820273 Potamkin Developement LLC MANHATTAN 2495 2nd Avenue Automobile Dealership 91256 0.0 0.0 0.0 0.0 0.0 0.0  
191019 191019 2020 3856672 11TH Avenue Automobile Realty LLC MANHATTAN 645 11th Avenue Automobile Dealership 75000 1414.7 1414.7 0.0 1414.7 0.0 0.0  
191790 191790 2020 4124879 Spectrum - Charter Communications MANHATTAN 2485 2nd Avenue Automobile Dealership 137456 259.8 259.8 0.0 259.8 0.0 0.0  
194349 194349 2020 5224698 50-30 Northern Blvd QUEENS 50-30 Northern Blvd Automobile Dealership 60485 0.0 0.0 0.0 0.0 0.0 0.0  
195242 195242 2020 5983666 Open Road Audi: 802 11th Ave MANHATTAN 802 11th Ave Automobile Dealership 243960 1051.0 1051.0 0.0 1051.0 0.0 0.0  
198997 198997 2020 6312752 235 W. 154th Street MANHATTAN 235 W. 154th Street Automobile Dealership 35522 0.0 0.0 0.0 0.0 0.0 0.0  
201345 201345 2020 6672452 Manhattan Motorcars MANHATTAN 711 11th. Avenue Automobile Dealership 135000 0.0 0.0 0.0 0.0 0.0 0.0  
201564 201564 2020 6678589 153-20 South Conduit Avenue QUEENS 15320 South Conduit Ave Automobile Dealership 59000 392.0 392.0 0.0 392.0 0.0 0.0  
202314 202314 2020 6694323 rydan BRONX 110 E 138th st Automobile Dealership 30284 0.0 0.0 0.0 0.0 0.0 0.0  
203883 203883 2020 6798925 36-11 Northern Blvd QUEENS 36-11 Northern Blvd Automobile Dealership 30000 0.0 0.0 0.0 0.0 0.0 0.0  
204069 204069 2020 6802619 Bayside: 212-19 Northern Blvd. QUEENS 212-19 Northern Blvd. Automobile Dealership 36581 255.7 255.7 0.0 255.7 0.0 0.0  
204637 204637 2020 6819514 BRAM - 40-40 Northern Boulevard QUEENS 40-40 Northern Boulevard Automobile Dealership 37610 571.5 571.5 0.0 571.5 0.0 0.0  
204638 204638 2020 6819515 BRAM - 6401 6th Avenue BROOKLYN 6401 6th Avenue Automobile Dealership 35350 0.0 0.0 0.0 0.0 0.0 0.0  
204639 204639 2020 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue Automobile Dealership 34746 651.9 651.9 0.0 651.9 0.0 0.0  
204759 204759 2020 6821854 MICHAEL NACLERIO QUEENS 92-12 172nd Street Automobile Dealership 25942 23160.1 0.0 0.0 0.0 0.0 23160.1  
205556 205556 2020 7468642 95-10 Ditmars Blvd QUEENS 2201 95 St Automobile Dealership 143934 7480.5 7480.5 0.0 7480.5 0.0 0.0  
206213 206213 2020 8718579 4814 Glenwood Rd BROOKLYN 4814 Glenwood Rd Automobile Dealership 34840 0.0 0.0 0.0 0.0 0.0 0.0  
208158 208158 2020 11591208 MMC Brooklyn BROOKLYN 2875 Flatbush Avenue Automobile Dealership 45696 0.0 0.0 0.0 0.0 0.0 0.0  
208173 208173 2020 11609549 2859 Flatbush Avenue BROOKLYN 2859 Flatbush Avenue Automobile Dealership 147187 163.8 163.8 0.0 163.8 0.0 0.0  
208574 208574 2020 12011923 105-20 Gerard Place QUEENS 105-20 Gerard Place Automobile Dealership 50000 0.0 0.0 0.0 0.0 0.0 0.0  
209306 209306 2020 12860567 30-35 College Point Blvd QUEENS 30-35 College Point Blvd Automobile Dealership 66728 684.5 684.5 0.0 684.5 0.0 0.0  
209725 209725 2020 14795887 1800 Shore Pkwy BROOKLYN 1800 Shore Pkwy Automobile Dealership 38000 1297.1 1297.1 0.0 1297.1 0.0 0.0  
210929 210929 2020 15596398 RED HOOK UNITED, LLC BROOKLYN 160 Van Brunt Street Automobile Dealership 68932 0.0 0.0 0.0 0.0 0.0 0.0  
211830 211830 2020 16861348 23-26 88th Street QUEENS 23-26 88th Street Automobile Dealership 47245 76.3 76.3 0.0 76.3 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 742.61ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability