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

14 rows where Borough = "BROOKLYN" and Property Type = "Food Service" 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)

These facets timed out: Property Type

Calendar Year 8

  • 2024 6
  • 2017 2
  • 2018 1
  • 2019 1
  • 2020 1
  • 2021 1
  • 2022 1
  • 2023 1

Borough 1

  • BROOKLYN · 14 ✖
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)
336071 336071 2024 52961894 4C Warehouse #2 - 600 Fountain BROOKLYN 600 Fountain Ave Food Service 32,250 1055.5 1055.5 0.0 1055.5 0.0 0.0  
336073 336073 2024 52962392 4C Warehouse #3 - 852 Logan BROOKLYN 852 Logan Street Food Service 46,730 165.8 165.8 0.0 165.8 0.0 0.0  
338125 338125 2024 54765592 630 Flushing Building (2 Story)_(BIN#3329628)_630 Flushing Ave BROOKLYN 630 Flushing Avenue Food Service 5,268 0.0 0.0 0.0 0.0 0.0 0.0  
338126 338126 2024 54765593 Building: WH-A_632 Flushing Ave_(BIN#3338519)_630 Flushing Ave BROOKLYN 632 Flushing Avenue Food Service 98,171 0.0 0.0 0.0 0.0 0.0 0.0  
340119 340119 2024 58873392 47 Stewart Ave BROOKLYN 47 Stewart Ave Food Service 42,000 1581.4 1581.4 0.0 1581.4 0.0 0.0  
343477 343477 2024 64866992 4C Warehouses 2-3 BROOKLYN 600 Fountain Ave Food Service 78,980 1221.4 1221.4 0.0 1221.4 0.0 0.0  
305477 305477 2023 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 1500.0 1500.0 0.0 1500.0 0.0 0.0  
254813 254813 2022 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 2118.5 2118.5 0.0 2118.5 0.0 0.0  
240016 240016 2021 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 2498.1 2498.1 0.0 2498.1 0.0 0.0  
200390 200390 2020 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42000 2926.6 2926.6 0.0 2926.6 0.0 0.0  
173162 173162 2019 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 3102.7 3102.7 0.0 3102.7 0.0 0.0  
148366 148366 2018 6592380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 3031.3 3031.3 0.0 3031.3 0.0 0.0  
112182 112182 2017 6,592,380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 2.0 2.0   2.0      
112630 112630 2017 6,592,380 47 Stewart Avenue BROOKLYN 47 Stewart Avenue Food Service 42,000 2.0 2.0   2.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 436.912ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability