Loading...
HomeMy WebLinkAbout2022-06-14; City Council; Resolution 2022-135RESOLUTION NO. 2022-135 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF CARLSBAD, CALIFORNIA, ADOPTING THE FINAL OPERATING BUDGET, STRATEGIC DIGITAL TRANSFORMATION INVESTMENT PROGRAM AND CAPITAL IMPROVEMENT PROGRAM FOR FISCAL YEAR 2022-23 FOR THE CITY OF CARLSBAD AND ESTABLISHING CONTROLS ON CHANGES IN APPROPRIATIONS FOR BUDGET FUNDS EXHIBIT 4 WHEREAS, the City Council of the City of Carlsbad, California, has reviewed the proposed final Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program for fiscal year (FY) 2022-23 and has held such public hearings as are necessary prior to adoption of the final budgets. NOW, THEREFORE, BE IT RESOLVED by the City Council of the City of Carlsbad, California, as follows: 1.That the above recitations are true and correct. 2.That certain documents now on file in the Office of the City Clerk of the City of Carlsbad, entitled "Fiscal Year 2022-23 Preliminary Operating Budget," presented at the Joint Special Meeting on May 24, 2022 as Exhibit 1 to Item No. 8, as amended, if necessary, and "Strategic Digital Transformation Investment Program and Capital Improvement Program," presented at the Joint Special Meeting on June 7, 2022 as Exhibits 3 and 4 to Item No. 13, as amended, if necessary, in accordance with Attachments A-A3, B-B2, C and D to this Exhibit 4, attached and incorporated by reference, are adopted as the final Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program for the City of Carlsbad for FY 2022-23 along with the program options and adjustments, if any, determined by the City Council as set forth in the minutes of this Joint Special Meeting on June 14, 2022. 3.That the amounts reflected as estimated revenues for FY 2022-23 as shown in Attachments A-A3, B-B2 and D are adopted as the budgeted revenues for FY 2022-23. 4. That the amounts as designated as the FY 2022-23 Budget request in Attachments A-A3, B-B2 and D are appropriated to the department or fund for which they are designated, and such appropriation shall not be increased except as provided in this resolution. June 14, 2022 Item #7 Page 139 of 454 5.That total appropriations for each fund may only be increased or decreased by the City Council by passage of a resolution amending the budget except as provided in this resolution. 6.That the following controls are placed on the use and transfer of budget funds: A.No expenditure of funds shall be authorized unless sufficient funds have been appropriated by the City Council or City Manager as described below. i.The City Manager may authorize all transfers of funds from account to account within any department. ii.The City Manager may authorize transfers of funds between Information Technology and departments citywide as it relates to the reorganization of staff within the business systems specialist series. iii.The City Manager may authorize transfers of funds between departments within the same fund in an amount up to $100,000 per transfer. iv.The City Manager may authorize budget adjustments involving offsetting revenues and expenditures; the City Manager may authorize increases in an appropriation for a specific purpose where the appropriation is offset by unbudgeted revenue, which is designated for said specific purpose. v.The City Manager may authorize budget adjustments to increase the appropriation for the Workers' Compensation and Risk Management Funds' operating budgets in an amount equal to the increases in costs of claims expenses or estimated losses and liabilities. vi.The City Manager may authorize budget adjustments to increase the appropriation for unforeseen legal expenses and liabilities. vii.The City Manager may authorize budget adjustments to increase the appropriation for Mutual Aid expenses in an amount equal to the increases in amounts to be reimbursed by other agencies. viii.The City Council must authorize all transfers of funds from the City Council's Contingency Account. ix.The City Manager may delegate any of the authority given to the City Manager under this resolution. June 14, 2022 Item #7 Page 140 of 454 B.The City Council must authorize any increase in the number of authorized permanent personnel positions above the level identified in Attachment C. C.The City Manager may authorize the hiring of temporary or part-time staff as necessary within the limits imposed by the controls listed above. 7.That the legal level of budgetary control is the fund level. Budgets may not legally be exceeded at the fund level without appropriate authorization by the City Council. 8.That interest earned on grants may be appropriated during the year for the purpose for which the grant was received. 9.That all appropriations in the Capital Improvement Program remaining unexpended at June 30, 2022, are appropriated to FY 2022-23 in their respective project budgets. 10.That all appropriations in the Strategic Digital Transformation Investment Program remaining unexpended at June 30, 2022, are appropriated to FY 2022-23 in their respective project budgets. 11.That all appropriations in the Operating Budget remaining unexpended at June 30, 2022 related to developer deposits received for developer-funded studies not yet completed or grant awards received or expected for projects that are continuing into the next fiscal year are appropriated to FY 2022-23. 12.That all appropriations for outstanding encumbrances as of June 30, 2022, are continued into FY 2022-23 for such contracts or obligations. June 14, 2022 Item #7 Page 141 of 454 PASSED, APPROVED AND ADOPTED at a Joint Special Meeting of the City Council of the City of Carlsbad, the Board of Directors of the Carlsbad Municipal Water District, the Board of Directors of the Carlsbad Public Financing Authority, the City of Carlsbad Community Development Commission, and the City Council of the City of Carlsbad as Successor Agency to the Carlsbad Redevelopment Agency held on the 14th day of June, 2022, by the following vote, to wit: AYES: NAYS: ABSENT: Blackburn, Bhat-Patel, Acosta, Norby. None. Hall. MATT HALL, Mayor ¥FAVIOLA MEDINA, City Clerk Services Manager {SEAL} June 14, 2022 Item #7 Page 142 of 454 Attachment A SCHEDULE OF PROJECTED FUND BALANCES Projected Beginning Ending Fund Balance Estimated Estimated Fund Balance Fund July 1, 2021 Revenues Expenditures June 30, 2022 General Fund 110,998,762$ *204,922,372$ 200,223,160$ 115,697,974$ * Special Revenue Funds Affordable Housing 16,702,385 1,815,000 200,000 18,317,385 Agricultural Mitigation Fee 1,025,623 223,100 - 1,248,723 Buena Vista Channel Maintenance District 1,502,960 115,000 106,500 1,511,460 Citizens' Option for Public Safety 304,670 186,034 266,106 224,598 Community Activity Grants 1,125,132 12,000 15,000 1,122,132 Community Development Block Grant 266,637 1,492,368 1,548,299 210,706 Cultural Arts Donations 338,366 51,826 82,491 307,701 Habitat Mitigation Fee - 65,100 - 65,100 Library and Arts Endowments 270,832 2,800 6,000 267,632 Library Gifts and Bequests 1,654,623 200,816 216,363 1,639,076 Lighting and Landscaping District 2 4,615,763 687,680 398,124 4,905,319 Local Cable Infrastructure 941,429 288,600 467,962 762,067 Median Maintenance District 84,768 1,315,000 1,160,000 239,768 Parking In Lieu Fee 1,200,349 12,000 49,675 1,162,674 Police Asset Forfeiture 259,469 918 20,000 240,387 Public Safety Grants - 196,696 196,696 - Recreation Donations 292,508 28,234 45,782 274,960 Rental Assistance 235,713 9,682,700 9,597,000 321,413 Senior Donations 336,216 14,037 19,000 331,253 Street Lighting Maintenance District 2,862,534 927,000 849,000 2,940,534 Street Tree Maintenance District 159,543 910,000 950,000 119,543 Tyler Court Apartments 330,598 641,000 485,000 486,598 Total Special Revenue Funds 34,510,118 18,867,909 16,678,998 36,699,029 Enterprise Funds Water Operations 30,390,857 47,723,538 51,321,219 26,793,176 Recycled Water Operations 5,652,330 8,537,611 11,403,789 2,786,152 Wastewater Operations 8,184,603 15,526,500 16,057,474 7,653,629 Solid Waste Management 11,991,468 4,084,447 4,017,239 12,058,676 Golf Course 2,119,080 8,957,000 7,306,826 3,769,254 Total Enterprise Funds 58,338,338 84,829,096 90,106,547 53,060,887 Internal Service Funds Workers' Compensation 5,935,084 4,891,730 4,246,463 6,580,351 Risk Management 2,668,730 3,392,080 3,740,520 2,320,290 Vehicle Maintenance 1,026,378 3,356,062 3,510,000 872,440 Vehicle Replacement 19,141,279 3,999,451 4,540,000 18,600,730 Information Technology 8,320,615 14,858,482 13,892,500 9,286,597 Total Internal Service Funds 37,092,086 30,497,805 29,929,483 37,660,408 Successor Agency Housing Trust Fund 1,431,269 1,067,000 1,038,500 1,459,769 Total Operating Funds 242,370,573$ 340,184,182$ 337,976,688$ 244,578,067$ * For the General Fund only, this represents unassigned fund balance. June 14, 2022 Item #7 Page 143 of 454 Attachment A Projected Beginning Ending Fund Balance Estimated Adopted Fund Balance Fund June 30, 2022 Revenues Budget June 30, 2023 General Fund 115,697,974$ *198,764,175$ 198,445,022$ 116,017,127$ * Special Revenue Funds Affordable Housing 18,317,385 495,000 393,385 18,419,000 Agricultural Mitigation Fee 1,248,723 15,000 - 1,263,723 Buena Vista Channel Maintenance District 1,511,460 116,000 195,245 1,432,215 Citizens' Option for Public Safety 224,598 201,000 265,705 159,893 Community Activity Grants 1,122,132 13,500 30,000 1,105,632 Community Development Block Grant 210,706 527,154 636,728 101,132 Cultural Arts Donations 307,701 25,500 131,750 201,451 Habitat Mitigation Fee 65,100 - - 65,100 Library and Arts Endowments 267,632 - 6,000 261,632 Library Gifts and Bequests 1,639,076 264,900 394,467 1,509,509 Lighting and Landscaping District 2 4,905,319 730,000 338,070 5,297,249 Local Cable Infrastructure 762,067 260,000 395,006 627,061 Median Maintenance District 239,768 1,315,000 1,329,900 224,868 Parking In Lieu Fee 1,162,674 15,000 53,000 1,124,674 Police Asset Forfeiture 240,387 - 125,000 115,387 Public Safety Grants - - - - Recreation Donations 274,960 31,539 81,009 225,490 Rental Assistance 321,413 11,403,180 10,409,089 1,315,504 Senior Donations 331,253 16,000 50,500 296,753 Street Lighting Maintenance District 2,940,534 920,000 1,065,393 2,795,141 Street Tree Maintenance District 119,543 920,000 880,235 159,308 Tyler Court Apartments 486,598 648,637 540,716 594,519 Total Special Revenue Funds 36,699,029 17,917,410 17,321,198 37,295,241 Enterprise Funds Water Operations 26,793,176 46,990,138 49,715,832 24,067,482 Recycled Water Operations 2,786,152 8,730,496 11,206,521 310,127 Wastewater Operations 7,653,629 19,276,500 16,999,568 9,930,561 Solid Waste Management 12,058,676 4,999,230 5,801,402 11,256,504 Golf Course 3,769,254 9,574,000 9,195,000 4,148,254 Total Enterprise Funds 53,060,887 89,570,364 92,918,323 49,712,928 Internal Service Funds Workers' Compensation 6,580,351 5,314,620 4,507,014 7,387,957 Risk Management 2,320,290 3,993,370 3,780,570 2,533,090 Vehicle Maintenance 872,440 3,297,355 3,506,140 663,655 Vehicle Replacement 18,600,730 3,969,367 5,293,745 17,276,352 Information Technology 9,286,597 16,487,619 15,477,967 10,296,249 Total Internal Service Funds 37,660,408 33,062,331 32,565,436 38,157,303 Successor Agency Housing Trust Fund 1,459,769 510,000 1,068,845 900,924 Total Operating Funds 244,578,067$ 339,824,280$ 342,318,824$ 242,083,523$ * For the General Fund only, this represents unassigned fund balance. June 14, 2022 Item #7 Page 144 of 454 Attachment A2 SCHEDULE OF REVENUE ESTIMATES 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 General Fund Taxes Property Tax 76,822,535$ 79,710,000$ 81,508,000$ 2.3% 1,798,000$ Sales Tax 43,726,520 50,323,000 49,123,000 -2.4% (1,200,000) Transient Occupancy Tax 15,583,688 28,091,000 28,803,000 2.5%712,000 Franchise Tax 5,773,811 6,245,589 6,958,000 11.4%712,411 Business License Tax 5,704,577 6,827,000 6,242,000 -8.6% (585,000) Transfer Tax 1,786,174 1,697,000 1,570,000 -7.5% (127,000) Total Taxes 149,397,305 172,893,589 174,204,000 0.8% 1,310,411 Intergovernmental Homeowners Exemption 346,499 350,000 353,000 0.9%3,000 Other Intergovernmental 9,496,508 7,156,915 617,309 -91.4% (6,539,606) Total Intergovernmental 9,843,007 7,506,915 970,309 -87.1% (6,536,606) Licenses and Permits Building Permits 1,355,056 1,400,000 900,000 -35.7% (500,000) Other Licenses and Permits 1,043,924 1,095,700 963,000 -12.1% (132,700) Total Licenses And Permits 2,398,980 2,495,700 1,863,000 -25.4% (632,700) Charges for Services Planning Fees 365,766 682,500 456,000 -33.2% (226,500) Building Department Fees 808,485 761,000 895,317 17.7%134,317 Engineering Fees 477,352 895,500 608,900 -32.0% (286,600) Ambulance Fees 2,781,450 3,500,000 3,850,000 10.0%350,000 Recreation Fees 1,604,571 2,007,840 2,315,500 15.3%307,660 Other Charges or Fees 1,465,765 1,601,199 1,504,300 -6.1%(96,899) Total Charges For Services 7,503,389 9,448,039 9,630,017 1.9%181,978 Fines and Forfeitures 423,380 216,170 210,750 -2.5%(5,420) Income from Investments and Property 5,639,681 5,600,795 5,481,000 -2.1% (119,795) Interdepartmental Charges 5,146,044 5,290,471 5,236,449 -1.0%(54,022) Other Revenue Sources 1,887,817 1,470,693 1,168,650 -20.5% (302,043) Total General Fund 182,239,603$ 204,922,372$ 198,764,175$ -3.0% (6,158,197)$ * Interest is calculated on an amortized cost basis. June 14, 2022 Item #7 Page 145 of 454 Attachment A2 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 Special Revenue Funds Affordable Housing Affordable Housing Fees 273,120$ 467,000$ 120,000$ -74.3% (347,000)$ Property Tax - - - 0.0%- Interest Income 245,794 448,000 345,000 -23.0% (103,000) Other Revenue 22,727 900,000 30,000 -96.7% (870,000) Total Affordable Housing 541,641 1,815,000 495,000 -72.7% (1,320,000) Agricultural Mitigation Fee Agricultural Mitigation Fees 4,696 210,100 - -100.0% (210,100) Interest Income 1,903 13,000 15,000 15.4%2,000 Total Agriculutural Mitigation Fee 6,599 223,100 15,000 -93.3% (208,100) Buena Vista Channel Maintenance Assessment Fees 138,603 100,000 100,000 0.0%- Interest Income 3,414 15,000 16,000 6.7%1,000 Total Buena Vista Channel Maintenance 142,017 115,000 116,000 0.9%1,000 Citizens' Option for Public Safety State Funding (AB3229)292,465 185,000 200,000 8.1%15,000 Interest Income 1,354 1,034 1,000 -3.3%(34) Total Citizens' Option For Public Safety 293,819 186,034 201,000 8.0%14,966 Community Activity Grants Interest Income 2,036 12,000 13,500 12.5%1,500 Total Community Activity Grants 2,036 12,000 13,500 12.5%1,500 Community Development Block Grant Federal Grant 1,440,502 1,322,368 527,154 -60.1% (795,214) Interest Income 27 - - 0.0%- Other Revenue 166,185 170,000 - -100.0% (170,000) Total Community Dev. Block Grant 1,606,714 1,492,368 527,154 -64.7% (965,214) Cultural Arts Donations Donations 58,342 48,000 25,000 -47.9%(23,000) Interest Income 1,132 3,826 500 -86.9%(3,326) Total Cultural Arts Donations 59,474 51,826 25,500 -50.8%(26,326) Habitat Mitigation Fee Mitigation Fees 16,962 64,500 - -100.0%(64,500) Interest Income (351) 600 - -100.0%(600) Total Habitat Mitigation Fee 16,611 65,100 - -100.0%(65,100) June 14, 2022 Item #7 Page 146 of 454 Attachment A2 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 Special Revenue Funds - Continued Library And Arts Endowment Fund Interest Income 490 2,800 - -100.0%(2,800) Total Library And Arts Endowment Fund 490 2,800 - -100.0%(2,800) Library Gifts/Bequests Gifts and Bequests 243,427 183,232 250,800 36.9%67,568 Interest Income 3,900 17,584 14,100 -19.8%(3,484) Total Library Gifts/Bequests 250,001 200,816 264,900 31.9%64,084 Lighting And Landscaping District 2 Assessment Fees 663,794 645,500 680,000 5.3%34,500 Interest Income 10,257 42,180 50,000 18.5%7,820 Total Lighting And Landscaping Dist. 2 674,051 687,680 730,000 6.2%42,320 Local Cable Infrastructure Fund Cable Fees 302,404 280,000 260,000 -7.1%(20,000) Interest Income 343 8,600 - -100.0%(8,600) Total Local Cable Infrastructure Fund 302,747 288,600 260,000 -9.9%(28,600) Median Maintenance Assessment Fees 349,925 365,000 365,000 0.0%- Other 700,267 950,000 950,000 0.0%- Total Median Maintenance 1,050,192 1,315,000 1,315,000 0.0%- Parking In Lieu Parking In Lieu Fees 44,960 - - 0.0%- Interest Income 2,477 12,000 15,000 25.0%3,000 Total Parking In Lieu 47,437 12,000 15,000 25.0%3,000 Police Asset Forfeiture Asset Forfeitures 5,751 - - 0.0%- Interest Income (288) 918 - -100.0%(918) Total Police Asset Forfeiture 5,463 918 - -100.0%(918) Public Safety Grants Federal Grant 123,843 196,696 - -100.0% (196,696) Total Police Grants 123,843 196,696 - -100.0% (196,696) Recreation Donations Donations 16,444 23,050 31,000 34.5%7,950 Interest Income 373 5,184 539 -89.6%(4,645) Total Recreation Donations 16,817 28,234 31,539 11.7%3,305 June 14, 2022 Item #7 Page 147 of 454 Attachment A2 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 Special Revenue Funds - Continued Rental Assistance Federal Grant 8,745,835 8,984,000 10,072,680 12.1% 1,088,680 Other Revenue 383,582 698,700 1,330,500 90.4%631,800 Total Rental Assistance 9,129,417 9,682,700 11,403,180 17.8% 1,720,480 Senior Donations Donations 3,000 2,000 4,000 100.0%2,000 Interest Income 568 2,037 2,000 -1.8%(37) Other Revenue - 10,000 10,000 0.0%- Total Senior Donations 3,568 14,037 16,000 14.0%1,963 Street Lighting Assessment Fees 686,395 740,000 740,000 0.0%- Other Revenue 162,059 157,000 150,000 -4.5%(7,000) Interest Income 4,956 30,000 30,000 0.0%- Total Street Lighting 853,410 927,000 920,000 -0.8%(7,000) Street Tree Maintenance Assessment Fees 471,086 470,000 470,000 0.0%- Other Revenue 354 440,000 450,000 2.3%10,000 Total Street Tree Maintenance 471,440 910,000 920,000 1.1%10,000 Tyler Court Apartments Rental Income 604,339 640,000 646,672 1.0%6,672 Other Revenue 2,127 1,000 1,965 96.5%965 Interest Income 1 - - 0.0%- Total Tyler Court Apartments 606,467 641,000 648,637 1.2%7,637 Total Special Revenue Funds 16,204,254$ 18,867,909$ 17,917,410$ -5.0% (950,499)$ June 14, 2022 Item #7 Page 148 of 454 Attachment A2 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 Enterprise Funds Water Operations Water Sales 28,691,928$ 28,500,000$ 29,000,000$ 1.8%500,000$ Ready-to-Serve charge 12,301,894 12,300,000 12,300,000 0.0%- Property Tax 4,469,981 4,418,344 4,418,344 0.0%- New Account Charges 130,028 130,000 130,000 0.0%- Back-Flow Program Fees 167,089 175,000 175,000 0.0%- Penalty Fees 5,815 74,150 161,750 118.1%87,600 Interest Income 48,949 354,500 354,500 0.0%- Engineering Overhead 20,822 40,000 42,000 5.0%2,000 Service Connection Fees 43,351 20,000 20,000 0.0%- Other Revenue 3,260,648 1,711,544 388,544 -77.3% (1,323,000) Total Water Operations 49,140,505 47,723,538 46,990,138 -1.5% (733,400) Recycled Water Operations Water Sales 7,151,961 7,200,000 7,366,000 2.3%166,000 Ready-to-Serve charge 1,209,044 1,300,000 1,339,000 3.0%39,000 Interest Income (91,990) (64,000) (64,000) 0.0%- Other Revenue 276,035 101,611 89,496 -11.9%(12,115) Total Recycled Water Operations 8,545,050 8,537,611 8,730,496 2.3%192,885 Wastewater Operations Service Charges 14,007,136 15,304,000 19,000,000 24.2% 3,696,000 Misc. Sewer 19,614 (19,000) - -100.0%19,000 Engineering Overhead 16,199 19,000 25,000 31.6%6,000 Penalty Fees (11) 43,000 65,000 51.2%22,000 Interest Income (11,915) 95,000 95,000 0.0%- Other Revenue 1,499,601 84,500 91,500 8.3%7,000 Total Wastewater Operations 15,530,624 15,526,500 19,276,500 24.2% 3,750,000 Solid Waste Management Recycling Fees (AB939)337,133 360,000 800,000 122.2%440,000 Penalty Fees (7) 19,000 19,000 0.0%- Trash Surcharge 3,049,951 3,000,000 2,100,000 -30.0% (900,000) Interest Income 16,881 140,200 160,100 14.2%19,900 Other Revenue 730,663 565,247 1,920,130 239.7% 1,354,883 Total Solid Waste Management 4,134,621 4,084,447 4,999,230 22.4%914,783 Golf Course Operations Charges for Services 8,105,675 8,830,000 9,466,000 7.2%636,000 Interest Income 10,852 30,000 19,000 -36.7%(11,000) Other Revenue 55,544,802 97,000 89,000 -8.3%(8,000) Total Golf Course Operations 63,661,329 8,957,000 9,574,000 6.9%617,000 Total Enterprise Funds 141,012,129$ 84,829,096$ 89,570,364$ 5.6% 4,741,268$ June 14, 2022 Item #7 Page 149 of 454 Attachment A2 2021-22 2022-23 Change as %Difference 2020-21 Estimated Estimated of 2021-22 2021-22 to Revenue Source Actuals Revenue Revenue Estimated 2022-23 Internal Service Funds Workers' Compensation Interdepartmental Charges 1,880,304$ 4,524,730$ 5,174,620$ 14.4%649,890$ Interest Income 39,441 142,000 140,000 -1.4%(2,000) Other Revenue 2,212,056 225,000 - -100.0% (225,000) Total Workers' Compensation 4,131,801 4,891,730 5,314,620 8.6%422,890 Risk Management Interdepartmental Charges 2,308,836 3,306,080 3,946,370 19.4%640,290 Interest Income 1,928 46,000 47,000 2.2%1,000 Other Revenue 59,053 40,000 - -100.0%(40,000) Total Risk Management 2,369,817 3,392,080 3,993,370 17.7%601,290 Vehicle Maintenance Interdepartmental Charges 3,207,532 3,291,562 3,272,355 -0.6%(19,207) Interest Income 839 6,500 5,000 -23.1%(1,500) Other Revenue 33,250 58,000 20,000 -65.5%(38,000) Total Vehicle Maintenance 3,241,621 3,356,062 3,297,355 -1.8%(58,707) Vehicle Replacement Interdepartmental Charges 2,872,200 3,574,451 3,575,367 0.0%916 Interest Income 49,260 200,000 194,000 -3.0%(6,000) Other Revenue 1,522,556 225,000 200,000 -11.1%(25,000) Total Vehicle Replacement 4,444,016 3,999,451 3,969,367 -0.8%(30,084) Information Technology Interdepartmental Charges 12,530,344 14,752,389 16,408,619 11.2% 1,656,230 Interest Income (28,270) 59,393 79,000 33.0%19,607 Other Revenue 1,243,014 46,700 - -100.0%(46,700) Total Information Technology 13,745,088 14,858,482 16,487,619 11.0% 1,629,137 Total Internal Service Funds 27,932,343$ 30,497,805$ 33,062,331$ 8.4% 2,564,526$ Trust Funds Sucssessor Agency Housing Fund Property Tax Increment 3,013,484 1,060,000 500,000 -52.8% (560,000) Interest Income 768,871 7,000 10,000 42.9%3,000 Total Successor Agency Housing Fund 3,782,355 1,067,000 510,000 -52.2% (557,000) Total Trust Funds 3,782,355$ 1,067,000$ 510,000$ -52.2% (557,000)$ Total Operating Funds 371,170,684$ 340,184,182$ 339,824,280$ -0.1% (359,902)$ June 14, 2022 Item #7 Page 150 of 454 Attachment A3 SCHEDULE OF BUDGET EXPENDITURES 2021-22 Change as % 2019-20 2020-21 Estimated 2021-22 2022-23 of 2021-22 Department Actuals Actuals Expenditures Budget Budget Budget General Fund Policy And Leadership Group City Council 466,528$ 487,977$ 632,975$ 649,975$ 652,220$ 0.3% City Attorney 1,910,060 2,036,466 2,033,136 2,037,136 2,033,508 -0.2% City Clerk 1,126,417 1,207,035 1,436,264 1,300,469 1,394,162 7.2% City Manager 2,574,961 1,939,537 2,042,542 2,112,097 2,156,145 2.1% City Treasurer 215,784 235,400 278,000 250,752 249,945 -0.3% Communication & Engagement 1,651,700 1,493,938 2,031,550 1,771,173 1,979,186 11.7% Total Policy And Leadership Group 7,945,450 7,400,353 8,454,467 8,121,602 8,465,166 4.2% Administrative Services Administration - - 525,745 568,883 747,797 31% Finance 5,617,702 5,810,863 5,950,000 5,632,387 5,472,176 -2.8% Human Resources 4,302,513 4,359,159 4,542,911 4,959,011 5,264,775 6.2% Innovation & Economic Development 1,097,395 1,427,603 1,252,000 1,264,626 2,585,951 104.5% Total Administrative Services 11,017,610 11,597,625 12,270,656 12,424,907 14,070,699 13.2% Community Services Community Services Administration - 654,001 862,511 656,221 675,917 3.0% Community Development 10,328,444 10,715,350 9,893,000 10,502,061 10,384,700 -1.1% Housing & Homeless Services - - 1,488,217 5,901,431 3,134,115 -47% Library & Cultural Arts 13,030,148 12,344,689 14,030,250 13,780,555 14,088,425 2.2% Parks & Recreation 17,584,182 16,786,632 20,629,095 19,159,380 21,167,014 10.5% Total Community Services 40,942,774 40,500,672 46,903,073 49,999,648 49,450,171 -1.1% Public Safety Fire 25,620,353 30,712,871 34,651,000 33,521,412 37,756,943 12.6% Police 44,841,600 47,615,546 48,936,163 48,756,017 51,240,884 5.1% Total Public Safety 70,461,953 78,328,417 83,587,163 82,277,429 88,997,827 8.2% Public Works Public Works Administration 1,768,613 1,808,997 1,800,000 1,941,613 1,440,649 -25.8% Construction Management & Inspection 2,944,509 2,728,545 2,760,000 2,990,665 3,262,768 9.1% Environmental Management 758,852 1,030,453 844,297 1,282,225 1,159,789 -9.5% Fleet & Facilities 5,537,243 5,341,736 5,830,000 6,555,934 6,768,736 3.2% Transportation 7,583,250 7,553,800 9,230,700 8,405,466 9,707,559 15.5% Total Public Works 18,592,467 18,463,531 20,464,997 21,175,903 22,339,501 5.5% Miscellaneous Non-Departmental Expenditures Community Contributions 7,983 2,595 - - - - Dues & Subscriptions 71,519 72,714 75,000 80,000 80,000 0.0% Legal Services 697,114 755,312 500,000 1,200,000 1,000,000 -16.7% Professional Services 39,195 34,194 35,000 42,000 41,658 -0.8% Other Miscellaneous Expenditures 3,860,320 1,055,650 55,000 - 100,000 - Personnel Related 152,582 184,337 200,000 850,000 1,050,000 23.5% COVID-related 910,211 245,579 150,000 - - - Vacancy savings - - - - (2,000,000) - Property Tax & Other Administration 658,895 759,165 750,000 750,000 750,000 0.0% Total Miscellaneous Non-Departmental Expenditures 6,397,819 3,109,546 1,765,000 2,922,000 1,021,658 -65.0% June 14, 2022 Item #7 Page 151 of 454 Attachment A3 2021-22 Change as % 2019-20 2020-21 Estimated 2021-22 2022-23 of 2021-22 Department Actuals Actuals Expenditures Budget Budget Budget General Fund - Continued Transfers Transfer to General Capital Construction Fund 5,111,500$ 4,500,000$ 13,133,056$ 5,353,000$ 3,956,000$ -59.2% Transfer to Infrastructure Replacement Fund 5,111,500 4,500,000 5,353,000$ 5,353,000$ 3,956,000$ 0.0% Transfer from Infrastructure Replacement Fund - - (5,070,000)$ (5,070,000)$ -$ 0.0% Transfer to Technology Investment Capital Fund - 10,656,000$ -$ 3,956,000$ Transfer To LLD#1 (Medians & Trees)950,000 700,000 1,390,000$ 1,190,000$ 1,400,000$ -14.4% Transfer To Storm Water Program 303,052 281,040 322,000$ 322,000$ 332,000$ 0.0% Other Miscellaneous Transfers 2,090,114 47,031,506 993,748$ -$ -$ -100.0% Total Transfers 13,566,166 57,012,546 26,777,804 7,148,000 13,600,000 90.3% Total Miscellaneous Non-Departmental 19,963,985 60,122,092 28,542,804 10,070,000 14,621,658 45.2% Subtotal General Fund 168,924,239 216,412,690 200,223,160 184,069,489 197,945,022 7.5% Contingencies - - - 500,000 500,000 0.0% Total General Fund 168,924,239$ 216,412,690$ 200,223,160$ 184,569,489$ 198,445,022$ 7.5% Special Revenue Funds Affordable Housing 868,053$ 4,674,625$ 200,000$ 811,197$ 393,385$ -51.5% Agricultural Mitigation Fee - - - - - - Buena Vista Channel Maintenance 71,738 80,982 106,500 195,245 195,245 0.0% Citizens' Option For Public Safety 247,072 263,590 266,106 266,106 265,705 -0.2% Community Activity Grants - - 15,000 30,000 30,000 0.0% Community Development Block Grant 324,153 936,783 1,548,299 638,299 636,728 -0.2% Cultural Arts Donations 29,510 25,447 82,491 131,750 131,750 0.0% Flower Fields Grant Program 943,272 - - - - - Habitat Mitigation Fee 1,115,129 16,961 - - - - Library And Arts Endowment Fund - - 6,000 6,000 6,000 0.0% Library Gifts/Bequests 217,268 144,279 216,363 384,270 394,467 2.7% Lighting And Landscaping District 2 353,503 287,307 398,124 376,001 338,070 -10.1% Local Cable Infrastructure Fund 207,119 336,001 467,962 345,000 395,006 14.5% Median Maintenance 1,077,147 1,036,374 1,160,000 1,369,415 1,329,900 -2.9% Parking In Lieu 47,547 48,244 49,675 50,000 53,000 6.0% Police Asset Forfeiture 122,365 54,225 20,000 170,000 125,000 -26.5% Public Safety Grants 126,353 117,267 196,696 - - - Recreation Donations 28,289 26,165 45,782 82,591 81,009 -1.9% Rental Assistance 7,832,253 9,024,886 9,597,000 7,898,443 10,409,089 31.8% Senior Donations 20,592 5,367 19,000 79,600 50,500 -36.6% Street Lighting 633,162 777,332 849,000 971,246 1,065,393 9.7% Street Tree Maintenance 575,205 750,272 950,000 943,555 880,235 -6.7% Tyler Court Apartments 497,143 474,209 485,000 640,987 540,716 -15.6% Total Special Revenue Funds 15,336,873 19,080,316 16,678,998 15,389,705 17,321,198 12.6% June 14, 2022 Item #7 Page 152 of 454 Attachment A3 2021-22 Change as % 2019-20 2020-21 Estimated 2021-22 2022-23 of 2021-22 Department Actuals Actuals Expenditures Budget Budget Budget Enterprise Funds Water Operations 45,018,846$ 47,685,382$ 51,321,219$ 47,821,220$ 49,715,832$ 4.0% Recycled Water Operations 8,103,913 7,603,103 11,403,789 10,103,790 11,206,521 10.9% Wastewater Operations 13,504,660 13,053,207 16,057,474 16,057,473 16,999,568 5.9% Solid Waste Management 4,508,618 5,003,349 4,017,239 5,183,474 5,801,402 11.9% Golf Course Operations 7,715,414 6,832,769 7,306,826 7,231,000 9,195,000 27.2% Total Enterprise Funds 78,851,451 80,177,810 90,106,547 86,396,957 92,918,323 7.5% Internal Service Funds Workers' Compensation 3,714,494 3,408,864 4,246,463 3,933,699 4,507,014 14.6% Risk Management 2,515,711 2,675,135 3,740,520 3,207,702 3,780,570 17.9% Self-Insured Benefits 66,103 1,834,163 - - - - Vehicle Maintenance 2,951,752 3,239,389 3,510,000 3,516,373 3,506,140 -0.3% Vehicle Replacement 2,165,563 2,342,065 4,540,000 4,546,033 5,293,745 16.4% Information Technology 10,153,198 13,917,753 13,892,500 14,369,778 15,477,967 7.7% Total Internal Service Funds 21,566,821 27,417,369 29,929,483 29,573,585 32,565,436 10.1% Trust Funds Successor Agency Housing Fund 398,597 239,902 1,038,500 1,067,495 1,068,845 0.1% Total Trust Funds 398,597 239,902 1,038,500 1,067,495 1,068,845 0.1% Total Operating Funds 285,077,981$ 343,328,087$ 337,976,688$ 316,997,231$ 342,318,824$ 8.0% June 14, 2022 Item #7 Page 153 of 454 I-16 PROJECTED FUND BALANCES FOR FISCAL YEAR 2021-22 July 1, 2021 Projected June 30, 2022 Unreserved Projected Projected Debt Service Projected Fund Balance Revenues Expenditures Loans & Other Balance BTD#2 - Poinsettia Lane/Aviara Pkwy 13,513,126 1,881,644 - - 15,394,770 BTD#3 - Cannon Road West 520,569 6,026 - - 526,595 CFD #1 - Citywide 94,519,267 2,569,143 1,548,784 136,939 95,402,688 Gas Tax 13,249,248 3,187,066 2,849,097 610,000 12,977,217 Gas Tax (Road Maint. & Rehab Acct.)4,470,272 2,449,147 5,435,499 - 1,483,920 General Capital Const.41,842,109 13,146,189 23,557,683 - 31,430,615 Grants - Federal (5,696) 1,138,005 145 - 1,132,164 Infrastructure Replacement 123,490,551 1,790,608 12,051,911 - 113,229,248 Other 1,914,046 22,138 962,234 - 973,950 Park Fee Zones 5,13,16, 17, 18 4,746,080 225,641 - - 4,971,721 Park-In-Lieu NE 4,618,117 155,317 - - 4,773,434 Park-In-Lieu NW 2,181,771 399,653 - - 2,581,424 Park-In-Lieu SE 1,747,717 139,642 1,196 - 1,886,163 Park-In-Lieu SW 754,704 54,984 - - 809,688 Planned Local Drainage Area A 972,197 32,116 34,551 - 969,762 Planned Local Drainage Area B 1,478,924 84,142 110,661 - 1,452,405 Planned Local Drainage Area C 1,547,165 56,164 2,802 - 1,600,527 Planned Local Drainage Area D 657,242 275,385 33,732 - 898,895 Public Facilities Fee 30,801,682 1,064,333 2,897,693 - 28,968,322 Sewer Connection 6,610,339 256,504 2,762,488 - 4,104,355 Sewer Replacement 21,282,557 5,519,725 6,405,387 - 20,396,895 Traffic Impact Fee 23,287,504 1,256,032 4,783,390 - 19,760,146 Transnet/Local 28,612,186 5,243,493 5,883,694 - 27,971,985 Water - Potable 36,447,661 889,627 145,381 - 37,191,908 Water - Recycled (11,310,024) 2,159,175 1,874,866 - (11,025,715) Water Replacement - Potable 57,252,332 4,723,694 3,150,724 - 58,825,301 Water Replacement - Recycled 18,726,556 192,424 2,528,816 - 16,390,164 Total 523,928,204 48,918,018 77,020,734 746,939 495,078,549 Attachment B June 14, 2022 Item #7 Page 154 of 454 PROJECTED FUND BALANCES FOR FISCAL YEAR 2022-23 July 1, 2022 June 30, 2022 July 01, 2022 2022-23 June 30, 2023 Projected Estimated Continuing New Total Projected Fund Balance Revenues Appropriations Appropriations Appropriations Balance BTD#2 - Poinsettia Lane/Aviara Pkwy 15,394,770 - 13,499,116 - 13,499,116 1,895,654 BTD#3 - Cannon Road West 526,595 - - - - 526,595 CFD #1 - Citywide 95,402,688 2,853,218 32,056,555 1,367,250 33,423,805 64,832,101 Gas Tax 12,977,217 3,377,749 12,645,638 3,527,852 16,173,490 181,476 Gas Tax (Road Maint. & Rehab Acct.)1,483,920 2,632,806 814,841 2,920,000 3,734,841 381,885 General Capital Const.31,430,615 4,051,000 18,328,229 1,949,588 20,277,817 15,203,798 Grants - Federal 1,132,164 2,373,295 3,505,459 - 3,505,459 0 Infrastructure Replacement 113,229,248 3,977,000 34,360,424 3,475,878 37,836,302 79,369,946 Other 973,950 - 323,489 - 323,489 650,461 Park Fee Zones 5,13,16, 17, 18 4,971,721 48,255 - - - 5,019,975 Park-In-Lieu NE 4,773,434 - 400,000 214,000 614,000 4,159,434 Park-In-Lieu NW 2,581,424 1,792,968 792 2,561,764 2,562,556 1,811,837 Park-In-Lieu SE 1,886,163 679,039 2,916 220,889 223,805 2,341,398 Park-In-Lieu SW 809,688 - 221,919 (2,355) 219,564 590,124 Planned Local Drainage Area A 969,762 28,788 39,391 25,000 64,391 934,159 Planned Local Drainage Area B 1,452,405 151,107 29,823 10,355 40,178 1,563,334 Planned Local Drainage Area C 1,600,527 156,935 38,274 25,000 63,274 1,694,188 Planned Local Drainage Area D 898,895 80,989 41,820 - 41,820 938,063 Public Facilities Fee 28,968,322 1,866,561 6,088,569 (820,408) 5,268,161 25,566,722 Sewer Connection 4,104,355 396,950 3,384,837 1,003,000 4,387,837 113,467 Sewer Replacement 20,396,895 5,560,398 26,168,950 9,022,521 35,191,471 (9,234,178) Traffic Impact Fee 19,760,146 1,535,630 15,976,033 3,419,516 19,395,549 1,900,228 Transnet/Local 27,971,985 5,347,000 21,040,978 6,946,268 27,987,246 5,331,739 Water - Potable 37,191,908 1,724,252 11,179,664 523,601 11,703,265 27,212,895 Water - Recycled (11,025,715) 14,272,277 6,998,950 (4,017,388) 2,981,562 265,000 Water Replacement - Potable 58,825,301 5,609,663 39,292,528 8,783,006 48,075,534 16,359,430 Water Replacement - Recycled 16,390,164 1,000,000 5,092,443 1,417,500 6,509,943 10,880,221 Total 495,078,549 59,515,879 251,531,638 42,572,837 294,104,475 260,489,953 June 14, 2022 Item #7 Page 155 of 454 I-18 REVENUE PROJECTIONS SCHEDULE 2018-19 2019-20 2020-21 2021-22 2022-23 Actual Actual Actual Projected Estimated Fund Revenue Revenue Revenue Revenue Revenue BTD#2 - Poinsettia Lane/Aviara Pkwy 751,810 217,466 22,020 1,881,644 - BTD#3 - Cannon Road West 18,996 17,696 949 6,026 - CFD #1 - Citywide 6,095,889 5,736,415 2,286,479 2,569,143 2,853,218 Gas Tax 3,299,173 3,118,353 2,733,074 3,187,066 3,377,749 Gas Tax (Road Maint. & Rehab Acct.)2,132,844 2,067,614 2,149,734 2,449,147 2,632,806 General Capital Const.1,077,525 5,111,500 4,654,470 13,146,189 4,051,000 Grants - Federal 956,847 41,175 256,529 1,138,005 2,373,295 Infrastructure Replacement 15,073,019 9,369,345 4,704,670 1,790,608 3,977,000 Other 19,704 65,369 3,384 22,138 - Park Fee Zones 5,13,16, 17, 18 244,229 255,028 78,182 225,641 48,255 Park-In-Lieu NE 1,441,530 347,407 451,497 155,317 - Park-In-Lieu NW 1,086,531 260,256 429,037 399,653 1,792,968 Park-In-Lieu SE 372,419 326,671 3,205 139,642 679,039 Park-In-Lieu SW 190,127 271,373 319,862 54,984 - Planned Local Drainage Area A 155,094 48,111 27,489 32,116 28,788 Planned Local Drainage Area B 136,887 174,328 635,853 84,142 151,107 Planned Local Drainage Area C 82,796 53,875 2,779 56,164 156,935 Planned Local Drainage Area D 124,198 31,433 2,877 275,385 80,989 Public Facilities Fee 3,673,762 3,439,781 1,751,477 1,064,333 1,866,561 Sewer Connection 874,464 749,326 332,049 256,504 396,950 Sewer Replacement 7,662,061 5,682,839 4,390,568 5,519,725 5,560,398 Traffic Impact Fee 2,586,291 1,924,738 1,084,181 1,256,032 1,535,630 Transnet/Local 3,779,436 4,546,554 3,347,237 5,243,493 5,347,000 Water - Potable 2,064,521 2,188,356 713,234 889,627 1,724,252 Water - Recycled 2,144,721 2,815,693 59,190 2,159,175 14,272,277 Water Replacement - Potable 6,970,260 7,885,252 6,378,189 4,723,694 5,609,663 Water Replacement - Recycled 2,046,796 1,995,701 1,083,332 192,424 1,000,000 Total 65,061,930 58,741,652 37,901,545 48,918,018 59,515,879 June 14, 2022 Item #7 Page 156 of 454 BUDGET EXPENDITURE SCHEDULE 2019-20 2020-21 2021-22 2022-23 2022-23 2022-23 Actual Actual Estimated Continuing New Total FUND Expense Expense Expense Appropriations Appropriations Appropriations BTD#2 - Poinsettia Lane/Aviara Pkwy 270,034 - - 13,499,116 - 13,499,116 BTD#3 - Cannon Road West - - - - - - CFD #1 - Citywide 381,703 582,179 1,685,723 32,056,555 1,367,250 33,423,805 Gas Tax 2,803,727 2,911,799 3,459,097 12,645,638 3,527,852 16,173,490 Gas Tax (Road Maint. & Rehab Acct.)889,601 170,381 5,435,499 814,841 2,920,000 3,734,841 General Capital Const.5,503,817 5,086,290 23,557,683 18,328,229 1,949,588 20,277,817 Grants - Federal 41,175 260,820 145 3,505,459 - 3,505,459 Infrastructure Replacement 5,848,629 3,333,331 12,051,911 34,360,424 3,475,878 37,836,302 Other - 8,868 962,234 323,489 - 323,489 Park Fee Zones 5,13,16, 17, 18 - -- - - - Park-In-Lieu NE - -- 400,000 214,000 614,000 Park-In-Lieu NW 925 - - 792 2,561,764 2,562,556 Park-In-Lieu SE 4,850 - 1,196 2,916 220,889 223,805 Park-In-Lieu SW 383,869 1,118 - 221,919 (2,355) 219,564 Planned Local Drainage Area A 107,524 6,131 34,551 39,391 25,000 64,391 Planned Local Drainage Area B 305,319 1,510,279 110,661 29,823 10,355 40,178 Planned Local Drainage Area C 99,472 4,174 2,802 38,274 25,000 63,274 Planned Local Drainage Area D 107,285 49,311 33,732 41,820 - 41,820 Public Facilities Fee 1,184,567 164,847 2,897,693 6,088,569 (820,408) 5,268,161 Sewer Connection 190,119 810,372 2,762,488 3,384,837 1,003,000 4,387,837 Sewer Replacement 7,797,397 8,206,747 6,405,387 26,168,950 9,022,521 35,191,471 Traffic Impact Fee 629,024 1,196,826 4,783,390 15,976,033 3,419,516 19,395,549 Transnet/Local 4,294,221 2,152,292 5,883,694 21,040,978 6,946,268 27,987,246 Water - Potable 42,813 17,507 145,381 11,179,664 523,601 11,703,265 Water - Recycled 6,937,689 3,235,638 1,874,866 6,998,950 (4,017,388) 2,981,562 Water Replacement - Potable 6,761,187 5,224,472 3,150,724 39,292,528 8,783,006 48,075,534 Water Replacement - Recycled 151,548 792,286 2,528,816 5,092,443 1,417,500 6,509,943 Total 44,736,495 35,725,667 77,767,673 251,531,638 42,572,837 294,104,475 June 14, 2022 Item #7 Page 157 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding Source Abandon Potable Services (New Recycled Services)NO Citywide Medium 52051 WATER REPL ADA Beach Access - Pine to Tamarack NO 1 Medium 60651 GCC ADA Improvement Program NO 1 High 60491 TRANSNET-LOC Agua Hedionda Creek Maintenance NO 2 High 33381 PLDB 66291 IRF Agua Hedionda LiŌ StaƟon Biological Monitoring and Maintenance NO 2 CriƟcal 55451 SEWER REPL Alga Norte Park ModificaƟons NO 2 Medium 47331 GCC Assessment District 97-1 Maintenance NO 3 Medium 60841 GCC Avenida Encinas and Palomar Airport Road Pedestrian Access Improvement NO 2 Low 60911 GAS TAX Avenida Encinas Coastal Rail Trail and Pedestrian Improvements NO 2,3 CriƟcal 60041 TIF 60042 FED GRNT Aviara Reimbursement Agreement NO 2 Low 36491 PIL-SW Barrio Street LighƟng NO 1 High 40131 GCC 40133 GAS TAX 40134 TRANSNET-LOC Beach Access Repair and Upgrades - Pine Avenue to Tamarack NO 1 CriƟcal 38961 IRF 38962 GCC Bridge PreventaƟve Maintenance Program NO Citywide High 60661 IRF Buena Interceptor Sewer Access Road Improvements NO 3 High 55371 SEWER REPL Buena Interceptor Sewer Improvements NO 2,3 High 55011 SEWER REPL 55012 SEWER CONN Buena Interceptor Sewer Realignment - East Segment NO 2 High 55441 SEWER REPL Buena Vista Creek Concrete Channel Maintenance at El Camino Real NO 1 CriƟcal 66191 GCC 66192 IRF Business Park RecreaƟonal Facility (ParƟal Funding)NO 2 Low 19041 ZONE 5 C-Tank Access Road Repair and Electrical Improvements YES 2 Medium 23011 RECYREPL 23012 RECYCONN Calavera Hills Community Center Refurbishment NO 2 Medium 47461 IRF Calavera Hills Community Park Gateway Improvements NO 2 High 46011 GCC Camino De Los Coches and La Costa Avenue IntersecƟon Control NO 4 CriƟcal 63251 GAS TAX Camino Hills and Jackspar Drive Slope StabilizaƟon NO 2 Medium 60301 GCC Cannon Park Restroom NO 2 Low 47261 GCC Cannon Road LiŌ StaƟon Improvements NO 2 High 55521 SEWER REPL Carlsbad Boulevard and Tamarack Avenue Pedestrian Improvements NO 1 High 60581 GAS TAX 60583 TRANSNET- LOC Carlsbad Boulevard Emergency Repair NO 3 High 60631 GAS TAX Carlsbad Boulevard Lane ReducƟon and EdgeStriping NO 2,3 High 60961 GAS TAX 1,925,825----500,000500,00050,000875,825 2,875,000----2,500,000--375,000 9,385,0002,225,0002,225,000715,000175,000715,000175,000715,0002,440,000 3,545,249-------14,6453,559,894 1,663,000585,000520,00095,00090,00080,00080,00080,000133,000 225,000-------225,000 1,020,200-----706,200-314,000 420,000-------420,000 100,000-----25,000-75,000 5,177,903------3,177,0002,000,903 1,776,000-------1,776,000 238,000-------238,000 760,000-------760,000 700,000-------700,000 3,590,000----1,030,0001,280,0001,280,000- 5,912,750------1,800,0004,112,750 6,199,000-------6,199,000 4,177,511---700,000500,000500,000250,0002,227,511 1,150,000-------1,150,000 5,348,686---920,0002,070,0001,150,000250,000958,686 550,000-------550,000 2,675,000-----2,168,000-507,000 2,260,000425,000375,00030,000150,00030,000--1,250,000 4,020,000-----1,200,000-2,820,000 5,065,200---4,665,200400,000--- 1,575,000----1,325,000-250,000- 315,000----265,000-50,000- 1,985,000------1,300,000685,000 1,407,850-------1,407,850 850,000-----500,000-350,000 859,400-------859,400 55,645-------55,645 715,000------565,000150,000 2,276,000----700,000--1,576,000 1,054,000-------1,054,000 841,000-------841,000 15-year Capital Improvement Program Attachment B2 June 14, 2022 Item #7 Page 158 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding Source Carlsbad Boulevard Emergency Repair NO 3 High 60631 GAS TAX Carlsbad Boulevard Lane ReducƟon and Edge Striping NO 2,3 High 60961 GAS TAX Carlsbad Boulevard Median - Tamarack Avenue to Pine Avenue NO 1 Low 19071 GAS TAX Carlsbad Boulevard Pedestrian Improvement Project NO 1 High 60971 GAS TAX 60972 FED GRNT Carlsbad Boulevard Pedestrian LighƟng NO 1 High 60681 TRANSNET-LOC Carlsbad Boulevard Realignment -Manzano Drive to Island Way NO 2 Low 19081 TIF 19091 TIF Carlsbad Boulevard Waterline Replacement at Terramar NO 2 CriƟcal 50481 WATER REPL Carlsbad Village Drive and Grand Avenue Pedestrian and Crossing Improvements NO 1 Medium 19121 TRANSNET- LOC Carlsbad Water Recycling Facility (Encina Capital Projects)NO 3 High 52031 WATER REPL 52032 RECL REPL Carlsbad Water Recycling Facility IrrigaƟon and Landscape NO 3 High 52131 RECL REPL Carlsbad Water Recycling Facility Roof Replacement NO 3 Low 47491 RECL REPL Cathodic ProtecƟon Program NO Citywide CriƟcal 50071 WATER REPL CFD#1 AdministraƟon NO 2,3 Low 19151 CFD#1 Chestnut Avenue Complete Street Improvements - Valley to Pio Pico NO 1 Medium 19161 TRANSNET-LOC Chestnut Complete Street I-5 to Railroad Project Study NO 1 Medium 60691 TRANSNET- LOC Chestnut Underpass Public Art Project NO 1 Medium 60981 GCC Chinquapin LiŌ StaƟon Improvements YES 1 High 23031 SEWER REPL ChrisƟansen Way Improvements NO 1 Medium 19171 TRANSNET-LOC City Facility Accessibility Upgrades NO Citywide Medium 47271 GCC City Facility Safety and Parking Lot LighƟng Assessment NO Citywide High 60741 IRF 60742 PIL-NW City Fire StaƟons Wash Water BMPs NO 2 Medium 66161 GCC City Hall Complex NO Citywide CriƟcal 40081 CFD#1 City Hall Complex Refurbishment NO 1 Medium 47181 IRF City Hall Exterior Refurbishment NO 1 CriƟcal 47251 GCC Citywide Drainage Improvement Program NO 1 High 66082 GAS TAX 66083 IRF Citywide Street LighƟng Program NO Citywide Medium 60921 GAS TAX Citywide ThermoplasƟc Pavement Markings NO Citywide CriƟcal 60931 GAS TAX Cole Library Expansion NO 1 Low 19211 CFD#1 19212 PFF 19213 GCC Cole Library Security Fencing NO 1 Low 47501 IRF College Boulevard - Cannon Road To Badger Lane (375 Zone)NO 2 Medium 50131 WATER CONN College Boulevard - Cannon Road To Badger Lane (490 Zone)NO 2 Medium 50121 WATER CONN 300,000-------300,000 2,763,0002,763,000------- 222,100-------222,100 591,600-------591,600 1,325,000-------1,325,000 932,000932,000------- 3,681,0003,681,000------- 4,730,000------1,300,0003,430,000 1,320,000---1,320,000---- 599,944-------599,944 9,032,7101,252,000252,000223,0001,879,000895,000474,000366,0003,691,710 175,000-------175,000 225,000-------225,000 3,096,700280,000260,000190,000190,000190,000190,000190,0001,606,700 550,000--110,000110,000110,000110,000110,000- 1,080,000----1,080,000--- 85,000-----85,000-- 250,000------150,000100,000 1,220,000-----920,000300,000- 310,000---310,000---- 500,000-------500,000 1,910,000-------1,910,000 200,000-----200,000-- 280,000-------280,000 51,028,105-50,000,000-----1,028,105 1,144,000-------1,144,000 2,250,000-------2,250,000 6,090,594-------6,090,594 9,781,5001,500,0001,500,000300,000300,000300,000300,000900,0004,681,500 150,000-------150,000 50,000-------50,000 5,988,0005,988,000------- 11,936,00011,936,000------- 1,000,0001,000,000------- 170,000------130,00040,000 1,278,383----1,000,000-28,200250,183 15-year Capital Improvement Program June 14, 2022 Item #7 Page 159 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding SourceCollege Boulevard - Cannon Road To Badger Lane (375 Zone)NO 2 Medium 50131 WATER CONN College Boulevard - Cannon Road To Badger Lane (490 Zone)NO 2 Medium 50121 WATER CONN College Boulevard Extension NO 2 High 36362 OTHER 36363 PLDB 36364 TRANSNET- LOC Concrete Repair/Replacement Program NO 4 Medium 60132 GAS TAX 60133 RMRA Coordinated Traffic Signal Program NO Citywide High 63261 TRANSNET-LOC 63264 TRANSNET- LOC 63265 IRF Crestview Drive Transmission Main NO 1 Medium 50331 WATER REPL Desalinated Water Flow Control Facility No. 5 NO 2 High 50381 WATER CONN DMP Facility AAA (Jefferson Street) NO 1 Low 19231 PLDA DMP Facility AAAA (Madison Street) NO 1 Medium 19241 PLDA DMP Facility AC (Highland Drive Drainage Project)NO 1 Medium 66091 PLDA DMP Facility AFA (Hidden Valley Drainage RestoraƟon and Enhancement Project)NO 2 Low 19251 PLDA DMP Facility AFB (Calavera Hills Drainage RestoraƟon and Enhancement Project)NO 2 Low 19261 PLDA DMP Facility BB 1 and 2 (Washington Street)NO 1 Low 19271 PLDB DMP Facility BCB (Magnolia Avenue) NO 1 Medium 19281 PLDB DMP Facility BFA (Country Store) NO 2 High 66271 PLDB DMP Facility BFB-L and BFB-1 (Tamarack and El Camino Real Plda "B")NO 1 Low 19291 PLDB DMP Facility BFB-U (El Camino Real) NO 1 High 66221 PLDB 66222 IRF DMP Facility BL-L (College Boulevard Bridge Reimbursement Plda "B")NO 2 Low 19301 PLDB DMP Facility BL-U (College Boulevard) NO 2 Low 19311 PLDB DMP Facility BM (Cantarini/College Boulevard Box Culvert)NO 2 Low 19321 PLDB DMP Facility BQ (Sunny Creek) NO 2 Low 19331 PLDB DMP Facility BR (Cantarini/College Boulevard Pipe Drainage)NO 2 Low 19341 PLDB DMP Facility C2 (Paseo Del Norte) NO 3 Low 19351 PLDC DMP Facility CA (Avenida Encinas) NO 3 Low 19361 PLDC DMP Facility DBB (Avenida Encinas) NO 4 Low 19381 PLDD DMP Facility DFA (BaƟquitos Lagoon Stormwater Treatment)NO 4 Low 19391 PLDD DMP Facility DH (AlƟve Place Canyon RestoraƟon)NO 3 Low 19401 PLDD DMP Facility DQB (La Costa Town Center) NO 4 Medium 19411 PLDD DMP Facility DZ (Poinseƫa Lane) NO 3 High 19421 PLDD Dove Library LighƟng Improvements NO 3 Low 40811 GCC Drainage Master Plan Facility DBA (Poinseƫa Village)NO 4 Low 19371 PLDD 66231 PLDA 1,562,600----1,250,000-12,600300,000 1,713,002-------1,713,002 --------- 1,205,000-------1,205,000 2,933,000-------2,933,000 6,327,0001,250,0001,250,000620,000620,000620,000620,000620,000727,000 2,583,979-------2,583,979 1,000,000-------1,000,000 800,000-------800,000 856,000-----535,00021,000300,000 10,811,601------707,30110,104,300 289,534289,534------- 416,500416,500------- 921,408921,408------- 91,60891,608------- 163,164163,164------- 1,086,0651,086,065------- 468,096468,096------- 1,241,649-------1,241,649 904,329904,329------- 153,489-------153,489 4,100,00050,00050,00050,00050,00050,0003,000,000100,000750,000 1,816,101-1,816,101------ 384,509384,509------- 204,077204,077------- 131,355131,355------- 180,773180,773------- 727,730727,730------- 529,402529,402------- 429,108429,108------- 256,423256,423------- 232,812232,812------- 745,842745,842------- 642,063642,063------- 225,000-------225,000 167,215167,215------- 15-year Capital Improvement Program June 14, 2022 Item #7 Page 160 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding SourceDrainage Master Plan Facility DBA (Poinseƫa Village)NO 4 Low 19371 PLDD Drainage Master Plan Update NO Citywide High 66231 PLDA 66232 PLDB 66233 PLDC 66234 PLDD El Camino Real and Agua Hedionda Creek Bridge Railing and Sidewalk NO 2 CriƟcal 60561 IRF El Camino Real and Cannon Road IntersecƟon Improvements NO 2 CriƟcal 60421 TIF 60422 GAS TAX El Camino Real and College Boulevard IntersecƟon Improvements NO 2 CriƟcal 60711 GAS TAX 60712 GCC El Camino Real Medians NO Citywide Low 36431 PFF 36432 GAS TAX El Camino Real Right Turn Lane to East Bound Alga Road NO 3 Low 19441 TIF El Camino Real Widening - Arenal Road to La Costa Avenue NO 4 High 60511 TIF El Camino Real Widening - Poinseƫa Lane to Camino Vida Roble NO 2 CriƟcal 60721 TRANSNET-LOC 60722 FED GRNT El Camino Real Widening - Sunny Creek to Jackspar NO 2 CriƟcal 60941 TRANSNET-LOC El Fuerte LiŌ StaƟon Pump AddiƟon NO 2 Medium 55531 SEWER CONN Emergency OperaƟons Center ReconfiguraƟon NO 2 Medium 47191 GCC 47192 IRF Encina Capital Projects NO Citywide CriƟcal 58011 SEWER REPL Faraday and El Camino Real Sewer Replacement - Orion to Palomar Airport ..NO 2 High 55391 SEWER CONN Faraday Avenue Improvements NO 2 High 60991 GCC Faraday Center Refurbishment NO 2 Medium 47201 IRF Fire AdministraƟon Offices NO 2 Medium 40891 GCC Fire Flow Capacity System Improvements NO 1 High 50431 WATER REPL Fire StaƟon No. 2 Replacement NO 4 High 40601 GCC 40602 IRF Fire StaƟon No. 6 RenovaƟon NO 4 Low 47511 IRF Fleet Fuel Island Upgrade NO 2 High 47471 IRF Fleet Maintenance Refurbishment NO 2 High 47141 IRF 47142 GCC Foxes Landing LiŌ StaƟon Wetwell and Pump Replacement NO 1 CriƟcal 55261 SEWER REPL Gas Tax Transfer to General Fund (TransportaƟon OperaƟng Budget)NO Citywide Null PA011 GAS TAX Grand Avenue Promenade Feasibility Study NO 1 Medium 40611 GCC Guardrail Replacement and Improvement Program NO Citywide Medium 60871 GAS TAX Harding Center Refurbishment NO 1 Low 47081 IRF Headwall Replacement Program NO 1 High 66241 IRF 216,512------25,000191,512 583,000------25,000558,000 171,890------25,000146,890 234,598-------234,598 210,000-------210,000 3,536,000-------3,536,000 837,000-------837,000 1,020,000-------1,020,000 131,000-------131,000 695,780-------695,780 904,530-------904,530 438,000-438,000------ 9,260,000-----6,010,000-3,250,000 3,155,000------50,0003,105,000 1,440,000-------1,440,000 5,010,000------1,010,0004,000,000 830,000-----650,000-180,000 1,658,000-------1,658,000 700,000------500,000200,000 #########39,174,60042,644,0007,757,2008,002,5008,450,0006,957,0006,367,80048,823,301 1,740,000------1,600,000140,000 100,000-------100,000 3,154,380-------3,154,380 150,000-------150,000 2,174,000----264,0001,700,000-1,500,0001,710,000 13,000,000-------13,000,000 1,433,882-------1,433,882 35,000-------35,000 3,363,800--100,000400,000400,000200,000500,0001,763,800 2,574,000------500,0002,074,000 896,100-------896,100 6,392,000------700,0005,692,000 9,000,0003,000,0003,000,000600,000600,000600,000600,000600,000- 800,000-----600,000200,000- 300,000-------300,000 305,000-----140,000-165,000 15-year Capital Improvement Program June 14, 2022 Item #7 Page 161 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding Source Harding Center Refurbishment NO 1 Low 47081 IRF Headwall Replacement Program NO 1 High 66241 IRF Hosp Grove Park Improvements NO 1 Low 47281 IRF 47282 PIL-NW Hydroelectric GeneraƟon at Water FaciliƟes NO 2 Medium 50591 WATER CONN Intelligent Traffic Control Devices NO Citywide Low 66341 GAS TAX Kelly Drive and Park Drive Complete Street Improvements NO 1 High 60751 TRANSNET-LOC 60753 GAS TAX 60754 PFF Kelly Drive Channel Repair NO 1 Medium 66061 IRF La Costa Avenue Traffic Improvements NO 4 Medium 60761 GAS TAX Laguna Drive Storm Drain NO 1 Medium 66281 GAS TAX Lake Calavera Outlet Improvements NO 2 CriƟcal 50541 GCC Lake Calavera Reservoir Maintenance NO 2 High 50492 GCC Las Palmas Roof Replacement NO 2 Medium 47521 IRF Las Palmas Trunk Sewer NO 2 High 55401 SEWER CONN LeŌ Turn Lane Extensions NO 3,4 High 60771 GAS TAX Leo Carrillo Ranch Park Phase 3B YES 3 Medium 23071 PIL-SE Leo Carrillo Ranch Roof Repairs NO 3 High 47481 IRF Library Fire Alarm Panel Upgrades NO 1,3 Low 47411 IRF Limited Access Pipeline RelocaƟon Program NO 1,3 CriƟcal 50351 WATER REPL Loan Repay - Park-in-Lieu NE to Public Facility Fee Fund NO Null Null PA041 PIL-NE Loan Repay - Park-in-Lieu SW to Public Facility Fee Fund NO Null Null PA021 PIL-SW Loan Repay - Sewer Conn to Sewer Repl NO Null Null PA031 SEWER CONN Maerkle Facility Improvements NO 2 CriƟcal 50091 WATER REPL Maerkle Reservoir FloaƟng Cover Replacement NO 2 CriƟcal 50361 WATER REPL Maerkle Reservoir Solar Project NO 2 Medium 47221 WATER REPL Maerkle Reservoir Transmission Main NO 2 Medium 50011 WATER REPL Marca Place Drainage Improvements NO 4 Medium 66141 GAS TAX Melrose Drive Right Turn Lane to West Bound Palomar Airport Road NO 2 CriƟcal 60341 TIF Miscellaneous City Building ImprovementsNO Citywide Medium 47231 IRF Monroe Street Pool Replacement NO 1 High 47241 IRF 47242 GCC 47243 PIL-NW New Village Arts Building Roof and Exterior Refurbishment NO 1 Low 47391 IRF New Village Arts Tenant Improvements NO 1 Medium 47551 GCC Normally Closed Valve (Install Motorized Valve)NO 3 High 50501 WATER REPL North BaƟquitos Access Road Improvement NO 4 High 55471 SEWER REPL 510,000-------510,000 1,562,000-------1,562,000 2,652,126----1,323,476208,6501,000,000120,000 1,853,000-----1,425,00028,000400,000 200,000-------200,000 4,675,000------500,0004,175,000 130,000-------130,000 1,085,000-------1,085,000 3,441,000-----1,900,000500,0001,041,000 863,000-----741,700-121,300 2,750,000-1,494,000-1,000,000---256,000 1,436,001-------1,436,001 1,351,001250,000250,00050,00050,000120,00050,00050,000531,001 500,000-------500,000 3,463,000-----2,907,000-556,000 800,000---150,000150,000150,000150,000200,000 2,400,000--1,400,000500,000500,000--- 1,450,000-------1,450,000 180,000-------180,000 4,940,000----1,000,0002,000,000-1,940,000 4,550,0004,550,000------- 1,100,0001,100,000------- 4,700,0004,700,000------- 2,735,200------500,0002,235,200 11,032,844-------11,032,844 250,000------249,170830 6,330,000----4,557,0001,000,000-773,000 65,000-------65,000 911,000-------911,000 3,665,000750,000750,000--150,000150,000150,0001,715,000 2,657,747-----908,983-4,438,2366,187,000 236-------61,76462,000 3,061,764-----1,500,0001,561,764- 313,626-------313,626 613,000-------613,000 985,000------500,000485,000 15-year Capital Improvement Program June 14, 2022 Item #7 Page 162 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding SourceNormally Closed Valve (Install Motorized Valve)NO 3 High 50501 WATER REPL North BaƟquitos Access Road Improvement NO 4 High 55471 SEWER REPL North BaƟquitos LiŌ StaƟon Forcemain RehabilitaƟon NO 4 High 55361 SEWER REPL Ocean Street ReconfiguraƟon Concepts Study NO 1 Medium 60781 GCC Ocean Street Restroom Facility NO 1 Medium 47291 GCC Odor and Corrosion PrevenƟon Assessment NO Citywide Medium 55201 SEWER REPL Open Space and Trail AcquisiƟon (Prop C) NO Citywide High 40831 GCC Orion Center NO 2 High 35721 CFD#1 35722 WATER REPL 35723 SEWER REPL 35724 CFD#1 35725 RECL REPL Orion Complex Energy Storage YES 2 Medium 23101 GCC Palomar Airport Road and Avenida Encinas Growth Management Plan Improvements NO 2,3 High 61021 GAS TAX Palomar Airport Road and College Boulevard Improvements NO 2 CriƟcal 60281 TIF Palomar Airport Road/Paseo Del Norte Right Turn Lane NO Citywide High 60441 GAS TAX 60442 TRANSNET-LOC Palomar Airport Waterline Realignment NO 2 CriƟcal 50551 WATER REPL Park Drive Street and Drainage Improvement NO 1 CriƟcal 66111 GCC 66112 GAS TAX Parking Lot Maintenance Program NO 1 High 60521 IRF Pavement Management Program NO Citywide High 60011 TRANSNET-LOC 60012 GAS TAX 60013 TRANSNET-LOC 60016 RMRA Poinseƫa Community Park - Phase 4 - Dog Park NO 3 High 46081 PFF 46082 PFF Poinseƫa Lane - Cassia Road to Skimmer Court (Reimbursement Agreement)NO 3 Medium 50451 WATER CONN Poinseƫa Lane - Reach E Cassia Road to Skimmer Court NO 3 High 39221 BTD#2 Poinseƫa Lane - Reaches A,B,C,F,G and Aviara Parkway Reimbursement NO 2 High 19591 BTD#2 Poinseƫa LiŌ StaƟon RehabilitaƟon YES 2 High 23041 SEWER REPL Police and Fire Headquarters RenovaƟon NO 2 High 47151 IRF 47152 GCC Pressure Reducing StaƟon Program NO Citywide CriƟcal 50201 WATER REPL Rancho Carlsbad Groundwater Supply NO 2 Low 50611 WATER CONN 50612 WATER REPL Rancho Santa Fe Trail Slope ImprovementsNO 4 High 60881 GCC Recycled Water CondiƟon Assessment Program NO Citywide High 52111 RECL REPL 363,800------113,800250,000 200,000-------750,000950,000 200,000-----200,000-- 834,355---59,355---775,000 320,000-------320,000 4,015,000-------4,015,000 35,257,727-------35,257,727 6,789,409-------6,789,409 4,078,500-------4,078,500 429-------429 2,715,600-------2,715,600 250,000--250,000----- 230,000-------230,000 1,295,500-------1,295,500 320,538-------110,000430,538 917,482-------8,157925,639 2,310,000------560,0001,750,000 717,439-------717,439 3,965,000------1,030,0002,935,000 2,920,000475,000475,00060,000130,00060,000130,00060,0001,530,000 41,786,5638,250,0008,250,0001,650,0001,650,0001,650,0001,150,000-19,186,563 7,930,850-------7,930,850 29,646,4764,750,0004,750,000950,000950,000950,000950,0002,200,00014,146,476 43,936,00012,000,00012,000,0002,400,0002,400,0002,400,0002,400,0002,300,0008,036,000 2,838,140-------2,838,140 --------- 600,000-------600,000 14,081,200-------14,081,200 1,168,8331,168,833------- 2,500,000-----2,500,000-- 9,993,050-------9,993,050 10,973,500-------10,973,500 13,062,0003,000,0003,000,000600,000600,000600,000600,000600,0004,062,000 1,750,000-1,425,000-125,000---200,000 1,750,000-1,425,000-125,000---200,000 350,000-------350,000 15-year Capital Improvement Program June 14, 2022 Item #7 Page 163 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding Source Rancho Santa Fe Trail Slope ImprovementsNO 4 High 60881 GCC Recycled Water CondiƟon Assessment Program NO Citywide High 52111 RECL REPL Recycled Water Phase 3 - Reservoir NO 3 High 52101 WATER REPL 52102 RECL WATER Recycled Water Pipeline Replacement NO 2 Medium 19541 RECL REPL Recycled Water Valve and Appurtenance Replacement Program NO Citywide High 52121 RECL REPL Reservoir Repair and Maintenance Program NO Citywide High 50241 WATER REPL RetroreflecƟvity Sign Replacement Program NO Citywide Medium 60371 GAS TAX Roadway Improvements - Coastal Area Analysis and ImplementaƟon NO Citywide Medium 60791 GCC Roadway Slope StabilizaƟon NO 2 High 60811 GAS TAX Robertson Ranch Park Development (ParƟal Funding)NO 2 Medium 38011 PIL-NE 38012 PFF Romeria Drainage Improvements NO 4 High 66041 GCC 66042 GAS TAX Safety Training Center SeƩlement NO 2 Low 47431 GCC San Luis Rey Mission Basin Groundwater Supply NO Citywide Low 50441 WATER CONN 50442 WATER REPL Santa Fe II Inlet Pipeline NO Null High 50571 WATER REPL Santa Fe II Reservoir Site Electrical Improvements NO 3 Medium 50461 WATER REPL SCADA Improvements NO Citywide CriƟcal 55421 SEWER REPL 55422 WATER REPL 55423 RECL REPL Schulman Auditorium and Cannon Art Gallery NO 3 Medium 47531 IRF Senior Center Refurbishment NO 1 Medium 47381 IRF Senior Center Security Fencing NO 1 Low 47541 IRF Sewer CondiƟon Assessment NO Citywide CriƟcal 55131 SEWER REPL Sewer LiŌ StaƟon Repairs and Upgrades NO 2 CriƟcal 38401 SEWER REPL Sewer Line Capacity Improvements NO 1 High 55481 SEWER REPL Sewer Modeling NO Citywide Medium 55461 SEWER CONN Sewer Monitoring Program (Capacity) NO Citywide High 55041 SEWER CONN Sewer System RehabilitaƟon and Replacement NO 1,2,3 High 55031 SEWER REPL Sidewalk/Street ConstrucƟon Program NO 1,2 High 60021 TIF 60022 GAS TAX South Carlsbad Coastline NO 2,3,4 Medium 60311 TRANSNET-LOC South Shore Agua Hedionda Lagoon Trail NO 2 High 40851 GCC Stagecoach Community Park Community Gardens YES 4 Medium 23021 PIL-SE State Street and Grand Avenue Road Improvements NO 1 Medium 60821 TRANSNET- LOC State Street Parking Lot Electric Vehicle Charging StaƟons NO 1 Medium 40901 PFF 1,540,000310,000280,00050,00050,00050,00050,00050,000700,000 980,000-------980,000 3,320,000------200,0003,120,000 6,460,0002,910,0002,150,000350,000350,000350,000350,000-- 2,080,000700,000630,000125,000125,000120,000-120,000260,000 14,490,0003,610,0003,070,000---1,960,000-5,850,000 1,000,000-------1,000,000 200,000-------200,000 1,280,000-----500,000200,000580,000 3,635,500----2,621,500400,000214,000400,000 13,473,440----13,473,440--- 410,000-------410,000 347,940-------347,940 1,156,995-------1,156,995 8,280,0002,500,0005,500,000280,000----277,500277,500 6,080,000-6,000,00080,000----77,50077,500 3,029,650----2,500,000-34,650495,000 183,581------150,00033,581 4,684,632-----380,734175,1654,128,733 10,155,600----610,5002,412,5003,209,2003,923,400 2,394,000----398,000337,600631,5001,026,900 350,000------150,000200,000 1,848,000------600,0001,248,000 78,000------58,00020,000 3,358,000750,000750,000-100,000100,000100,000100,0001,458,000 6,485,380750,000750,000150,000150,000150,000150,000150,0004,235,380 3,000,000-----1,800,0001,000,000200,000 300,000-------300,000 950,000110,000154,000--44,000--642,000 43,576,47514,050,00013,350,0001,850,0001,850,0001,850,0001,200,0001,200,0008,226,475 8,953,0002,835,000890,000107,500333,000987,500--3,800,000 1,800,000-1,500,000-300,000---- 2,779,026-----1,000,000-1,779,026 789,940------34,440755,500 425,000-----200,000225,000- 325,000---325,000---- 15-year Capital Improvement Program June 14, 2022 Item #7 Page 164 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding SourceState Street and Grand Avenue Road Improvements NO 1 Medium 60821 TRANSNET- LOC State Street Parking Lot Electric Vehicle Charging StaƟons NO 1 Medium 40901 PFF Storm Drain CondiƟon Assessment NO Citywide High 66201 IRF Storm Drain System Rehab and Repair Program NO 1,2,3 High 66071 IRF Street LighƟng Replacement Program NO Citywide High 60621 GCC 60622 TRANSNET-LOC Sustainable Mobility Plan ImplementaƟon Program NO Citywide High 23091 GAS TAX Temporary Fire StaƟon No. 7 NO 2 High 40911 GCC 40912 PFF Terramar Area Coastal Improvements NO 2 High 60541 TIF 60542 GCC 60543 TRANSNET-LOC 60544 SEWER REPL 60545 PFF The Crossings Golf Course Lake Liner Replacement NO 2 High 40841 GCC 40842 GCC Traffic Control Improvements - Poinseƫa Lane and Cassia Road NO Citywide High 63292 GAS TAX Traffic Control Improvements - Poinseƫa Lane and Oriole Court NO 3 High 63302 GAS TAX Traffic Impact Fee Funds to CFD #1 NO Null Null PA051 TIF Traffic Impact Fee Update NO Citywide High 60401 TIF Traffic Improvement Program NO 1,2,4 CriƟcal 60701 GAS TAX 60702 GCC Traffic Monitoring Program NO Citywide High 60031 TIF Traffic Signal - Maverick Way and Camino De Los Coches NO 4 CriƟcal 63322 GAS TAX Traffic Signal - Tamarack Avenue and Valley Street NO 1 Medium 63351 GAS TAX Traffic Signal OperaƟons ModificaƟons NO 2 Medium 63271 GAS TAX Traffic Signal Right Turn Overlaps YES 2,3,4 Low 23051 GAS TAX Trail ConnecƟvity to Tamarack State Beach (Prop C)NO 1 Low 40631 GCC Trash Amendment Compliance Program NO 1,2,3 Medium 66261 IRF Tri-Agency Water Transmission Pipeline Replacement NO 2 High 50081 WATER REPL Tyler Street Traffic CirculaƟon Study NO 1 Medium 23081 GCC UƟlity Undergrounding Program Study NO Citywide Medium 60831 GCC Vallecitos Interceptor Sewer Cleaning and CCTV NO 2,3 CriƟcal 55491 SEWER REPL Valley and Magnolia Complete Streets NO 1 High 60191 TIF 60192 WATER REPL 60193 TRANSNET- LOC Valley Street Traffic Calming NO 1 Medium 19741 TRANSNET- LOC Veteran's Memorial Park (All Quadrants) NO 2 CriƟcal 46091 CFD#1 300,000-------300,000 7,692,5003,002,5002,375,000420,000375,000350,000300,000270,000600,000 10,253,8602,140,0001,822,500300,000300,000250,000250,000200,0004,991,360 319,269-------319,269 3,325,000-------3,325,000 1,020,566-----510,000510,566- 900,000-------900,000 922,000------922,000- 9,450,001----2,800,000--6,650,001 999,999-------999,999 2,000,000-----1,000,000-1,000,000 --------- 2,450,000-------2,450,000 835,500-------835,500 200,000-------200,000 411,000-------411,000 411,000-------411,000 1,854,0001,404,00090,000-90,00090,00090,00090,000- 270,000------30,000240,000 2,388,000-------2,388,000 1,200,000----400,000400,000400,000- 1,745,416------122,5161,622,900 380,000------240,000140,000 502,370-------502,370 315,800------135,800180,000 150,000------150,000- 3,494,669---3,342,513---152,156 9,705,000-3,000,0002,000,000175,0002,700,0001,200,000100,000530,000 6,455,000----1,836,0301,000,000-3,618,970 70,000------70,000- 100,000-----100,000-- 350,000------100,000250,000 4,536,206---1,000,000---3,536,206 71,000-------71,000 1,200,000------1,200,000- 1,645,000---1,645,000---- 15-year Capital Improvement Program June 14, 2022 Item #7 Page 165 of 454 Project Name NewProject District Score FundingID Funding Source PriorAppropriaƟon Year 1(2022-23)Year 2(2023-24)Year 3(2024-25)Year 4(2025-26)Year 5(2026-27)Year 6-10 (2028-32)Year 11-15 (2033-37)Total Funding Source Valley Street Traffic Calming NO 1 Medium 19741 TRANSNET- LOC Veteran's Memorial Park (All Quadrants) NO 2 CriƟcal 46091 CFD#1 Village and Barrio Traffic Circles NO 1 High 40151 GCC 40152 TRANSNET-LOC 40153 SEWER REPL 40154 GAS TAX Village DecoraƟve LighƟng - Carlsbad Village Drive from Harding Street to Ocea..YES 1 Medium 23111 GCC Village DecoraƟve LighƟng - Gateway LighƟng YES 1 Medium 23141 GCC Village DecoraƟve LighƟng - Hospitality District YES 1 Medium 23131 GCC Village DecoraƟve LighƟng - Pedestrian Lampposts Oak Avenue YES 1 Medium 23151 GCC Village DecoraƟve LighƟng - Pedestrian LighƟng at Village Outskirts YES 1 Medium 23161 GCC Village DecoraƟve LighƟng - State Street,Madison, Roosevelt, and Washington NO 1 Medium 40161 GCC Village DecoraƟve LighƟng - Train StaƟon Area YES 1 Medium 23121 GCC Village H South Off Leash Dog Area and Trail Segment 5B NO 2 Medium 46101 PFF Village Intelligent Parking ImplementaƟon NO 1 Low 60891 GCC Villas Sewer LiŌ StaƟon Replacement NO 2 CriƟcal 55501 SEWER REPL Vista Carlsbad Interceptor - Agua Hedionda LS and Forcemain (VC12-VC13)NO 2 CriƟcal 34921 SEWER CONN Vista Carlsbad Interceptor - Buena Vista LiŌ StaƟon Improvements NO 1 High 55351 SEWER CONN Vista Carlsbad Interceptor - Lagoon Bridge Replacement (VC11B)NO Citywide CriƟcal 38861 SEWER CONN Vista Carlsbad Interceptor - Reach VC3 NO 1 CriƟcal 39501 SEWER CONN Vista Carlsbad Interceptor - Reach VC14 To VC15 NO Citywide High 39491 SEWER CONN Vista Carlsbad Interceptor - RehabilitaƟon (VC1 and VC2)NO 2 CriƟcal 55511 SEWER REPL Vista/Carlsbad Interceptor - Point Repair Reaches (VC13 & VC14)YES 2,3 High 23061 SEWER REPL Water Infrastructure CondiƟon Assessment Program NO Citywide CriƟcal 50511 WATER REPL Water Loss Monitoring Program NO Citywide High 50521 WATER REPL Water Modeling NO Citywide CriƟcal 50581 WATER CONN Water System RehabilitaƟon and Replacement NO Citywide CriƟcal 39041 WATER REPL Water Valve Repair/Replacement Program NO Citywide CriƟcal 50191 WATER REPL 30,257,650----24,630,9501,257,2501,257,2503,112,200 415,000-------415,000 1,025,000-------1,025,000 160,000-------160,000 4,159,000------1,400,0002,759,000 400,000------400,000- 900,000-----900,000-- 800,000-----800,000-- 450,000-----450,000-- 850,000-----850,000-- 1,103,853------400,000703,853 500,000------500,000- 2,003,201-----1,320,701160,500522,000 300,000---300,000---- 1,254,000------100,0001,154,000 33,190,972-------33,190,972 1,335,000----939,000100,000-100,000396,000 9,464,833-------9,464,833 480,000-----380,000-497,000597,000 21,362,390-------21,362,390 2,141,000----1,500,000500,000-141,000 1,400,000----600,000600,000200,000- 8,620,0002,480,0002,250,000450,000420,000420,000410,000410,0001,780,000 1,890,000550,000550,000110,000110,000110,000110,000-350,000 425,000----25,00025,00025,000350,000 65,028,36621,080,00019,890,0003,000,0003,000,0003,000,0002,800,0002,690,0009,568,366 22,500,0005,650,0005,110,0001,000,000960,000960,000960,000940,0006,920,000 15-year Capital Improvement Program June 14, 2022 Item #7 Page 166 of 454 Attachment C PERSONNEL ALLOCATIONS Adopted Adopted Adopted Final Proposed Budget Budget Budget Budget Budget Department 2019-20 2020-21 2021-22 2021-22 2022-23 City Attorney 8.00 8.00 8.00 8.00 8.00 City Clerk Services 7.00 7.00 7.00 7.00 7.00 City Council 2.00 2.00 2.00 2.00 2.00 City Manager 12.00 7.00 7.00 7.00 7.00 City Treasurer 1.00 1.00 1.00 1.00 1.00 Communication & Engagement 7.00 7.00 7.00 9.00 9.00 Administrative Services - Administration 0.00 0.00 3.00 3.00 3.00 Finance 31.00 31.00 28.00 28.00 26.00 Human Resources*17.00 17.00 17.00 18.00 18.00 Information Technology 35.00 37.00 37.00 37.00 43.00 Innovation & Economic Development 2.00 4.00 4.00 4.00 9.00 Community Services - Administration 0.00 3.00 3.00 3.00 3.00 Community Development 63.75 61.75 53.00 52.00 52.00 Housing & Homeless Services 0.00 0.00 14.00 15.00 16.00 Library & Cultural Arts 52.50 52.50 52.50 53.00 51.00 Parks & Recreation 55.00 55.00 55.00 55.00 59.00 Fire 97.75 97.75 111.00 112.00 123.00 Police 184.00 184.00 186.00 186.00 187.00 Public Works 172.75 172.75 177.75 182.75 182.75 Total Full-Time Personnel 747.75 747.75 773.25 782.75 806.75 Hourly Full-Time Equivalent Personnel 199.97 186.59 193.81 185.65 180.90 Total 947.72 934.34 967.06 968.40 987.65 *Includes Risk Management and Workers' Compensation Full-Time Personnel Notes: The adopted budgets for fiscal years 2019-20 to 2021-22 include various reorgnizations and personnel transfers between departments. The final budget for 2021-22 includes several changes approved mid-year, including the transfer of (1.0) FTE from Community Development to Housing & Homeless Services and (1.0) FTE from Utilities to Human Resources; addition of (6.0) FTE for Environmental Management and (1.0) FTE for Fire; and conversion of hourly FTE to add (0.50) FTE to Library & Cultural Arts and (2.0) FTE to Communications & Engagement. The proposed budget for 2022-23 includes reorganization of (9.0) FTE from various departments to Information Technology and (4.0) FTE from Information Technology to Innovation & Economic Development. June 14, 2022 Item #7 Page 167 of 454 H-42 FIVE-YEAR SCHEDULE OF PROJECTS BY FUND ConnectedRequestedEstimated Estimated Estimated Estimated EstimatedFundingCarlsbadFundingProject PriorYear 1 Year 2 Year 3 Year 4 Year 5TotalProject NameSourceGoalIDTypeAppropriation2022-23 2023-24 2024-25 2025-26 2026-27FundingTechnology Investment Capital FundAudio Visual UpgradesTICF FVCEC7000Major625,000$ 100,000$ 100,000$ 100,000$ 100,000$ 100,000$ 1,125,000$ Business Process AutomationTICFBCDDMNAMajor- 150,000 - - - - 150,000 Business Process DocumentationTICFPSSCNAMajor- 150,000 - -- -150,000 Civic Engagement with Open DataTICF EAT7017Major180,000 18,000 - - - - 198,000 Computer Aided Dispatch (CAD)TICFPSSC7018Major1,000,000 580,000 - -- -1,580,000 Consolidation & Replacement of Core SystemsTICFPCDT7009Major400,000 500,000 1,500,000 2,000,000 - - 4,400,000 Cyber Security Program DevelopmentTICFPSSC7012Major350,000 100,000 100,000 100,000 100,000 100,000 850,000 Data Governance and Operational AnalyticsTICFBCDDM7019Major295,000 110,000 100,000 - - - 505,000 Digital Engagement & Analytics ConsultantTICF FVCEC7008Major200,000 - - - -- 200,000 Digital Information NetworkTICFPCDT7007Major4,825,584 200,000 500,000 500,000 - - 6,025,584 Discovery Management AssessmentTICFBCDDM7020Major30,000 - 140,000 - - - 170,000 Electronic Patient Care ReportingTICFPSSCNAMajor- 50,000 - - - - 50,000 Enterprise Asset Management SystemTICFPCDT7013Major1,100,000 500,000 - -- -1,600,000 Enterprise Digital Asset ManagementTICF EAT7022Major50,000 350,000 - - - - 400,000 Exploration Hub Audio Visual UpgradeTICF EAT7023Major41,852 - - - - - 41,852 Facility Security Master PlanTICFPSSC7003Major100,000 100,000 100,000 100,000 - - 400,000 Live 911TICFPSSCNAMajor- 66,380 - - - -66,380 Next Generation Online CatalogTICF EAT7024Major40,000 - - - - - 40,000 Online Permitting/Electronic Reviews (E-Reviews)TICF EAT7025Major645,000 - -- -- 645,000 Outdoor Wireless Study TICF FVCECNAMajor100,000 - - - - - 100,000 Patron Print/Copy ManagementTICF EATNAMajor- 18,000 70,000 - -- 88,000 Professional Technical Services for Data Project DeliveryTICFBCDDMNAMajor- 70,000 70,000 70,000 70,000 70,000 350,000 Project Portfolio Management Tool & ConsultingTICFPCDT7004Major500,000 - - - - - 500,000 ServiceNow SAM ImplementationTICFPCDT7015Major150,000 (150,000) - - - - - ServiceNow Service PortalTICFPCDT7016Major150,000 - - - - - 150,000 Timekeeping System UpgradeTICFPCDTNAMajor- 95,000 - - - - 95,000 Virtual Permitting Counter (OpenCounter)TICF EAT7026Major61,000 - 23,000 - - - 84,000 Global Positioning System (GPS) Technology HardwareTICFPCDTNAMinor45,916 - - - -- 45,916 Technology Investment Capital Fund Total10,889,352 3,007,380 2,703,000 2,870,000 270,000 270,000 20,009,732 Information Technology Replacement FundAnnual Hardware and Infrastructure ReplacementITRFPSSCNAMajor1,102,635 790,000 1,030,000 1,485,000 1,110,000 1,050,000 6,567,635 Utilities Enterprise Funds (Operating or Capital)Meter Data Management/Utility AnalyticsUEFBCDDMNAMajor- - 550,000 - - - 550,000 Regulatory Water Usage Analytics (Operating Funds)UEFBCDDMNAMajor- 50,000 50,000 Utility Billing AutomationUEFPCDTNAMajor- 75,000 75,000 Utility Billing PortalUEFPCDTNAMajor- 90,000 90,000 Total Utilities Enterprise Funds (Operating or Capital)- 140,000 625,000 - - - 765,000 11,991,987$ 3,937,380$ 4,358,000$ 4,355,000$ 1,380,000$ 1,320,000$ 27,342,367$ Connected Carlsbad Goal AbbreviationsBuild Capacity for Data-driven Decision Making = BCDDMEnhance Accessibility and Transparency = EATFoster a Vibrant Civic Engagement Culture = FVCECPromote Security and Sustainability through Connectivity = PSSCPursue Communitywide Digital Transformation = PCDTConnected Carlsbad GoalProjectsTotalAttachment D June 14, 2022 Item #7 Page 168 of 454