Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

27 rows where Calendar Year = 2017 and Property Type = "Courthouse" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property ID, Property Name, Address 1, Floor Area (ft2), Total Water Use (kgal), Indoor Water Use (kgal), Municipal Indoor Water (kgal)

Borough 5

Property Type 1

  • Courthouse · 27 ✖

Calendar Year 1

  • 2017 · 27 ✖
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)
99754 99754 2017 2,678,635 330 Jay Street BROOKLYN 330 Jay Street Courthouse 1,100,000 10.0         10.0  
100284 100284 2017 4,410,169 57-13 49th Street, Queens QUEENS 57-13 49th Street, Queens Courthouse 74,000 631.2 631.2   631.2      
105273 105273 2017 6,294,297 DCAS - 1025397 - Midtown Community Court (LL84) MANHATTAN 314 West 54th St Courthouse 39,150              
105538 105538 2017 6,294,288 DCAS - 1054382 - Harlem Courthouse (LL84) MANHATTAN 170 East 121st St Courthouse 25,700              
105550 105550 2017 6,294,314 DCAS - 4448759 - Queens Civil Court (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 230,035              
105572 105572 2017 6,294,296 DCAS - 1085748 - Manhattan Supreme Court (LL84) MANHATTAN 60 Centre St Courthouse 322,300              
105573 105573 2017 6,294,302 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 388,800              
105794 105794 2017 6,294,294 DCAS - 1079000 - Manhattan CC Campus: Manhattan Criminal Court (LL84) MANHATTAN 100 Centre St Courthouse 795,700              
105795 105795 2017 6,294,311 DCAS - 4000698 - Long Island City Courthouse (LL84) QUEENS 25-10 Court Sq Courthouse 59,300              
105870 105870 2017 6,294,519 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 23,116              
105880 105880 2017 6,294,293 DCAS - 1001833 - Manhattan Civil Court (LL84) MANHATTAN 111 Centre St Courthouse 462,260              
106128 106128 2017 6,294,319 DCAS - 5000064 - Staten Island BH Campus: Staten Island Supreme Court (LL84) STATEN IS 18 Richmond Ter Courthouse 21,500              
106168 106168 2017 6,294,307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 621,817              
106169 106169 2017 6,294,320 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 16,194              
106455 106455 2017 6,294,260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500              
106501 106501 2017 6,297,379 DCAS - 5151735 - Richmond County Supreme Court (LL84) STATEN IS 26 Central Ave Courthouse 182,000              
106630 106630 2017 6,294,258 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000              
106645 106645 2017 6,294,292 DCAS - 1016743 - Manhattan Appellate Court (LL84) MANHATTAN 27 Madison Ave Courthouse 54,300              
106703 106703 2017 6,294,313 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court and Annex (LL84) QUEENS 125-01 Queens Blvd Courthouse 648,000              
106909 106909 2017 6,294,295 DCAS - 1001842 - Manhattan Family Court (LL84) MANHATTAN 60 Lafayette St Courthouse 481,000              
106910 106910 2017 6,294,301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,000              
107162 107162 2017 6,294,315 DCAS - 4438731 - Queens Family Court (LL84) QUEENS 151-02 Jamaica Ave Courthouse 291,589              
107163 107163 2017 6,294,316 DCAS - 4207071 - Queens Supreme Court (LL84) QUEENS 88-11 Sutphin Blvd Courthouse 308,200              
107173 107173 2017 6,294,321 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 10,400              
107276 107276 2017 6,294,261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100              
111666 111666 2017 3,317,551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65,874 8.0 8.0   8.0      
117747 117747 2017 3,317,551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65,874 8.0 8.0   8.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");