Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

53 rows where Borough = "STATEN IS" 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)

Calendar Year 10

Property Type 1

  • Courthouse · 53 ✖

Borough 1

  • STATEN IS · 53 ✖
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)
327707 327707 2024 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  
328224 328224 2024 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  
328533 328533 2024 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 222.9 222.9 0.0 222.9 0.0 0.0  
328534 328534 2024 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 294.0 294.0 0.0 294.0 0.0 0.0  
328614 328614 2024 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 637.1 637.1 0.0 637.1 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  
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  
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  
270071 270071 2022 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1573.0 1573.0 0.0 1573.0 0.0 0.0  
270072 270072 2022 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  
270686 270686 2022 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  
271028 271028 2022 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 199.5 199.5 0.0 199.5 0.0 0.0  
271029 271029 2022 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 149.6 149.6 0.0 149.6 0.0 0.0  
271111 271111 2022 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 51.4 51.4 0.0 51.4 0.0 0.0  
222427 222427 2021 21354223 Benchmarking Group - 193 STATEN IS 26 Central Ave Courthouse 182,000 1442.7 1442.7 0.0 1442.7 0.0 0.0  
222428 222428 2021 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  
223065 223065 2021 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  
223408 223408 2021 21355207 DCAS_1053_Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 18,000 156.2 156.2 0.0 156.2 0.0 0.0  
223409 223409 2021 21355208 DCAS_1055_Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 12,300 88.0 88.0 0.0 88.0 0.0 0.0  
223492 223492 2021 21355292 DCAS_3864_Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 21,500 26.9 26.9 0.0 26.9 0.0 0.0  
197911 197911 2020 6294319 DCAS - 5000064 - Staten Island BH Campus: Staten Island Supreme Court (LL84) STATEN IS 18 Richmond Ter Courthouse 63200 0.0 0.0 0.0 0.0 0.0 0.0  
197912 197912 2020 6294320 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 18000 139.9 139.9 0.0 139.9 0.0 0.0  
197913 197913 2020 6294321 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 12300 0.0 0.0 0.0 0.0 0.0 0.0  
198022 198022 2020 6294519 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 21500 22.4 22.4 0.0 22.4 0.0 0.0  
208966 208966 2020 12344680 BBL 5-00006-0021: DCAS, DOT (LL84) STATEN IS 26 Central Ave Courthouse 395126 0.0 0.0 0.0 0.0 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  
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  
145412 145412 2018 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  
145413 145413 2018 6294320 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 18,000 0.0 0.0 0.0 0.0 0.0 0.0  
145414 145414 2018 6294321 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 12,300 0.0 0.0 0.0 0.0 0.0 0.0  
145581 145581 2018 6294519 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 21,500 0.0 0.0 0.0 0.0 0.0 0.0  
146053 146053 2018 6297379 DCAS - 5151735 - Richmond County Supreme Court (LL84) STATEN IS 26 Central Ave Courthouse 182,000 0.0 0.0 0.0 0.0 0.0 0.0  
105870 105870 2017 6,294,519 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 23,116              
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              
106169 106169 2017 6,294,320 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 16,194              
106501 106501 2017 6,297,379 DCAS - 5151735 - Richmond County Supreme Court (LL84) STATEN IS 26 Central Ave Courthouse 182,000              
107173 107173 2017 6,294,321 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 10,400              
84975 84975 2016 4,628,932 DCAS - 5000064 - Staten Island BH Campus: Staten Island Supreme Court (LL84) STATEN IS 18 Richmond Ter Courthouse 21,500 0.0 0.0 0.0 0.0 0.0 0.0  
84976 84976 2016 4,628,933 DCAS - 5004530 - Staten Island Civil Court (LL84) STATEN IS 927 Castleton Ave Courthouse 16,194 0.0 0.0 0.0 0.0 0.0 0.0  
84977 84977 2016 4,628,934 DCAS - 5000090 - Staten Island Family Court (LL84) STATEN IS 100 Richmond Ter Courthouse 10,400 0.0 0.0 0.0 0.0 0.0 0.0  
85145 85145 2016 4,629,128 DCAS - 5014078 - Staten Island Criminal Court (LL84) STATEN IS 67 Targee St Courthouse 23,116 0.0 0.0 0.0 0.0 0.0 0.0  
85700 85700 2016 5,870,404 DCAS - 5151735 - Richmond County Supreme Court (LL84) STATEN IS 26 Central Ave Courthouse 184,000 0.0 0.0 0.0 0.0 0.0 0.0  
74517 74517 2015 4628932 DCAS - 5000064 - Staten Island BH Campus: Staten Island Supreme Court STATEN IS 18 Richmond Ter Courthouse 21500 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74518 74518 2015 4628933 DCAS - 5004530 - Staten Island Civil Court STATEN IS 927 Castleton Ave Courthouse 16194 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74519 74519 2015 4628934 DCAS - 5000090 - Staten Island Family Court STATEN IS 100 Richmond Ter Courthouse 10400 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74688 74688 2015 4629128 DCAS - 5014078 - Staten Island Criminal Court STATEN IS 67 Targee St Courthouse 23116 0.0 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");