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

13 rows where Borough = "QUEENS" and Property Type = "Storage/Shipping/Non-Refrigerated Warehouse" 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), Indoor Water Use (kgal)

Calendar Year 3

  • 2012 5
  • 2010 4
  • 2011 4

Property Type 1

  • Storage/Shipping/Non-Refrigerated Warehouse · 13 ✖

Borough 1

  • QUEENS · 13 ✖
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)
23234 23234 2012 2535105 Krinos Foods LLC QUEENS 4700 Northern Blvd Storage/Shipping/Non-Refrigerated Warehouse 126125   0.0 0.0        
24445 24445 2012 2653166 Fleet Garage QUEENS 18-00 119th st Storage/Shipping/Non-Refrigerated Warehouse 70000   0.0 0.0        
30586 30586 2012 2817429 RREEF 182 150TH RD QUEENS 182-30 150TH ROAD Storage/Shipping/Non-Refrigerated Warehouse 57600   0.0 0.0        
31744 31744 2012 2943943 5205 Flushing QUEENS 5205 Flushing Ave Storage/Shipping/Non-Refrigerated Warehouse 100000   410.4 0.0        
33409 33409 2012 3120426 Madelaine Chocolate QUEENS 316 Beach 96th st Storage/Shipping/Non-Refrigerated Warehouse 70246   0.0 0.0        
20417 20417 2011 2535105 Krinos Foo QUEENS 4700 Northern Blvd Storage/Shipping/Non-Refrigerated Warehouse 126,125              
21295 21295 2011 2943943 5205 Flush QUEENS 5205 Flushing Ave Storage/Shipping/Non-Refrigerated Warehouse 100,000              
22451 22451 2011 2817429 RREEF 182 150TH RD QUEENS 182-30 150TH ROAD Storage/Shipping/Non-Refrigerated Warehouse 57,600              
22535 22535 2011 3120426 Madelaine Chocolate QUEENS 316 Beach 96th st Storage/Shipping/Non-Refrigerated Warehouse 70,246              
3802 3802 2010 2653166 Fleet Garage QUEENS 18-00 119th st Storage/Shipping/Non-Refrigerated Warehouse 70,000 68.8 68.8         0.98
4487 4487 2010 2535105 Krinos Foods LLC QUEENS 4700 Northern Blvd Storage/Shipping/Non-Refrigerated Warehouse 126,125              
6901 6901 2010 2812391 Wyckoff QUEENS 1060 Wyckoff Ave Storage/Shipping/Non-Refrigerated Warehouse 72,929              
10006 10006 2010 2817429 RREEF 182 150TH RD QUEENS 182-30 150TH ROAD Storage/Shipping/Non-Refrigerated Warehouse 57,600              

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