Water — Use and Intensity

Total, indoor, outdoor, and municipal water use.

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

141 rows where Borough = "MANHATTAN" and Property Type = "Fire Station" sorted by Calendar Year descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Address 1

Calendar Year 10

Property Type 1

  • Fire Station · 141 ✖

Borough 1

  • MANHATTAN · 141 ✖
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)
327190 327190 2024 21353680 FDNY_3612_Engine Co. 80 and Ladder Co. 23 MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
328216 328216 2024 21354855 FDNY_4024_Eng39, Lad16, Pct19: Eng.Co.39, Ladd.Co.16 MANHATTAN 157 East 67th St Fire Station 12,960 0.0 0.0 0.0 0.0 0.0 0.0  
328599 328599 2024 21355277 FDNY_3613_Engine Co. 84 and Ladder Co. 34 MANHATTAN 513 West 161st St Fire Station 11,792 774.2 774.2 0.0 774.2 0.0 0.0  
328600 328600 2024 21355278 FDNY_3615_Engine Co. 91 MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
328601 328601 2024 21355279 FDNY_3616_Engine Co. 93, Ladder Co. 45 and Batt. 13 MANHATTAN 515 West 181st St Fire Station 21,883 493.3 493.3 0.0 493.3 0.0 0.0  
328603 328603 2024 21355281 FDNY_3621_Ladder Co. 20 and Medical and BFI Division MANHATTAN 251 Lafayette St Fire Station 28,866 184.8 184.8 0.0 184.8 0.0 0.0  
328604 328604 2024 21355282 FDNY_3622_Ladder Co. 25 and Division 3 MANHATTAN 205 West 77th St Fire Station 13,300 376.9 376.9 0.0 376.9 0.0 0.0  
328638 328638 2024 21355317 FDNY_4020_Engine Co. 33 & Ladder Co. 9 MANHATTAN 42 Great Jones St Fire Station 12,649 0.0 0.0 0.0 0.0 0.0 0.0  
328639 328639 2024 21355318 FDNY_4034_Engine Co. 58 and Ladder Co. 26 MANHATTAN 1367 5th Ave Fire Station 12,000 388.8 388.8 0.0 388.8 0.0 0.0  
328640 328640 2024 21355319 FDNY_4039_Engine Co. 69 and Ladder Co. 28, Batt. 16 MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
328641 328641 2024 21355320 FDNY_4040_Engine Co. 7 at Ladder Co. 1, Batt. 1 MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
328973 328973 2024 21355687 FDNY_4032_Engine Co. 54 and Ladder Co. 4, Batt. 9 MANHATTAN 782 8th Ave Fire Station 9,448 0.0 0.0 0.0 0.0 0.0 0.0  
330638 330638 2024 26656536 FDNY_4008_Engine Co. 1 and Ladder Co. 24 MANHATTAN 142 West 31st St Fire Station 11,326 0.0 0.0 0.0 0.0 0.0 0.0  
339581 339581 2024 57797892 FDNY_3626_Marine Co. 1 MANHATTAN 2 Bloomfield St Fire Station 15,000 0.0 0.0 0.0 0.0 0.0 0.0  
293608 293608 2023 21353680 FDNY_3612_Engine Co. 80 and Ladder Co. 23 MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
294783 294783 2023 21354855 FDNY_4024_Eng39, Lad16, Pct19: Eng.Co.39, Ladd.Co.16 MANHATTAN 157 East 67th St Fire Station 12,960 0.0 0.0 0.0 0.0 0.0 0.0  
295196 295196 2023 21355277 FDNY_3613_Engine Co. 84 and Ladder Co. 34 MANHATTAN 513 West 161st St Fire Station 11,792 998.9 998.9 0.0 998.9 0.0 0.0  
295197 295197 2023 21355278 FDNY_3615_Engine Co. 91 MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
295198 295198 2023 21355279 FDNY_3616_Engine Co. 93, Ladder Co. 45 and Batt. 13 MANHATTAN 515 West 181st St Fire Station 21,883 540.1 540.1 0.0 540.1 0.0 0.0  
295200 295200 2023 21355281 FDNY_3621_Ladder Co. 20 and Medical and BFI Division MANHATTAN 251 Lafayette St Fire Station 28,866 267.1 267.1 0.0 267.1 0.0 0.0  
295201 295201 2023 21355282 FDNY_3622_Ladder Co. 25 and Division 3 MANHATTAN 205 West 77th St Fire Station 13,300 458.7 458.7 0.0 458.7 0.0 0.0  
295235 295235 2023 21355317 FDNY_4020_Engine Co. 33 & Ladder Co. 9 MANHATTAN 42 Great Jones St Fire Station 12,649 357.1 357.1 0.0 357.1 0.0 0.0  
295236 295236 2023 21355318 FDNY_4034_Engine Co. 58 and Ladder Co. 26 MANHATTAN 1367 5th Ave Fire Station 12,000 413.0 413.0 0.0 413.0 0.0 0.0  
295237 295237 2023 21355319 FDNY_4039_Engine Co. 69 and Ladder Co. 28, Batt. 16 MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
295238 295238 2023 21355320 FDNY_4040_Engine Co. 7 at Ladder Co. 1, Batt. 1 MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
295596 295596 2023 21355687 FDNY_4032_Engine Co. 54 and Ladder Co. 4, Batt. 9 MANHATTAN 782 8th Ave Fire Station 9,448 0.0 0.0 0.0 0.0 0.0 0.0  
297837 297837 2023 26656536 FDNY_4008_Engine Co. 1 and Ladder Co. 24 MANHATTAN 142 West 31st St Fire Station 11,326 0.2 0.2 0.0 0.2 0.0 0.0  
269533 269533 2022 21353680 FDNY_3612_Engine Co. 80 and Ladder Co. 23 MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
270678 270678 2022 21354855 FDNY_4024_Eng39, Lad16, Pct19: Eng.Co.39, Ladd.Co.16 MANHATTAN 157 East 67th St Fire Station 12,960 0.0 0.0 0.0 0.0 0.0 0.0  
271096 271096 2022 21355277 FDNY_3613_Engine Co. 84 and Ladder Co. 34 MANHATTAN 513 West 161st St Fire Station 11,792 1232.0 1232.0 0.0 1232.0 0.0 0.0  
271097 271097 2022 21355278 FDNY_3615_Engine Co. 91 MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
271098 271098 2022 21355279 FDNY_3616_Engine Co. 93, Ladder Co. 45 and Batt. 13 MANHATTAN 515 West 181st St Fire Station 21,883 533.4 533.4 0.0 533.4 0.0 0.0  
271100 271100 2022 21355281 FDNY_3621_Ladder Co. 20 and Medical and BFI Division MANHATTAN 251 Lafayette St Fire Station 28,866 763.8 763.8 0.0 763.8 0.0 0.0  
271101 271101 2022 21355282 FDNY_3622_Ladder Co. 25 and Division 3 MANHATTAN 205 West 77th St Fire Station 13,300 252.9 252.9 0.0 252.9 0.0 0.0  
271135 271135 2022 21355317 FDNY_4020_Engine Co. 33 & Ladder Co. 9 MANHATTAN 42 Great Jones St Fire Station 12,649 427.8 427.8 0.0 427.8 0.0 0.0  
271136 271136 2022 21355318 FDNY_4034_Engine Co. 58 and Ladder Co. 26 MANHATTAN 1367 5th Ave Fire Station 12,000 348.4 348.4 0.0 348.4 0.0 0.0  
271137 271137 2022 21355319 FDNY_4039_Engine Co. 69 and Ladder Co. 28, Batt. 16 MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
271138 271138 2022 21355320 FDNY_4040_Engine Co. 7 at Ladder Co. 1, Batt. 1 MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
271490 271490 2022 21355687 FDNY_4032_Engine Co. 54 and Ladder Co. 4, Batt. 9 MANHATTAN 782 8th Ave Fire Station 9,448 0.0 0.0 0.0 0.0 0.0 0.0  
271604 271604 2022 26656536 FDNY_4008_Engine Co. 1 and Ladder Co. 24 MANHATTAN 142 West 31st St Fire Station 11,326 362.2 362.2 0.0 362.2 0.0 0.0  
221884 221884 2021 21353680 FDNY_3612_Engine Co. 80 and Ladder Co. 23 MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
223057 223057 2021 21354855 FDNY_4024_Eng39, Lad16, Pct19: Eng.Co.39, Ladd.Co.16 MANHATTAN 157 East 67th St Fire Station 12,960 0.0 0.0 0.0 0.0 0.0 0.0  
223477 223477 2021 21355277 FDNY_3613_Engine Co. 84 and Ladder Co. 34 MANHATTAN 513 West 161st St Fire Station 11,792 1050.3 1050.3 0.0 1050.3 0.0 0.0  
223478 223478 2021 21355278 FDNY_3615_Engine Co. 91 MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
223479 223479 2021 21355279 FDNY_3616_Engine Co. 93, Ladder Co. 45 and Batt. 13 MANHATTAN 515 West 181st St Fire Station 21,883 526.0 526.0 0.0 526.0 0.0 0.0  
223481 223481 2021 21355281 FDNY_3621_Ladder Co. 20 and Medical and BFI Division MANHATTAN 251 Lafayette St Fire Station 28,866 986.5 986.5 0.0 986.5 0.0 0.0  
223482 223482 2021 21355282 FDNY_3622_Ladder Co. 25 and Division 3 MANHATTAN 205 West 77th St Fire Station 13,300 53.0 53.0 0.0 53.0 0.0 0.0  
223516 223516 2021 21355316 FDNY_4019_Engine Co. 3 at Ladder Co. 12, Batt. 7 MANHATTAN 146 West 19th St Fire Station 17,586 2035.9 2035.9 0.0 2035.9 0.0 0.0  
223517 223517 2021 21355317 FDNY_4020_Engine Co. 33 & Ladder Co. 9 MANHATTAN 42 Great Jones St Fire Station 12,649 465.0 465.0 0.0 465.0 0.0 0.0  
223518 223518 2021 21355318 FDNY_4034_Engine Co. 58 and Ladder Co. 26 MANHATTAN 1367 5th Ave Fire Station 12,000 340.2 340.2 0.0 340.2 0.0 0.0  
223519 223519 2021 21355319 FDNY_4039_Engine Co. 69 and Ladder Co. 28, Batt. 16 MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
223520 223520 2021 21355320 FDNY_4040_Engine Co. 7 at Ladder Co. 1, Batt. 1 MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
223887 223887 2021 21355687 FDNY_4032_Engine Co. 54 and Ladder Co. 4, Batt. 9 MANHATTAN 782 8th Ave Fire Station 9,448 3003.8 3003.8 0.0 3003.8 0.0 0.0  
198000 198000 2020 6294460 FDNY - 1062872 - Engine Co. 84 and Ladder Co. 34 (LL84) MANHATTAN 513 West 161st St Fire Station 11792 866.3 866.3 0.0 866.3 0.0 0.0  
198001 198001 2020 6294462 FDNY - 1052473 - Engine Co. 91 (LL84) MANHATTAN 242 East 111th St Fire Station 12298 0.0 0.0 0.0 0.0 0.0 0.0  
198002 198002 2020 6294463 FDNY - 1075518 - Engine Co. 93, Ladder Co. 45 and Batt. 13 (LL84) MANHATTAN 515 West 181st St Fire Station 21883 602.2 602.2 0.0 602.2 0.0 0.0  
198004 198004 2020 6294466 FDNY - 1007523 - Ladder Co. 20 and Medical and BFI Division (LL84) MANHATTAN 251 Lafayette St Fire Station 28866 676.2 676.2 0.0 676.2 0.0 0.0  
198005 198005 2020 6294467 FDNY - 1030885 - Ladder Co. 25 and Division 3 (LL84) MANHATTAN 205 West 77th St Fire Station 13300 335.9 335.9 0.0 335.9 0.0 0.0  
198166 198166 2020 6296806 FDNY - 1015173 - Engine Co. 1 and Ladder Co. 24 (LL84) MANHATTAN 142 West 31st St Fire Station 11326 337.2 337.2 0.0 337.2 0.0 0.0  
198167 198167 2020 6296816 FDNY - 1014723 - Engine Co. 3 and Ladder Co. 12, Batt. 7 (LL84) (Leased) MANHATTAN 146 West 19th St Fire Station 17586 1923.8 1923.8 0.0 1923.8 0.0 0.0  
198168 198168 2020 6296817 FDNY - 1008526 - Engine Co. 33 and Ladder Co. 9 (LL84) MANHATTAN 42 Great Jones St Fire Station 12649 457.0 457.0 0.0 457.0 0.0 0.0  
198169 198169 2020 6296819 FDNY - 1054465 - Engine Co. 35 and Ladder Co. 14, Batt. 12 (LL84) MANHATTAN 2282 3rd Ave Fire Station 10900 0.0 0.0 0.0 0.0 0.0 0.0  
198170 198170 2020 6296820 FDNY - 1059547 - Engine Co. 37 and Ladder Co. 40 (LL84) MANHATTAN 415 West 125th St Fire Station 11778 0.0 0.0 0.0 0.0 0.0 0.0  
198172 198172 2020 6296828 FDNY - 1080501 - Engine Co. 58 and Ladder Co. 26 (LL84) MANHATTAN 1367 5th Ave Fire Station 12000 420.0 420.0 0.0 420.0 0.0 0.0  
198173 198173 2020 6296833 FDNY - 1075491 - Engine Co. 69 and Ladder Co. 28, Batt. 16 (LL84) MANHATTAN 248 West 143rd St Fire Station 11250 0.0 0.0 0.0 0.0 0.0 0.0  
198174 198174 2020 6296834 FDNY - 1001647 - Engine Co. 7 and Ladder Co. 1, Batt. 1 (LL84) MANHATTAN 100 Duane St Fire Station 19381 0.0 0.0 0.0 0.0 0.0 0.0  
170503 170503 2019 6294459 FDNY - 1075504 - Engine Co. 80 and Ladder Co. 23 (LL84) MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
170504 170504 2019 6294460 FDNY - 1062872 - Engine Co. 84 and Ladder Co. 34 (LL84) MANHATTAN 513 West 161st St Fire Station 11,792 9332.1 9332.1 0.0 9332.1 0.0 0.0  
170505 170505 2019 6294462 FDNY - 1052473 - Engine Co. 91 (LL84) MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
170506 170506 2019 6294463 FDNY - 1075518 - Engine Co. 93, Ladder Co. 45 and Batt. 13 (LL84) MANHATTAN 515 West 181st St Fire Station 21,883 4180.1 4180.1 0.0 4180.1 0.0 0.0  
170508 170508 2019 6294466 FDNY - 1007523 - Ladder Co. 20 and Medical and BFI Division (LL84) MANHATTAN 251 Lafayette St Fire Station 28,866 6039.7 6039.7 0.0 6039.7 0.0 0.0  
170509 170509 2019 6294467 FDNY - 1030885 - Ladder Co. 25 and Division 3 (LL84) MANHATTAN 205 West 77th St Fire Station 13,300 2467.7 2467.7 0.0 2467.7 0.0 0.0  
170701 170701 2019 6296806 FDNY - 1015173 - Engine Co. 1 and Ladder Co. 24 (LL84) MANHATTAN 142 West 31st St Fire Station 11,326 2478.7 2478.7 0.0 2478.7 0.0 0.0  
170702 170702 2019 6296816 FDNY - 1014723 - Engine Co. 3 at Ladder Co. 12, Batt. 7 (LL84) MANHATTAN 146 West 19th St Fire Station 17,586 12769.7 12769.7 0.0 12769.7 0.0 0.0  
170703 170703 2019 6296817 FDNY - 1008526 - Engine Co. 33 and Ladder Co. 9 (LL84) MANHATTAN 42 Great Jones St Fire Station 12,649 3584.1 3584.1 0.0 3584.1 0.0 0.0  
170704 170704 2019 6296819 FDNY - 1054465 - Engine Co. 35 and Ladder Co. 14, Batt. 12 (LL84) MANHATTAN 2282 3rd Ave Fire Station 10,900 0.0 0.0 0.0 0.0 0.0 0.0  
170705 170705 2019 6296820 FDNY - 1059547 - Engine Co. 37 and Ladder Co. 40 (LL84) MANHATTAN 415 West 125th St Fire Station 11,778 0.0 0.0 0.0 0.0 0.0 0.0  
170706 170706 2019 6296821 FDNY - c000001 - Eng.39, Lad.16, Pct.19 Campus (LL84) MANHATTAN 153 East 67th St Fire Station 37,286 21493.5 21493.5 0.0 21493.5 0.0 0.0  
170707 170707 2019 6296828 FDNY - 1080501 - Engine Co. 58 and Ladder Co. 26 (LL84) MANHATTAN 1367 5th Ave Fire Station 12,000 3256.2 3256.2 0.0 3256.2 0.0 0.0  
170708 170708 2019 6296833 FDNY - 1075491 - Engine Co. 69 and Ladder Co. 28, Batt. 16 (LL84) MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
170709 170709 2019 6296834 FDNY - 1001647 - Engine Co. 7 at Ladder Co. 1, Batt. 1 (LL84) MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
145535 145535 2018 6294459 FDNY - 1075504 - Engine Co. 80 and Ladder Co. 23 (LL84) MANHATTAN 503 West 139th St Fire Station 10,667 0.0 0.0 0.0 0.0 0.0 0.0  
145536 145536 2018 6294460 FDNY - 1062872 - Engine Co. 84 and Ladder Co. 34 (LL84) MANHATTAN 513 West 161st St Fire Station 11,792 0.0 0.0 0.0 0.0 0.0 0.0  
145537 145537 2018 6294462 FDNY - 1052473 - Engine Co. 91 (LL84) MANHATTAN 242 East 111th St Fire Station 12,298 0.0 0.0 0.0 0.0 0.0 0.0  
145538 145538 2018 6294463 FDNY - 1075518 - Engine Co. 93, Ladder Co. 45 and Batt. 13 (LL84) MANHATTAN 515 West 181st St Fire Station 21,883 0.0 0.0 0.0 0.0 0.0 0.0  
145540 145540 2018 6294466 FDNY - 1007523 - Ladder Co. 20 and Medical and BFI Division (LL84) MANHATTAN 251 Lafayette St Fire Station 28,866 0.0 0.0 0.0 0.0 0.0 0.0  
145541 145541 2018 6294467 FDNY - 1030885 - Ladder Co. 25 and Division 3 (LL84) MANHATTAN 205 West 77th St Fire Station 13,300 0.0 0.0 0.0 0.0 0.0 0.0  
145740 145740 2018 6296806 FDNY - 1015173 - Engine Co. 1 and Ladder Co. 24 (LL84) MANHATTAN 142 West 31st St Fire Station 11,326 0.0 0.0 0.0 0.0 0.0 0.0  
145741 145741 2018 6296816 FDNY - 1014723 - Engine Co. 3 at Ladder Co. 12, Batt. 7 (LL84) MANHATTAN 146 West 19th St Fire Station 17,586 0.0 0.0 0.0 0.0 0.0 0.0  
145742 145742 2018 6296817 FDNY - 1008526 - Engine Co. 33 and Ladder Co. 9 (LL84) MANHATTAN 42 Great Jones St Fire Station 12,649 0.0 0.0 0.0 0.0 0.0 0.0  
145743 145743 2018 6296819 FDNY - 1054465 - Engine Co. 35 and Ladder Co. 14, Batt. 12 (LL84) MANHATTAN 2282 3rd Ave Fire Station 10,900 0.0 0.0 0.0 0.0 0.0 0.0  
145744 145744 2018 6296820 FDNY - 1059547 - Engine Co. 37 and Ladder Co. 40 (LL84) MANHATTAN 415 West 125th St Fire Station 11,778 0.0 0.0 0.0 0.0 0.0 0.0  
145745 145745 2018 6296821 FDNY - 1072190 - Eng39, Lad16, Pct19 Campus: Eng.Co.39, Ladd.Co.16 (LL84) MANHATTAN 157 East 67th St Fire Station 12,960 0.0 0.0 0.0 0.0 0.0 0.0  
145746 145746 2018 6296828 FDNY - 1080501 - Engine Co. 58 and Ladder Co. 26 (LL84) MANHATTAN 1367 5th Ave Fire Station 12,000 0.0 0.0 0.0 0.0 0.0 0.0  
145747 145747 2018 6296833 FDNY - 1075491 - Engine Co. 69 and Ladder Co. 28, Batt. 16 (LL84) MANHATTAN 248 West 143rd St Fire Station 11,250 0.0 0.0 0.0 0.0 0.0 0.0  
145748 145748 2018 6296834 FDNY - 1001647 - Engine Co. 7 at Ladder Co. 1, Batt. 1 (LL84) MANHATTAN 100 Duane St Fire Station 19,381 0.0 0.0 0.0 0.0 0.0 0.0  
105254 105254 2017 6,294,463 FDNY - 1075518 - Engine Co. 93, Ladder Co. 45 and Batt. 13 (LL84) MANHATTAN 515 West 181st St Fire Station 21,883              
105255 105255 2017 6,294,467 FDNY - 1030885 - Ladder Co. 25 and Division 3 (LL84) MANHATTAN 205 West 77th St Fire Station 13,300              
105552 105552 2017 6,296,828 FDNY - 1080501 - Engine Co. 58 and Ladder Co. 26 (LL84) MANHATTAN 1367 5th Ave Fire Station 12,000              
105586 105586 2017 6,296,806 FDNY - 1015173 - Engine Co. 1 and Ladder Co. 24 (LL84) MANHATTAN 142 West 31st St Fire Station 11,326              

Next page

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");