Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

Data license: Public Domain · Data source: NYC Mayor's Office of Sustainability

20 rows where Calendar Year = 2011 and Property Type = "Education" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Borough 5

Property Type 1

  • Education · 20 ✖

Calendar Year 1

  • 2011 · 20 ✖
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)
10975 10975 2011 2704422 Vanderbilt Hall MANHATTAN 40 Washington Square South Education 257,259              
10978 10978 2011 2704501 Furman Hall MANHATTAN 245 Sullivan Street Education 168,566              
11006 11006 2011 2921365 10 Washington Mews MANHATTAN 10 Washington Mews Education 2,576              
11886 11886 2011 2601646 79 Fifth Avenue LLC MANHATTAN 79 Fifth Avenue Education 271,596              
12263 12263 2011 2636742 Gramercy M MANHATTAN 380 Second Avenue Education 191,492              
14205 14205 2011 1932457 Lycee Francais de New York MANHATTAN 503 E. 75th St Education 163,120              
15016 15016 2011 3106292 Armstrong MANHATTAN 545 West 112th street Education 59,072              
15095 15095 2011 2809987 McVickar MANHATTAN 622 West 113th Street Education 52,544              
15180 15180 2011 3117534 Studebaker MANHATTAN 615 West 131st Street Education 175,578              
15213 15213 2011 2777318 Barnard Mi   West 120th St Education 221,000              
15228 15228 2011 3111556 Knox Hall MANHATTAN 606 west 122nd Street Education 52,009              
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
19472 19472 2011 2973635 Yeshivah N BROOKLYN 1690 60th Street Education 72,000              
19473 19473 2011 2943912 Cong Machn BROOKLYN 6101 16th Ave Education 61,148              
20516 20516 2011 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247              
21534 21534 2011 1819837 Center for QUEENS 15-30 Petracca Place Education 92,705 10.0 10.0         114.89
22632 22632 2011 2978589 port richm STATEN IS 281 port richmond avenue Education 49,000              
22653 22653 2011 2818354 Moore Cath STATEN IS 100 Merrill Avenue Education 70,232              
22715 22715 2011 2813309 Monsignor STATEN IS 2900 Amboy Road Education 136,925              

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");