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

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

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

Property Type 1

  • Food Service · 8 ✖

Calendar Year 1

  • 2020 · 8 ✖
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)
197390 197390 2020 6283099 EASTWOOD MANOR BRONX 3371 EASTCHESTER ROAD Food Service 25490 1903.2 1903.2 0.0 1903.2 0.0 0.0  
199910 199910 2020 6457009 Maestro Caterers BRONX 1703 Bronxdale Ave Food Service 25845 2573.0 2573.0 0.0 2573.0 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  
206236 206236 2020 8721696 426 East 91st St MANHATTAN 426 East 91st St Food Service 26349 788.0 788.0 0.0 788.0 0.0 0.0  
206250 206250 2020 8731564 HOBI: 2512 Arthur Kill Rd. STATEN IS 2512 Arthur Kill Road Food Service 50418 0.0 0.0 0.0 0.0 0.0 0.0  
208426 208426 2020 11911006 Woodhaven: 96-01 Jamaica Ave QUEENS 96-01 Jamaica Ave Food Service 39200 0.0 0.0 0.0 0.0 0.0 0.0  
209470 209470 2020 13286432 Fresh Direct BRONX 2 Saint Ann's Avenue Food Service 640000 18452.6 18452.6 0.0 18452.6 0.0 0.0  
209490 209490 2020 13463290 Da Mikele Illagio QUEENS 79-17 Albion Avenue Food Service 45742 0.0 0.0 0.0 0.0 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 1644.503ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability