Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

29 rows where Calendar Year = 2019 and Property Type = "Courthouse" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Borough 5

Property Type 1

  • Courthouse · 29 ✖

Calendar Year 1

  • 2019 · 29 ✖
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)
161962 161962 2019 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65,874 0.0 0.0 0.0 0.0 0.0 0.0  
170326 170326 2019 6294258 DCAS - 2101266 - Bronx Housing Court (LL84) BRONX 1118 Grand Concourse Courthouse 99,000 12853.3 12853.3 0.0 12853.3 0.0 0.0  
170328 170328 2019 6294260 DCAS - 3001881 - Brooklyn Appellate Court (LL84) BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
170329 170329 2019 6294261 DCAS - 3000534 - Brooklyn CC Campus: Brooklyn Criminal Court (LL84) BROOKLYN 120 Schermerhorn St Courthouse 264,100 56181.9 56181.9 0.0 56181.9 0.0 0.0  
170349 170349 2019 6294288 DCAS - 1054382 - Harlem Courthouse (LL84) MANHATTAN 170 East 121st St Courthouse 25,700 559595.7 559595.7 0.0 559595.7 0.0 0.0  
170352 170352 2019 6294292 DCAS - 1016743 - Manhattan Appellate Court (LL84) MANHATTAN 27 Madison Ave Courthouse 54,300 16009.1 16009.1 0.0 16009.1 0.0 0.0  
170353 170353 2019 6294293 DCAS - 1001833 - Manhattan Civil Court (LL84) MANHATTAN 111 Centre St Courthouse 467,000 117032.4 117032.4 0.0 117032.4 0.0 0.0  
170354 170354 2019 6294294 DCAS - 1079000 - Manhattan CC Campus: Manhattan Criminal Court (LL84) MANHATTAN 100 Centre St Courthouse 795,700 3124.2 3124.2 0.0 3124.2 0.0 0.0  
170355 170355 2019 6294295 DCAS - 1001842 - Manhattan Family Court (LL84) MANHATTAN 60 Lafayette St Courthouse 491,000 40827.0 40827.0 0.0 40827.0 0.0 0.0  
170356 170356 2019 6294296 DCAS - 1085748 - Manhattan Supreme Court (LL84) MANHATTAN 60 Centre St Courthouse 322,300 0.0 0.0 0.0 0.0 0.0 0.0  
170357 170357 2019 6294297 DCAS - 1025397 - Midtown Community Court (LL84) MANHATTAN 314 West 54th St Courthouse 43,233 1110.9 1110.9 0.0 1110.9 0.0 0.0  
170361 170361 2019 6294301 DCAS - 2002869 - Bronx County Courthouse (LL84) BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
170362 170362 2019 6294302 DCAS - 2002704 - Bronx Family and Criminal Court (LL84) BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
170365 170365 2019 6294307 DCAS - 3000257 - Brooklyn SC Campus: Brooklyn Supreme Court (LL84) BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
170367 170367 2019 6294311 DCAS - 4000698 - Long Island City Courthouse (LL84) QUEENS 25-10 Court Sq Courthouse 59,300 0.0 0.0 0.0 0.0 0.0 0.0  
170369 170369 2019 6294313 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court and Annex (LL84) QUEENS 125-01 Queens Blvd Courthouse 648,000 19042.6 19042.6 0.0 19042.6 0.0 0.0  
170370 170370 2019 6294314 DCAS - 4448759 - Queens Civil Court (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 320,535 23978.0 23978.0 0.0 23978.0 0.0 0.0  
170371 170371 2019 6294315 DCAS - 4438731 - Queens Family Court (LL84) QUEENS 151-20 Jamaica Ave Courthouse 291,589 36378.3 36378.3 0.0 36378.3 0.0 0.0  
170372 170372 2019 6294316 DCAS - 4207071 - Queens Supreme Court (LL84) QUEENS 88-11 Sutphin Blvd Courthouse 308,200 25865.3 25865.3 0.0 25865.3 0.0 0.0  
170375 170375 2019 6294319 DCAS - 5000064 - Staten Island BH Campus: Staten Island Supreme Court (LL84) STATEN IS 18 Richmond Ter Courthouse 63,200 0.0 0.0 0.0 0.0 0.0 0.0  
170376 170376 2019 6294320 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 18,000 2192.4 2192.4 0.0 2192.4 0.0 0.0  
170377 170377 2019 6294321 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 12,300 2112.4 2112.4 0.0 2112.4 0.0 0.0  
170550 170550 2019 6294519 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 21,500 1475.3 1475.3 0.0 1475.3 0.0 0.0  
171019 171019 2019 6297379 DCAS - 5151735 - Richmond County Supreme Court (LL84) STATEN IS 26 Central Ave Courthouse 182,000 6095.3 6095.3 0.0 6095.3 0.0 0.0  
183033 183033 2019 12344393 BBL 1-00167-0001: DCAS, DOC, NYPD (LL84) MANHATTAN 100 Centre St Courthouse 1,309,700 5142.4 5142.4 0.0 5142.4 0.0 0.0  
183124 183124 2019 12344522 BBL 4-09653-0001: DCAS, DOC, DCAS (LL84) QUEENS 125-01 Queens Blvd Courthouse 856,887 25181.1 25181.1 0.0 25181.1 0.0 0.0  
183138 183138 2019 12344539 BBL 2-02454-0001: DCAS, HRA, NYPD (LL84) BRONX 215 East 161st St Courthouse 497,440 0.0 0.0 0.0 0.0 0.0 0.0  
183217 183217 2019 12344666 BBL 4-09680-0001: DCAS, DEP (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 320,535 23978.0 23978.0 0.0 23978.0 0.0 0.0  
183229 183229 2019 12344680 BBL 5-00006-0021: DCAS, DOT (LL84) STATEN IS 26 Central Ave Courthouse 395,126 13233.0 13233.0 0.0 13233.0 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");