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

7 rows where Borough = "BRONX" and Property Type = "Not Available" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Floor Area (ft2), Indoor Water Use (kgal)

Property Type 1

  • Not Available · 7 ✖

Calendar Year 1

  • 2012 7

Borough 1

  • BRONX · 7 ✖
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)
34440 34440 2012 3338322 E&M 1750GRAND AVENUE BRONX 1750 GRAND AVENUE Not Available 0   4719.0 0.0        
34442 34442 2012 3338355 E&M 2675 CRESTON AVE BRONX 2675 CRESTON AVE. Not Available 0   0.0 0.0        
34452 34452 2012 3350391 E&M 667 E 232nd Street BRONX 667 E 232ND ST Not Available 0   6713.1 0.0        
34623 34623 2012 3452765 FMP: 2206 Holland Ave BRONX 2206 Holland Ave Not Available 0   6193.9 0.0        
35499 35499 2012 3535762 2986 Marion Avenue BRONX 2986 Marion Avenue Not Available 0   0.0 0.0        
35572 35572 2012 3537767 91 E 208th Street Bronx,-002 BRONX 91 E 208th Street Not Available 0   0.0 0.0        
36022 36022 2012 3582016 1011 Sheridan Ave. BRONX 1011 Sheridan Ave. Not Available 150498   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 48.165ms · Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability