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

11 rows where Calendar Year = 2017 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)

Borough 3

  • BRONX 4
  • BROOKLYN 2
  • QUEENS 2

Property Type 1

  • Food Service · 11 ✖

Calendar Year 1

  • 2017 · 11 ✖
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)
94953 94953 2017 5,849,034 JAG Specialty Foods - Angonoa Brands   115-10 14th Rd Food Service 55,000 641.8 641.8   641.8      
94954 94954 2017 5,849,034 JAG Specialty Foods - Angonoa Brands   115-10 14th Rd Food Service 55,000 641.8 641.8   641.8      
97651 97651 2017 6,283,099 EASTWOOD MANOR BRONX 3371 EASTCHESTER ROAD Food Service 25,490              
107191 107191 2017 6,294,170 CUNY-S - 4467567 - QC Campus: Dining Hall Addition (LL84) QUEENS 64-50 Kissena Blvd Food Service 42,675              
107416 107416 2017 6,298,791 CUNY-S - 4467560 - QC Campus: Dining Hall (LL84) QUEENS 64-36 Kissena Blvd Food Service 46,298              
111055 111055 2017 6,283,099 EASTWOOD MANOR BRONX 3371 EASTCHESTER ROAD Food Service 25,490              
111056 111056 2017 6,457,009 Maestro Caterers BRONX 1703 Bronxdale Ave Food Service 32,680 3.0 3.0   3.0      
112089 112089 2017 6,457,009 Maestro Caterers BRONX 1703 Bronxdale Ave Food Service 320,680 3.0 3.0   3.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      
129110 129110 2017 5,849,034 JAG Specialty Foods - Angonoa Brands   115-10 14th Rd Food Service 55,000 641.8 641.8   641.8      

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