Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

32 rows where Calendar Year = 2023 and Property Type = "Courthouse" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

Borough 5

Property Type 1

  • Courthouse · 32 ✖

Calendar Year 1

  • 2023 · 32 ✖
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)
276547 276547 2023 9776905 Brooklyn Family Court (330 Jay) BROOKLYN 330 Jay Street Courthouse 977,656 12231.2 12231.2 0.0 12231.2 0.0 0.0  
293252 293252 2023 20986369 90-01 Beach Channel Drive QUEENS 90-01 Beach Channel Drive Courthouse 35,977 0.0 0.0 0.0 0.0 0.0 0.0  
294129 294129 2023 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 5813.1 5813.1 0.0 5813.1 0.0 0.0  
294131 294131 2023 21354176 DCAS_1048_Queens Family Court QUEENS 151-20 Jamaica Ave Courthouse 291,589 0.0 0.0 0.0 0.0 0.0 0.0  
294178 294178 2023 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1595.9 1595.9 0.0 1595.9 0.0 0.0  
294179 294179 2023 21354224 DCAS_5571_Richmond County Supreme Court STATEN IS 26 Central Ave Courthouse 182,000 0.0 0.0 0.0 0.0 0.0 0.0  
294202 294202 2023 21354247 Benchmarking Group - 2 MANHATTAN 100 Centre St Courthouse 1,545,842 13270.1 13270.1 0.0 13270.1 0.0 0.0  
294203 294203 2023 21354248 DCAS_1025_Manhattan Criminal Court MANHATTAN 100 Centre St Courthouse 795,700 0.0 0.0 0.0 0.0 0.0 0.0  
294419 294419 2023 21354468 Benchmarking Group - 29 BROOKLYN 360 Adams St Courthouse 635,000 343.9 343.9 0.0 343.9 0.0 0.0  
294421 294421 2023 21354470 DCAS_1039_Brooklyn Supreme Court BROOKLYN 360 Adams St Courthouse 585,000 0.0 0.0 0.0 0.0 0.0 0.0  
294430 294430 2023 21354479 Benchmarking Group - 30 BROOKLYN 120 Schermerhorn St Courthouse 425,865 5723.3 5723.3 0.0 5723.3 0.0 0.0  
294431 294431 2023 21354480 DCAS_907_Brooklyn Criminal Court BROOKLYN 120 Schermerhorn St Courthouse 264,100 0.0 0.0 0.0 0.0 0.0 0.0  
294791 294791 2023 21354863 DCAS_1052_Staten Island Supreme Court STATEN IS 18 Richmond Ter Courthouse 63,200 0.0 0.0 0.0 0.0 0.0 0.0  
295101 295101 2023 21355180 DCAS_903_Bronx Housing Court BRONX 1118 Grand Concourse Courthouse 99,000 534.1 534.1 0.0 534.1 0.0 0.0  
295103 295103 2023 21355182 DCAS_905_Brooklyn Appellate Court BROOKLYN 45 Monroe Pl Courthouse 49,500 0.0 0.0 0.0 0.0 0.0 0.0  
295113 295113 2023 21355192 DCAS_1019_Harlem Courthouse MANHATTAN 170 East 121st St Courthouse 25,700 0.9 0.9 0.0 0.9 0.0 0.0  
295116 295116 2023 21355195 DCAS_1023_Manhattan Appellate Court MANHATTAN 27 Madison Ave Courthouse 54,300 2265.9 2265.9 0.0 2265.9 0.0 0.0  
295117 295117 2023 21355196 DCAS_1027_Manhattan Supreme Court MANHATTAN 60 Centre St Courthouse 322,300 0.0 0.0 0.0 0.0 0.0 0.0  
295118 295118 2023 21355197 DCAS_1028_Midtown Community Court MANHATTAN 314 West 54th St Courthouse 43,233 0.0 0.0 0.0 0.0 0.0 0.0  
295124 295124 2023 21355203 DCAS_1044_Long Island City Courthouse QUEENS 25-10 Court Sq Courthouse 59,300 0.0 0.0 0.0 0.0 0.0 0.0  
295126 295126 2023 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 2588.0 2588.0 0.0 2588.0 0.0 0.0  
295128 295128 2023 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 279.7 279.7 0.0 279.7 0.0 0.0  
295129 295129 2023 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 247.6 247.6 0.0 247.6 0.0 0.0  
295211 295211 2023 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 51.6 51.6 0.0 51.6 0.0 0.0  
295510 295510 2023 21355591 DCAS_1024_Manhattan Civil Court MANHATTAN 111 Centre St Courthouse 467,000 0.0 0.0 0.0 0.0 0.0 0.0  
295511 295511 2023 21355592 DCAS_1026_Manhattan Family Court MANHATTAN 60 Lafayette St Courthouse 491,000 1116.1 1116.1 0.0 1116.1 0.0 0.0  
295512 295512 2023 21355593 DCAS_1033_Bronx County Courthouse BRONX 851 Grand Concourse Courthouse 550,600 0.0 0.0 0.0 0.0 0.0 0.0  
295513 295513 2023 21355594 DCAS_1034_Bronx Family and Criminal Court BRONX 215 East 161st St Courthouse 490,000 0.0 0.0 0.0 0.0 0.0 0.0  
295514 295514 2023 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 2069.1 2069.1 0.0 2069.1 0.0 0.0  
297838 297838 2023 26656539 DCAS_1046_Queens Criminal Court and Annex QUEENS 125-01 Queens Blvd Courthouse 648,000 0.0 0.0 0.0 0.0 0.0 0.0  
297848 297848 2023 26672463 Benchmarking Group - 215 QUEENS 125-01 Queens Blvd Courthouse 1,162,654 0.0 0.0 0.0 0.0 0.0 0.0  
298077 298077 2023 29892141 141 Livingston Owner LLC BROOKLYN 141 Livingston Street Courthouse 193,195 0.0 0.0 0.0 0.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");