Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

75 rows where Borough = "QUEENS" and Property Type = "Courthouse" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Property Name, Address 1, Floor Area (ft2), Indoor Water Intensity (gal/ft2)

Calendar Year 12

Property Type 1

  • Courthouse · 75 ✖

Borough 1

  • QUEENS · 75 ✖
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)
327676 327676 2024 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 7834.3 7834.3 0.0 7834.3 0.0 0.0  
327678 327678 2024 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  
328529 328529 2024 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  
328531 328531 2024 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 2996.4 2996.4 0.0 2996.4 0.0 0.0  
328893 328893 2024 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 50.9 50.9 0.0 50.9 0.0 0.0  
330639 330639 2024 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  
330662 330662 2024 26672463 Benchmarking Group - 215 QUEENS 125-01 Queens Blvd Courthouse 1,162,654 3966.8 3966.8 0.0 3966.8 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  
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  
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  
266401 266401 2022 20986369 90-01 Beach Channel Drive QUEENS 90-01 Beach Channel Drive Courthouse 35,977 1262.3 1262.3 0.0 1262.3 0.0 0.0  
270022 270022 2022 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 4097.1 4097.1 0.0 4097.1 0.0 0.0  
270024 270024 2022 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  
271024 271024 2022 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  
271026 271026 2022 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 2636.3 2636.3 0.0 2636.3 0.0 0.0  
271401 271401 2022 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 2325.7 2325.7 0.0 2325.7 0.0 0.0  
271605 271605 2022 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  
271615 271615 2022 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  
222378 222378 2021 21354174 Benchmarking Group - 184 QUEENS 151-20 Jamaica Ave Courthouse 294,250 286.5 286.5 0.0 286.5 0.0 0.0  
222380 222380 2021 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  
223404 223404 2021 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  
223406 223406 2021 21355205 DCAS_1049_Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308,200 2770.2 2770.2 0.0 2770.2 0.0 0.0  
223795 223795 2021 21355595 DCAS_1047_Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 320,535 5538.6 5538.6 0.0 5538.6 0.0 0.0  
230044 230044 2021 20986369 90-01 Beach Channel Drive QUEENS 90-01 Beach Channel Drive Courthouse 35,977 1070.2 1070.2 0.0 1070.2 0.0 0.0  
190200 190200 2020 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65874 9830.2 9830.2 0.0 9830.2 0.0 0.0  
197906 197906 2020 6294311 DCAS - 4000698 - Long Island City Courthouse (LL84) QUEENS 25-10 Court Sq Courthouse 59300 0.0 0.0 0.0 0.0 0.0 0.0  
197907 197907 2020 6294315 DCAS - 4438731 - Queens Family Court (LL84) QUEENS 151-20 Jamaica Ave Courthouse 291589 1242.5 1242.5 0.0 1242.5 0.0 0.0  
197908 197908 2020 6294316 DCAS - 4207071 - Queens Supreme Court (LL84) QUEENS 88-11 Sutphin Blvd Courthouse 308200 2148.0 2148.0 0.0 2148.0 0.0 0.0  
208861 208861 2020 12344522 BBL 4-09653-0001: DCAS, DOC, DCAS (LL84) QUEENS 125-01 Queens Blvd Courthouse 1354487 0.0 0.0 0.0 0.0 0.0 0.0  
208954 208954 2020 12344666 BBL 4-09680-0001: DCAS, DEP (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 320535 1606.1 1606.1 0.0 1606.1 0.0 0.0  
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  
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  
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  
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  
136701 136701 2018 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  
145404 145404 2018 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  
145406 145406 2018 6294313 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court and Annex (LL84) QUEENS 125-01 Queens Blvd Courthouse 648,000 0.0 0.0 0.0 0.0 0.0 0.0  
145407 145407 2018 6294314 DCAS - 4448759 - Queens Civil Court (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 320,535 0.0 0.0 0.0 0.0 0.0 0.0  
145408 145408 2018 6294315 DCAS - 4438731 - Queens Family Court (LL84) QUEENS 151-02 Jamaica Ave Courthouse 291,589 0.0 0.0 0.0 0.0 0.0 0.0  
145409 145409 2018 6294316 DCAS - 4207071 - Queens Supreme Court (LL84) QUEENS 88-11 Sutphin Blvd Courthouse 308,200 0.0 0.0 0.0 0.0 0.0 0.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      
105550 105550 2017 6,294,314 DCAS - 4448759 - Queens Civil Court (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 230,035              
105795 105795 2017 6,294,311 DCAS - 4000698 - Long Island City Courthouse (LL84) QUEENS 25-10 Court Sq Courthouse 59,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              
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              
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      
84967 84967 2016 4,628,924 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  
84969 84969 2016 4,628,926 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court (LL84) QUEENS 125-01 Queens Blvd Courthouse 440,640 0.0 0.0 0.0 0.0 0.0 0.0  
84970 84970 2016 4,628,927 DCAS - 4448759 - Queens Civil Court (LL84) QUEENS 89-17 Sutphin Blvd Courthouse 230,035 0.0 0.0 0.0 0.0 0.0 0.0  
84971 84971 2016 4,628,928 DCAS - 4438731 - Queens Family Court (LL84) QUEENS 151-02 Jamaica Ave Courthouse 291,589 0.0 0.0 0.0 0.0 0.0 0.0  
84972 84972 2016 4,628,929 DCAS - 4207071 - Queens Supreme Court (LL84) QUEENS 88-11 Sutphin Blvd Courthouse 308,200 0.0 0.0 0.0 0.0 0.0 0.0  
85553 85553 2016 4,629,821 DCAS - 4458616 - Queens BH Campus: Queens Criminal Court (Annex) (LL84) QUEENS 125-01 Queens Blvd Courthouse 207,360 0.0 0.0 0.0 0.0 0.0 0.0  
87801 87801 2016 3,317,551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65,874 9052.2 9052.2 0.0 9052.2 0.0 0.0  
65338 65338 2015 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65874 10395.7 10395.7 0.0 10395.7 0.0 0.0 157.81
67713 67713 2015 4410169 57-13 49th Street, Queens QUEENS 57-13 49th Street, Queens Courthouse 74000 496.8 496.8 0.0 496.8 0.0 0.0 6.71
74509 74509 2015 4628924 DCAS - 4000698 - Long Island City Courthouse QUEENS 25-10 Court Sq Courthouse 59300 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74511 74511 2015 4628926 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court QUEENS 125-01 Queens Blvd Courthouse 440640 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74512 74512 2015 4628927 DCAS - 4448759 - Queens Civil Court QUEENS 89-17 Sutphin Blvd Courthouse 230035 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74513 74513 2015 4628928 DCAS - 4438731 - Queens Family Court QUEENS 151-02 Jamaica Ave Courthouse 291589 0.0 0.0 0.0 0.0 0.0 0.0 0.0
74514 74514 2015 4628929 DCAS - 4207071 - Queens Supreme Court QUEENS 88-11 Sutphin Blvd Courthouse 308200 0.0 0.0 0.0 0.0 0.0 0.0 0.0
75088 75088 2015 4629821 DCAS - 4206522 - Queens BH Campus: Queens Criminal Court (Annex) QUEENS 125-01 Queens Blvd Courthouse 207360 0.0 0.0 0.0 0.0 0.0 0.0 0.0
57564 57564 2014 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65874 9580.3 9580.3   9580.3     145.43
61703 61703 2014 4410169 57-13 49th Street, Queens QUEENS 57-13 49th Street, Queens Courthouse 74000 0.0 0.0   0.0     0.0
45727 45727 2013 3317551 Haven Manor Health Care Center QUEENS 1441 Gateway Boulevard Courthouse 65874 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");