3/8/2022 2022-23 WATER DEPARTMENT CIP WORKSHEET - WATER CAPITAL FUND 1614 1 See Carryover 2021-22 2021-22 IFAS REQUEST
Line Note IFAS Funding From Budget Mid-Year ITD Y.T.D. Current Projected YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 5 YEAR No. PID [n] Key Project Title Type 2020-21 Request Revisions Expenditures Expenditures Encumbered Available 2022-23 2023-24 2024-25 2025-26 2026-27 TOTAL 1 Public Assistance (PA) Projects
2 2208 [1] 55769 Potable water pumps and Reservoirs - Cat F CONT $582,488 $0 $0 $1,188,52 1 $116,009 $88,233 $378,245 $1,400,000 $0 $0 $0 $0 $1,400,000 3 2316 55796 Reservoir 5 Recoating CO $1,398,106 $0 $0 $4,785 $2,89 1 $0 $1,395,215 $0 $0 $0 $0 $0 $0 4 2222 [1] 55766 Replace Water Services - Tubbs Fire (Inside Advisory Area CO $9,397 $0 $420,000 $3,443,189 $415,675 $6,099 $7,623 $0 $0 $0 $0 $0 $0 5 N/A 55792 Glass Fire Emergency Response - Water CO $2,044 $0 $0 $23,120 $165 $0 $1,880 $0 $0 $0 $0 $0 $0 6 N/A 55791 Water Quality Investigation - Glass Fire CO $1,889 $0 $0 $38,11 1 $0 $0 $1,889 $0 $0 $0 $0 $0 $0 7 2207 [1] 55771 Water Dept Metering - Citywide - Cat F CO $552,399 $0 ($543,123) $817,121 $8,646 $0 $629 $0 $0 $0 $0 $0 $0 8 PA Project Totals $2,546,323 $0 ($123,123) $5,514,848 $543,386 $94,333 $1,785,481 $1,400,000 $0 $0 $0 $0 $1,400,000 9 10
11 Hazard Mitigation Program (HMGP) Projects
12 2256 [2] 55772 Water Facility Generator Replacements - HMG CO $1,664,819 $2,970,000 $3,000,000 $626,994 $193,505 $700,700 $6,740,614 $0 $0 $0 $0 $0 $0 13 HMGP Project Totals $1,664,819 $2,970,000 $3,000,000 $626,994 $193,505 $700,700 $6,740,614 $0 $0 $0 $0 $0 $0 14 15
16 Master Planning/Studies/Miscellaneous
17 509 55574 Water Project Contingency CONT $3,173,354 $1,000,000 ($3,344,741) $0 $0 $0 $1,571,683 $742,700 $1,500,000 $1,500,000 $1,500,000 $1,500,000 $6,742,700 18 242 55420 Water Supply Planning CONT $107,422 $200,000 $0 $2,508,395 $108,463 $69,268 $129,69 1 $550,000 $150,000 $150,000 $150,000 $150,000 $1,150,000 19 2402 55498 Local Water Repairs - On Call Contracts CONT $201,146 $0 $271,192 $1,432,687 $428,832 $96,84 1 ($53,336) $291,000 $291,000 $291,000 $291,000 $291,000 $1,455,000 20 2362 55795 Water Tank Condition Assessment 202 1 CONT $180,000 $0 $0 $2,344 $2,344 $0 $177,656 $250,000 $0 $250,000 $0 $0 $500,000 21 1641 55511 Pre-Design, Planning, Budget, GIS Support - Water CONT $70,442 $60,000 $0 $1,822,807 $106,085 $15,540 $8,817 $190,000 $190,000 $190,000 $19 0,000 $36,389 $796,389 22 2174 55730 SC TPW Coordination - Various Locations CONT $74,475 $0 $0 $323,525 $0 $0 $74,475 $75,000 $0 $0 $0 $0 $75,000 23 292 55505 Warranty Punch List - Water CONT $9,819 $0 $0 $365,366 $30,338 $0 ($20,519) $25,000 $28,81 1 $69,000 $25,000 $30,000 $177,81 1 24 247 55527 Water Peak Reduction CONT $634,687 $0 $0 $5,703,935 $214,95 1 $0 $419,736 $0 $0 $300,000 $0 $0 $300,000 25 2291 55777 Water On-Call Engineering Services CONT $83,402 $0 $8,000 $61,016 $8,317 $74,109 $8,975 $0 $0 $200,000 $250,000 $0 $450,000 26 244 55495 Water Conservation Indoor Water Use Efficiency CONT $285,369 $0 $0 $1,721,085 $44,986 $25,746 $214,636 $0 $0 $0 $50,000 $0 $50,000 27 1765 55675 AMI/AMR Feasibility Study & Implementation CO $1,286,340 $0 $0 $7,637,714 $76,054 $1,196,534 $13,752 $0 $0 $0 $0 $0 $0 28 64 5537 1 Water Master Plan CO $375,168 $100,000 $0 $782,832 $0 $372,108 $103,06 1 $0 $0 $0 $0 $0 $0 29 2314 55784 Strategic Asset Management Plan - Water CO $2,016 $0 $0 $4,984 $0 $0 $2,016 $0 $0 $0 $0 $0 $0 30 2358 55793 Design-Build Water CO $35,587 $0 $60,000 $55,546 $31,133 $38,623 $25,83 1 $0 $0 $0 $0 $0 $0 31 2057 55740 Computer Maintenance Management System Replacement CO $338,273 $0 $0 $1,793,090 $115,816 $62,088 $160,370 $0 $0 $0 $0 $0 $0 32 2315 55785 Catastrophic Reserve Study - Water CO $22 $0 $0 $6,978 $0 $2 $20 $0 $0 $0 $0 $0 $0 33 1148 55562 Drought Response CO $112,745 $0 $50,000 $398,497 $85,756 $1,793 $75,196 $0 $0 $0 $0 $0 $0 34 2238 55774 Water System Reliability Study CO $218,729 $0 $0 $403,988 $12,717 $188,125 $17,887 $0 $0 $0 $0 $0 $0 35 Master Planning/Studies/Miscellaneous Totals $7,188,995 $1,360,000 ($2,955,549) $25,024,789 $1,265,792 $2,140,775 $2,929,948 $2,123,700 $2,159,811 $2,950,000 $2,456,000 $2,007,389 $11, 696,900 36 37
38 Water Mains and Services
39 2154 55623 WMR Sherwood Forest Neighborhood, Phase I CONT $0 $600,000 $0 $1,870 $1,870 $0 $598,130 $1,600,000 $0 $800,000 $4,150,000 $0 $6,550, 000 40 2210 55762 WMR Sonoma Ave and Montgomery Drive RCF NEW $0 $0 $0 $0 $0 $0 $0 $500,000 $1,300,000 $0 $0 $0 $1,800,000 41 2323 55788 WMR Terra Linda and Buena Vista NEW $0 $0 $0 $0 $0 $0 $0 $400,000 $1,000,000 $0 $0 $0 $1,400,000 42 166 5567 1 WSR Meyers Drive NEW $0 $0 $0 $0 $0 $0 $0 $70,000 $370,000 $0 $0 $0 $440,000 43 1903 55716 WMR Streamside to Elaine CONT $240,094 $0 $270,000 $23,350 $8,445 $0 $501,650 $70,000 $0 $0 $0 $0 $70,000 44 1999 55731 Cobblestone Dr Zone R2-R4 Water Main Connection CONT $870,362 $0 $0 $506,754 $52,117 $164,803 $653,442 $40,000 $0 $0 $0 $0 $40,000 45 472 55720 WMR Corby Ave - Barham to Baker NEW $0 $0 $0 $0 $0 $0 $0 $0 $400,000 $1,650,000 $0 $0 $2,050,000 46 477 55680 WMR Raegan Way and California Ave NEW $0 $0 $0 $0 $0 $0 $0 $0 $400,000 $1,500,000 $0 $0 $1,900,000 47 204 55586 WSR Salem Ave NEW $0 $0 $0 $0 $0 $0 $0 $0 $200,000 $650,000 $0 $0 $850,000 48 1904 55717 WMR Elaine Dr to Melita Rd CONT $9,874 $140,000 $0 $8,177 $7,870 $0 $142,003 $0 $100,000 $0 $0 $0 $100,000 49 2153 55754 WMR Corby Ave - Inglewood to Earle NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $950,000 $1,000,000 $0 $1,950,000 50 592 55594 WMR Carrington St NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $788,705 $2,250,000 $0 $3,038,705 51 240 55387 WMR Wright St - Silva to Carr NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $700,000 $750,000 $0 $1,450,000 52 2040 55734 WMR Palomino Dr and Sunny Manor Way NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $600,000 $1,000,000 $0 $1,600,000 53 2152 55760 WMR Corby Ave Colgan to Barham CONT $800,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,464,766 $1,500,000 $2,964,766 54 2211 55763 WMR Chanate Rd in Vicinity of RCF NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $750,000 $4,500,000 $5,250,000 55 234 55645 WMR College Ave - E to 4th NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $500,000 $1,600,000 $2,100,000 56 2410 55806 Oakmont Dr. WMR - Riven Rock to R12B NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $400,000 $2,679,000 $3,079,000 57 612 55592 WMR Apple Valley Lane NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $200,000 $700,000 $900,000 58 184 55630 WMR Grace Ave Area (Finlaw/James)- Phase 4 NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,000,000 $2,000,000 - P R O J E C T E D -
3/8/2022 2022-23 WATER DEPARTMENT CIP WORKSHEET - WATER CAPITAL FUND 1614 2 See Carryover 2021-22 2021-22 IFAS REQUEST
Line Note IFAS Funding From Budget Mid-Year ITD Y.T.D. Current Projected YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 5 YEAR No. PID [n] Key Project Title Type 2020-21 Request Revisions Expenditures Expenditures Encumbered Available 2022-23 2023-24 2024-25 2025-26 2026-27 TOTAL - P R O J E C T E D -
59 186 55625 WMR Grace and El Camino - Phase5 NEW $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $900,000 $900,000 60 2269 [1] 55787 Water Consolidation Project CONT $991,503 $0 $0 $20,110 $1,593 $0 $989,910 $0 $0 $0 $0 $0 $0 61 727 55696 WSR Stony Point Rd CO $15,886 $0 $0 $1,228,333 $0 $10,455 $5,43 1 $0 $0 $0 $0 $0 $0 62 158 55714 WMR Chanate at Mendocino CO $598,069 $0 $850,000 $1,238,972 $413,039 $911,544 $123,487 $0 $0 $0 $0 $0 $0 63 189 55633 WMR Lewrosa Way & Slater St CO $2,112,820 $0 ($512,911) $1,192,498 $1,015,318 $469,989 $114,602 $0 $0 $0 $0 $0 $0 64 2290 55783 WMR Rock Springs and Matanzas CO $3,889,995 $0 $0 $351,817 $131,81 1 $165,780 $3,592,403 $0 $0 $0 $0 $0 $0 65 2041 55800 WMR between 10th and Healdsburg CO $0 $0 $323,000 $5,386 $5,386 $0 $757,614 $0 $0 $0 $0 $0 $0 66 2263 55804 Calistoga Rd Water Main and Service Replacement CO $0 $0 $0 $0 $0 $0 $40,000 $0 $0 $0 $0 $0 $0 67 203 55628 WMR Albany/Malano/Clement CO $955,330 $1,300,000 $0 $80,264 $75,594 $120,339 $732,397 $0 $0 $0 $0 $0 $0 68 308 55694 WMR East Haven Dr - 4th to Eleanor- Phase 3 CO $153,693 $0 $0 $1,557,375 $1,068 $65,466 $7,159 $0 $0 $0 $0 $0 $0 69 1568 55669 WMR Augustan, El Camino, Grosse - Phase 2 CANC $5,94 1 $0 $0 $1,213,306 $0 $2,265 $3,676 $0 $0 $0 $0 $0 $0 70 1675 5564 1 WMR Montgomery - Mission to Jackson CO $436,633 $0 $0 $1,397,877 $51,119 $167,688 $7,826 $0 $0 $0 $0 $0 $0 71 1684 5568 1 WMR East Haven and Eleanor - Phase 6 CO $182,095 $1,520,000 $322,000 $77,459 $57,553 $37,977 $1,928,564 $0 $0 $0 $0 $0 $0 72 327 55736 WMR Terra Linda/Buena Vista/Miraloma CO $1,554,32 1 $1,400,000 ($2,566,551) $175,269 $29,590 $20,430 $1,664,749 $0 $0 $0 $0 $0 $0 73 661 55713 WSR Pacific Ave CO $1,117,185 $0 $0 $2,440,537 $967,722 $108,69 1 $40,772 $0 $0 $0 $0 $0 $0 74 Water Mains and Services Totals $13,933,801 $4,960,000 ($1,314,463) $11,519,353 $2,820,095 $2,245,428 $11,903,815 $2,680,000 $3,770,000 $7,638,705 $12,464,766 $13,879,000 $40,432,471 75 76
77 Groundwater Program
78 80 55523 Groundwater Supply Development CONT $3,132,265 $0 ($2,765,000) $11,169,382 $35,764 $143,365 $188,136 $100,000 $100,000 $100,000 $100,000 $100,000 $500,000 79 2361 55794 EGW Bennett Valley Golf Course CONT $500,000 $0 $0 $15,920 $15,920 $912 $483,168 $1,000,000 $1,000,000 $1,000,000 $0 $0 $3,000,000 80 2121 55758 Leete Well Rehab ilitation CONT $399,743 $500,000 $0 $56,196 $51,055 $359,392 $489,296 $500,000 $0 $0 $0 $0 $500,000 81 1997 55725 Carley & Peters Emergency Well Upgrades CONT $2,645,896 $0 ($530,000) $130,018 $63,860 $905,44 1 $1,146,595 $0 $1,200,000 $0 $0 $0 $1,200,000 82 2142 55747 Farmers Lane Treatment Plant Rehabilitation Phase 2 CONT $506,08 1 $0 $0 $295,034 $1,114 $164,147 $340,820 $0 $0 $500,000 $0 $0 $500,000 83 1839 5569 1 Farmers Lane Well and Treatment Plant Rehabilitation CO $317,597 $0 $0 $4,017,403 $0 $0 $317,597 $0 $0 $0 $0 $0 $0 84 2079 55745 Farmers Lane Well Pump Replacements CO $214,494 $0 ($205,000) $594,701 $2,911 $1,176 $5,408 $0 $0 $0 $0 $0 $0 85 1965 55710 Emergency Groundwater Well - A Place to Play CO $23,685 $0 $0 $122,469 $21,155 $2,647 ($117) $0 $0 $0 $0 $0 $0 86 1965 55709 Emergency Well Pump Station - A Place to Play CO $1,597,707 $0 $3,500,000 $1,845,684 $328,978 $3,014,638 $1,754,090 $0 $0 $0 $0 $0 $ 0 87 2083 55742 EGW Speers Well CO $1,322,725 $0 $0 $321,128 $53 $175,78 1 $1,146,891 $0 $0 $0 $0 $0 $0 88 2237 55773 EGW Hwy 12 CO $61,767 $0 $0 $138,233 $0 $0 $61,767 $0 $0 $0 $0 $0 $0 89 2083 5574 1 EGW Oakmont Well CO $933,715 $0 ($550,000) $55,138 $53 $175,78 1 $207,881 $0 $0 $0 $0 $0 $0 90 2398 55802 Freeway Well Abandonment CO $0 $0 $550,000 $0 $0 $0 $550,000 $0 $0 $0 $0 $0 $0 91 2204 5575 1 EGW Freeway Well CO $192,905 $0 $0 $902,072 $6,14 1 $13,661 $173,103 $0 $0 $0 $0 $0 $0 92 Groundwater Totals $11,848,580 $500,000 $0 $19,663,379 $527,005 $4,956,940 $6,864,635 $1,600,000 $2,300,000 $1,600,000 $100,000 $100,000 $5,700,000 93 94
95 Reservoirs
96 2212 55764 Seismic and Water Quality Upgrades - Reservoirs 9A, R16, R17 CONT $2,049,84 1 $4,000,000 $0 $384,335 $134,176 $780,949 $5,134,716 $5,500,000 $2,500,000 $0 $0 $0 $8,000,000 97 491 55606 R9C Analysis and Decommission CANC $105,470 $0 $0 $742,25 1 $0 $74,600 $5,870 $0 $0 $0 $0 $0 $0 98 568 55618 Seismic Upgrade - R3, R7, R12B CANC $453 $0 $0 $6,458,295 $496 $0 ($43) $0 $0 $0 $0 $0 $0 99 1801 55677 Road Access Stabilization Repairs for R7 CO $218,04 1 $0 $0 $2,989,112 $38,314 $215,973 ($36,245) $0 $0 $0 $0 $0 $0 100 1572 55647 R11 Permanent Electrical Power CO $90,247 $0 $0 $49,753 $0 $0 $90,247 $0 $0 $0 $0 $0 $0 101 2305 5578 1 Water Tanks Tree Removal CO $96,937 $0 $400,000 $34,809 $21,746 $0 $475,19 1 $0 $0 $0 $0 $0 $0 102 Reservoir Totals $2,560,990 $4,000,000 $400,000 $10,658,555 $194,732 $1,071,522 $5,669,736 $5,500,000 $2,500,000 $0 $0 $0 $8,000,000 103
104
105 Pump Stations and Facilities
106 2045 55732 Water Pump Station 10 High Flow Retrofit CONT $16,08 1 $0 $0 $8,919 $0 $0 $16,08 1 $900,000 $2,000,000 $0 $0 $0 $2,900,000 107 1986 55663 S14 Pump Station Upgrades - High Fire Severity Zone CONT $7,587 $0 $0 $109,413 $0 $0 $7,587 $0 $1,400,000 $0 $0 $0 $1,400,000 108 2351 55805 Fiber Optic Installation: Various Pump Stations and Reservoirs NEW $0 $0 $0 $0 $0 $0 $0 $0 $500,000 $0 $500,000 $0 $1,000,000 109 1713 55702 S13 Pump Station Upgrades - High Fire Severity Zone CONT $7,510 $0 $0 $86,490 $0 $0 $7,510 $0 $0 $1,650,000 $0 $0 $1,650,000 110 1907 55705 Booster Pump for Westerly Zone 9 CONT $0 $0 $0 $29,999 $0 $0 $0 $0 $0 $1,230,000 $0 $0 $1,230,000 111 2052 55678 WaterPLCReplBoosterStation CO $748,697 $0 $1,000,000 $458,075 $73,806 $132,036 $1,542,855 $0 $0 $0 $0 $0 $0 112 2052 55789 Radio Controller Upgrades CO $1,800,000 $0 ($1,000,000) $5,166 $5,166 $0 $794,834 $0 $0 $0 $0 $0 $0 113 2377 55799 Fiber Optic Installation – S7 to R7 CO $5,000 $0 $0 $579 $579 $0 $4,42 1 $0 $0 $0 $0 $0 $0 114 2150 55748 Station 3 Power Filter Installation and Stn 2 Gen Replacement CO $148,874 $0 $0 $611,180 $55 $18,354 $5,466 $0 $0 $0 $0 $0 $0 115 2327 55790 Fiber Optic Installation – S12 to R12 A CO $49,990 $0 $0 $63,990 $57,087 $90 ($7,187) $0 $0 $0 $0 $0 $0 116 2313 55782 Station 6&7 Soil & Groundwater Investigation CO $34,080 $0 $0 $37,630 $21,709 $0 $12,370 $0 $0 $0 $0 $0 $0 117 2374 55798 Station 4 Evaluation and Rehabilitation CO $0 $0 $270,000 $17,032 $17,032 $235,22 1 $17,747 $0 $0 $0 $0 $0 $0 118 2061 55761 Water Pump Station 1 Retaining Wall CO $394,245 $0 $0 $102,060 $46,305 $97,985 $249,956 $0 $0 $0 $0 $0 $0 119 1994 55735 Station 15 Upgrades CO $173,909 $0 $0 $1,236,574 $11,436 $168,312 ($5,839) $0 $0 $0 $0 $0 $0 120 Pump Station and Facility Totals $3,385,974 $0 $270,000 $2,767,106 $233,176 $651,997 $2,645,801 $900,000 $3,900,000 $2,880,000 $500,000 $0 $8,180,000 3/8/2022 2022-23 WATER DEPARTMENT CIP WORKSHEET - WATER CAPITAL FUND 1614 3 See Carryover 2021-22 2021-22 IFAS REQUEST
Line Note IFAS Funding From Budget Mid-Year ITD Y.T.D. Current Projected YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 5 YEAR No. PID [n] Key Project Title Type 2020-21 Request Revisions Expenditures Expenditures Encumbered Available 2022-23 2023-24 2024-25 2025-26 2026-27 TOTAL - P R O J E C T E D -
121 Grand Totals - Cash Funding $43,129,481 $13,790,000 $75,775,025 $5,777,691 $11,861,696 $38,540,030 $14,203,700 $14,629,811 $15,068,705 $15,520,766 $15,986,389 $75,409 ,371 Funding Type: Notes:
CANC = Project is expected to be completed by end of current fiscal year [1] This project is anticipated to be reimbursed at 100% with Prop 84 grant funding CO = Carryover project with no additional funding
CONT = Continue project with additional funding
NEW = New project with initial funding within five year plan Assumptions:
3% construction cost inflation per year