Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

14 rows where Calendar Year = 2010 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 · 14 ✖

Calendar Year 1

  • 2010 · 14 ✖
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)
722 722 2010 1819837 Center for Automotive Education and Training QUEENS 15-30 Petracca Place Education                
1154 1154 2010 2549056 French Institute MANHATTAN 22 E 60th Street Education 69,561              
3249 3249 2010 2777318 Barnard Millbank   West 120th St Education 121,000              
3255 3255 2010 2777309 Barnard College MANHATTAN 3009 Broadway Education 623,875              
3257 3257 2010 2636736 Rose Hill BRONX 441 E Fordham Road Education 1,800,000              
4477 4477 2010 2680727 117 Adams Complex-Building 5 BROOKLYN 175 Pearl Street Education 190,121 2.0 2.0         12.33
4559 4559 2010 2601646 79 Fifth Avenue LLC MANHATTAN 79 Fifth Avenue Education 271,596              
8141 8141 2010 2636742 Gramercy Medical Arts Building MANHATTAN 380 Second Avenue Education 191,492              
9155 9155 2010 2797746 30-20 Thompson Avenue QUEENS 30-20 Thompson Avenue Education 609,247              
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              
10037 10037 2010 2814426 Good Shepherd School   608/620 Isham Street Education 65,472              
10038 10038 2010 2813309 Monsignor Farrell High School STATEN IS 2900 Amboy Road Education 136,925              
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");