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

9 rows where Calendar Year = 2019 and Property Type = "Food Service" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 5

  • BRONX 4
  • BROOKLYN 1
  • MANHATTAN 1
  • QUEENS 1
  • STATEN IS 1

Property Type 1

  • Food Service · 9 ✖

Calendar Year 1

  • 2019 · 9 ✖
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)
166971 166971 2019 5849034 JAG Specialty Foods - Angonoa Brands   115-10 14th Rd Food Service 55,000 575.5 575.5 0.0 575.5 0.0 0.0  
169809 169809 2019 6283099 EASTWOOD MANOR BRONX 3371 EASTCHESTER ROAD Food Service 25,490 3145.1 3145.1 0.0 3145.1 0.0 0.0  
172632 172632 2019 6457009 Maestro Caterers BRONX 1703 Bronxdale Ave Food Service 25,845 4042.7 4042.7 0.0 4042.7 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  
179028 179028 2019 7356927 DANIA MARINA INC BRONX 2894 SCHURZ AVENUE Food Service 30,428 2742.5 2742.5 0.0 2742.5 0.0 0.0  
179985 179985 2019 8721696 426 East 91st St MANHATTAN 426 East 91st St Food Service 26,349 928.0 928.0 0.0 928.0 0.0 0.0  
180000 180000 2019 8731564 HOBI: 2512 Arthur Kill Rd. STATEN IS 2512 Arthur Kill Road Food Service 50,418 1581.4 1581.4 0.0 1581.4 0.0 0.0  
182623 182623 2019 11911006 Woodhaven: 96-01 Jamaica Ave QUEENS 96-01 Jamaica Ave Food Service 39,200 542.3 542.3 0.0 542.3 0.0 0.0  
183719 183719 2019 13286432 Fresh Direct BRONX 2 Saint Ann's Avenue Food Service 640,000 31471.5 31471.5 0.0 31471.5 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 717.842ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability