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

9 rows where Borough = "BRONX" and Property Type = "Education" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Address 1, Indoor Water Use (kgal)

These facets timed out: Property Type

Calendar Year 3

  • 2010 4
  • 2012 3
  • 2011 2

Borough 1

  • BRONX · 9 ✖
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)
23639 23639 2012 2609513 Leo Engineering Building BRONX 3825 Corlear Avenue Education 161880   2321.8 0.0        
23644 23644 2012 2610158 Research and Learning Center BRONX 3840 Corlear Avenue Education 57000   0.0 0.0        
35430 35430 2012 3532549 Icahn Charter Schools BRONX 1500 Pelham Parkway South Education 107019   0.0 0.0        
17828 17828 2011 2610158 Research a BRONX 3840 Corlear Avenue Education 57,000              
17829 17829 2011 2609513 Leo Engine BRONX 3825 Corlear Avenue Education 161,880 2.0 2.0         15.02
3257 3257 2010 2636736 Rose Hill BRONX 441 E Fordham Road Education 1,800,000              
9566 9566 2010 2814906 T.E 755 Coop City Associates LLC BRONX 755 Coop City Boulevard Education 37,911              
10031 10031 2010 2814508 Cardinal Hayes High School BRONX 650 Grand Concourse Education 208,292              
10039 10039 2010 2815031 Saint Philip Neri School BRONX 3025 Grand Concourse Education 55,650              

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