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

6 rows where Calendar Year = 2020 and Property Type = "Data Center" 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), Municipal Mixed Water (kgal)

Borough 3

  • MANHATTAN 2
  • STATEN IS 2
  • QUEENS 1

Property Type 1

  • Data Center · 6 ✖

Calendar Year 1

  • 2020 · 6 ✖
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)
185051 185051 2020 2459564 NY3-011 Teleport A STATEN IS 10 Teleport Drive Data Center 133983 55313.3 0.0 0.0 0.0 0.0 55313.3  
185341 185341 2020 2614608 Western Union Building MANHATTAN 60 Hudson Street Data Center 1074536 21877.5 21877.5 0.0 21877.5 0.0 0.0  
186798 186798 2020 2694135 NYW-420 Teleport B STATEN IS 10A South Ave Data Center 66080 109.5 109.5 0.0 109.5 0.0 0.0  
202978 202978 2020 6732981 470 Nepperhan Avenue   470 Nepperhan Avenue Data Center 107600 0.0 0.0 0.0 0.0 0.0 0.0  
206537 206537 2020 9598540 33-16 Woodside Ave. QUEENS 33-16 Woodside Ave Data Center 34400 0.0 0.0 0.0 0.0 0.0 0.0  
207667 207667 2020 10827887 227 East 30th Street MANHATTAN 227 East 30th Street Data Center 202704 28757.5 28757.5 0.0 28757.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 1136.216ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability