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

10 rows where Borough = "MANHATTAN" and Property Type = "Not Available" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Indoor Water Use (kgal), Outdoor Water Use (kgal)

Property Type 1

  • Not Available · 10 ✖

Calendar Year 1

  • 2012 10

Borough 1

  • MANHATTAN · 10 ✖
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)
26067 26067 2012 2683630 34th Street 14 MANHATTAN 312 WEST 34TH STREET Not Available 0   0.0 0.0        
26551 26551 2012 2706610 622 West 141 ST LLC. MANHATTAN 622 West 141 Street Not Available 0   0.0 0.0        
31740 31740 2012 2943128 Hilton Garden Inn Chelsea MANHATTAN 121 W. 28th st. Not Available 0   0.0 0.0        
34228 34228 2012 3274106 Brewster MANHATTAN 21 West 86th Street Not Available 0   0.0 0.0        
34604 34604 2012 3448031 Coltown: 301 West 130 Street MANHATTAN 301 West 130th Street Not Available 0   60132.5 0.0        
34733 34733 2012 3492395 360 Cabrini Blvd MANHATTAN 360 Cabrini Blvd Not Available 0   0.0 0.0        
35105 35105 2012 3524332 The Manhasset MANHATTAN 300 West 109th St Not Available 0   0.0 0.0        
35227 35227 2012 3528709 360 West 36th Street MANHATTAN 360 West 36th Street Not Available 0   0.0 0.0        
35229 35229 2012 3528745 136-140 Grand Street MANHATTAN 136-140 Grand Street Not Available 0   0.0 0.0        
35886 35886 2012 3544422 New York Manhattan 5th Ave Courtyard by Marriott MANHATTAN 3 E 40th Street Not Available 0   5534.4 5534.4        

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