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

12 rows where Calendar Year = 2021 and Property Type = "Food Service" 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 5

  • QUEENS 6
  • BRONX 3
  • BROOKLYN 1
  • MANHATTAN 1
  • STATEN IS 1

Property Type 1

  • Food Service · 12 ✖

Calendar Year 1

  • 2021 · 12 ✖
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)
217114 217114 2021 8731564 HOBI: 2512 Arthur Kill Rd. STATEN IS 2512 Arthur Kill Road Food Service 50,418 0.0 0.0 0.0 0.0 0.0 0.0  
217353 217353 2021 11911006 Woodhaven: 96-01 Jamaica Ave QUEENS 96-01 Jamaica Ave Food Service 39,200 224.8 224.8 0.0 224.8 0.0 0.0  
222468 222468 2021 21354265 CIG > NYBG_714_NYBG: Garden Cafe & Terrace Room BRONX 2700 Dr. Theodore Kazimiroff Blvd Food Service 15,000 0.0 0.0 0.0 0.0 0.0 0.0  
222491 222491 2021 21354288 CIG > NYBG_737_NYBG: Leon Levy Visitor Center: Ticketing and Cafe BRONX 2900 Southern Blvd Food Service 6,112 0.0 0.0 0.0 0.0 0.0 0.0  
222596 222596 2021 21354394 DOC_9202_Rikers Island Bakery QUEENS 16-00 Hazen St Food Service 111,450 0.0 0.0 0.0 0.0 0.0 0.0  
222974 222974 2021 21354772 CUNY SC > QC_488_Queens College: Dining Hall QUEENS 64-36 Kissena Blvd Food Service 46,298 0.0 0.0 0.0 0.0 0.0 0.0  
222975 222975 2021 21354773 CUNY SC > QC_489_Queens College: Dining Hall Addition QUEENS 64-50 Kissena Blvd Food Service 42,675 0.0 0.0 0.0 0.0 0.0 0.0  
228362 228362 2021 16732046 5301 Grand Ave QUEENS 5301 Grand Ave Food Service 45,592 479.8 479.8 0.0 479.8 0.0 0.0  
233719 233719 2021 8721696 426 East 91st St MANHATTAN 426 East 91st St Food Service 26,349 737.9 737.9 0.0 737.9 0.0 0.0  
237906 237906 2021 13463290 Da Mikele Illagio QUEENS 79-17 Albion Avenue Food Service 45,742 0.0 0.0 0.0 0.0 0.0 0.0  
238432 238432 2021 13286432 Fresh Direct BRONX 2 Saint Ann's Avenue Food Service 640,000 0.0 0.0 0.0 0.0 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  

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