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

30 rows where Borough = "BROOKLYN" and Property Type = "Automobile Dealership" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Calendar Year 6

  • 2020 7
  • 2022 7
  • 2021 6
  • 2019 5
  • 2018 3
  • 2017 2

Property Type 1

  • Automobile Dealership · 30 ✖

Borough 1

  • BROOKLYN · 30 ✖
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)
256262 256262 2022 15596398 160 Van Brunt Street BROOKLYN 160 Van Brunt Street Automobile Dealership 68,932 1776.2 1776.2 0.0 1776.2 0.0 0.0  
257625 257625 2022 11591208 MMC Brooklyn BROOKLYN 2875 Flatbush Avenue Automobile Dealership 45,696 0.0 0.0 0.0 0.0 0.0 0.0  
265795 265795 2022 11609549 2859 Flatbush Avenue BROOKLYN 2859 Flatbush Avenue Automobile Dealership 147,187 215.4 215.4 0.0 215.4 0.0 0.0  
267363 267363 2022 6819515 BRAM - 6401 6th Avenue BROOKLYN 6401 6th Avenue Automobile Dealership 35,350 84.5 84.5 0.0 84.5 0.0 0.0  
267364 267364 2022 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue Automobile Dealership 34,746 461.2 461.2 0.0 461.2 0.0 0.0  
267390 267390 2022 8718579 4814 Glenwood Rd BROOKLYN 4814 Glenwood Rd Automobile Dealership 34,840 0.0 0.0 0.0 0.0 0.0 0.0  
267435 267435 2022 14795887 1800 Shore Pkwy BROOKLYN 1800 Shore Pkwy Automobile Dealership 38,000 1128.1 1128.1 0.0 1128.1 0.0 0.0  
230172 230172 2021 11609549 2859 Flatbush Avenue BROOKLYN 2859 Flatbush Avenue Automobile Dealership 147,187 169.1 169.1 0.0 169.1 0.0 0.0  
238725 238725 2021 6819515 BRAM - 6401 6th Avenue BROOKLYN 6401 6th Avenue Automobile Dealership 35,350 101.9 101.9 0.0 101.9 0.0 0.0  
239419 239419 2021 15596398 RED HOOK UNITED, LLC BROOKLYN 160 Van Brunt Street Automobile Dealership 68,932 1286.9 1286.9 0.0 1286.9 0.0 0.0  
241277 241277 2021 8718579 4814 Glenwood Rd BROOKLYN 4814 Glenwood Rd Automobile Dealership 34,840 0.0 0.0 0.0 0.0 0.0 0.0  
241293 241293 2021 14795887 1800 Shore Pkwy BROOKLYN 1800 Shore Pkwy Automobile Dealership 38,000 1668.2 1668.2 0.0 1668.2 0.0 0.0  
241542 241542 2021 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue Automobile Dealership 34,746 538.5 538.5 0.0 538.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  
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  
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  
178119 178119 2019 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  
178120 178120 2019 6819516 BRAM - 6502 5th Avenue BROOKLYN 6502 5th Avenue Automobile Dealership 34,746 1396.6 1396.6 0.0 1396.6 0.0 0.0  
179960 179960 2019 8718579 4814 Glenwood Rd BROOKLYN 4814 Glenwood Rd Automobile Dealership 34,840 0.0 0.0 0.0 0.0 0.0 0.0  
182320 182320 2019 11591208 MMC Brooklyn BROOKLYN 2875 Flatbush Avenue Automobile Dealership 45,696 0.0 0.0 0.0 0.0 0.0 0.0  
182339 182339 2019 11609549 2859 Flatbush Avenue BROOKLYN 2859 Flatbush Avenue Automobile Dealership 147,187 172.8 172.8 0.0 172.8 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  
98039 98039 2017 6,301,536 MBB AUTO BROOKLYN 1800 SHORE PARKWAY Automobile Dealership 43,000              
99229 99229 2017 6,301,536 MBB AUTO BROOKLYN 1800 SHORE PARKWAY Automobile Dealership 43,000 1.0 1.0   1.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 217.08ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability