Loading...
HomeMy WebLinkAbout2021-06-08; City Council; Resolution 2021-132RESOLUTION NO. 2021-132 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 2021-22 FOR THE CITY OF CARLSBAD AND ESTABLISHING CONTROLS ON CHANGES IN APPROPRIATIONS FOR BUDGET FUNDS 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) 2021-22 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 2021-22 Preliminary Operating Budget, Strategic Digital Transformation Investment Program and Capital Improvement Program," presented at the regular City Council meeting on May 18, 2021 as Exhibit 2 to Item No. 8, as amended, if necessary, in accordance with Attachments A through D attached and incorporated by reference, are adopted as the final Operating, Strategic Digital Transformation Investment Program and Capital Improvement Program Budgets for the City of Carlsbad for FY 2021-22 along with the program options and adjustments, if any, determined by the City Council as set forth in the minutes of the City Council meeting of Tuesday, June 8, 2021. 3.That the amounts reflected as estimated revenues for FY 2021-22 as shown in Attachments A, B and D are adopted as the budgeted revenues for FY 2021-22_ 4.That the amounts as designated as the FY 2021-22 Budget request in Attachments A, B 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 8, 2021 Item #11 Page 133 of 336 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 Police, Community Development and the new Housing & Homeless Services departments within the General Fund. 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 the transfer of appropriations between accounts and/or capital projects up to $1,000,000 for the costs associated with the Encina Wastewater Facility (Encina) as authorized by the Encina Wastewater Authority's staff and/or Board. Any increase to the total appropriations for Encina's operating budget and capital program must be approved by the City Council. vi.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. vii.The City Manager may authorize budget adjustments to increase the appropriation for unforeseen legal expenses and liabilities. June 8, 2021 Item #11 Page 134 of 336 viii.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. ix.The City Council must authorize all transfers of funds from the City Council's Contingency Account. x.The City Manager may delegate any of the authority given to him or her under this resolution. 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, 2021, are appropriated to FY 2021-22 in their respective project budgets. 10.That all appropriations in the Strategic Digital Transformation Investment Program remaining unexpended at June 30, 2021, are appropriated to FY 2021-22 in their respective Innovation Fund or project budgets. 11.That all appropriations in the Operating Budget remaining unexpended at June 30, 2021 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 2021-22. 12.That all appropriations for outstanding encumbrances as of June 30, 2021, are continued into FY 2021-22 for such contracts or obligations. June 8, 2021 Item #11 Page 135 of 336 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 8th day of June, 2021, by the following vote, to wit: AYES: Hall, Blackburn, Acosta, Bhat-Patel, Schumacher. NAYS: None. ABSENT: None. MATT HALL, Mayor ,..10C-Arri.D-ervalf-)p BARBARA ENGLESON, City Clerk (SEAL) 011‘111111111111/4/ ;*. . -- .' June 8, 2021 Item #11 Page 136 of 336 SCHEDULE OF PROJECTED FUND BALANCES Projected Beginning Additional Ending Fund Balance Projected Projected CalPERS Advance Fund Balance Fund July 1, 2020 Revenues Expenditures Payment Repayment June 30, 2021 General Fund $98,985,748 * $172,734,000 $164,540,132 $8,557,922 2,680,000   $101,301,694 Special Revenue Funds   Affordable Housing 23,224,748 1,204,279 5,034,346 7,558 19,387,123   Agricultural Mitigation Fee 1,019,025 14,000 0 0 1,033,025   Buena Vista Channel Maintenance District 1,441,925 125,800 116,298 0 1,451,427   Citizen's Option for Public Safety 274,441 184,318 200,000 16,877 241,882   Community Activity Grants 1,123,096 15,000 0 0 1,138,096   Community Development Block Grant 0 1,551,030 1,428,953 3,972 118,105   Cultural Arts Donations 304,339 61,067 122,385 0 243,021   Flower Fields Grant Program 0 0 0 0 0   Habitat Mitigation Fee 0 16,230 0 0 16,230   Library and Arts Endowments 270,342 2,244 6,000 0 266,586   Library Gifts and Bequests 1,548,903 253,995 426,910 0 1,375,988   Lighting and Landscaping District No. 2 4,229,025 694,000 375,750 0 4,547,275   Local Cable Infrastructure 974,683 296,000 351,000 0 919,683   Median Maintenance District 70,953 1,050,000 1,005,000 21,490 94,463   Parking In Lieu Fee 1,201,155 17,064 50,000 0 1,168,219   Police Asset Forfeiture 308,232 7,000 65,000 0 250,232   Public Safety Grants 0 233,939 233,939 0 0   Recreation Donations 301,859 8,235 37,957 0 272,137   Rental Assistance 131,180 8,900,124 8,510,000 39,196 482,108   Senior Donations 338,015 11,000 13,200 0 335,815   Street Lighting Maintenance District 2,786,452 924,266 685,000 15,774 3,009,944   Street Tree Maintenance District 438,375 465,000 625,000 21,999 256,376   Tyler Court Apartments 198,339 602,512 430,000 0 370,851 Total Special Revenue Funds 40,185,086 16,637,103 19,716,738 126,866 36,978,585 Enterprise Funds   Water Operations 29,204,183 44,523,102 46,126,865 288,986 27,311,434   Recycled Water Operations 6,447,797 7,972,071 10,333,658 132,151 3,954,059   Wastewater Operations 9,040,711 13,683,128 15,235,755 190,186 7,297,898   Solid Waste Management 14,707,512 3,920,818 4,498,833 128,504 14,000,993   Golf Course 985,074 7,792,122 6,340,807 0 2,436,389 Total Enterprise Funds 60,385,276 77,891,241 82,535,918 739,827 55,000,772 Internal Service Funds   Workers' Compensation 4,650,061 3,905,093 1,950,000 8,347 6,596,807   Risk Management 2,823,391 2,422,410 3,048,468 22,496 2,174,837   Self‐Insured Benefits 1,834,163 0 1,834,163 0 0   Vehicle Maintenance 1,078,108 3,516,342 2,782,841 87,661 1,723,948   Vehicle Replacement 17,492,025 2,680,007 795,000 0 19,377,032   Information Technology 10,257,801 12,535,451 15,600,562 456,881 6,735,809 Total Internal Service Funds 38,135,550 25,059,303 26,011,034 575,385 36,608,434 Successor Agency Housing Trust Fund 2,082,371 4,127,400 1,049,406 0 (2,680,000) 2,480,365 Total Operating Funds $239,774,031 $296,449,047 $293,853,228 $10,000,000 $0 $232,369,850 *For the General Fund only, this represents unassigned fund balance.  Attachment A June 8, 2021 Item #11 Page 137 of 336    SCHEDULE OF PROJECTED FUND BALANCES   Projected Beginning Ending Fund Balance Estimated Adopted Fund Balance Fund June 30, 2021 Revenues Budget June 30, 2022 General Fund $101,301,694 * $178,813,062 $184,407,489 $95,707,267 * Special Revenue Funds   Affordable Housing 19,387,123 515,000 811,197 19,090,926   Agricultural Mitigation Fee 1,033,025 15,000 0 1,048,025   Buena Vista Channel Maintenance District 1,451,427 120,000 195,245 1,376,182   Citizen's Option for Public Safety 241,882 187,000 266,106 162,776   Community Activity Grants 1,138,096 15,000 30,000 1,123,096   Community Development Block Grant 118,105 520,500 638,299 306   Cultural Arts Donations 243,021 46,200 131,750 157,471   Flower Fields Grant Program 0 0 0 0   Habitat Mitigation Fee 16,230 15,000 0 31,230   Library and Arts Endowments 266,586 3,000 6,000 263,586   Library Gifts and Bequests 1,375,988 178,100 384,270 1,169,818   Lighting and Landscaping District No. 2 4,547,275 702,300 376,001 4,873,574   Local Cable Infrastructure 919,683 295,000 345,000 869,683   Median Maintenance District 94,463 1,315,000 1,369,415 40,048   Parking In Lieu Fee 1,168,219 15,358 50,000 1,133,577   Police Asset Forfeiture 250,232 16,000 170,000 96,232   Public Safety Grants 0 0 0 0   Recreation Donations 272,137 86,223 82,591 275,769   Rental Assistance 482,108 7,548,000 7,898,443 131,665   Senior Donations 335,815 20,000 79,600 276,215   Street Lighting Maintenance District 3,009,944 916,051 971,246 2,954,749   Street Tree Maintenance District 256,376 710,000 943,555 22,821   Tyler Court Apartments 370,851 644,400 640,987 374,264 Total Special Revenue Funds 36,978,585 13,883,132 15,389,705 35,472,012 Enterprise Funds   Water Operations 27,311,434 45,466,455 47,821,220 24,956,669   Recycled Water Operations 3,954,059 8,072,846 10,103,790 1,923,115   Wastewater Operations 7,297,898 13,963,861 16,057,473 5,204,286   Solid Waste Management 14,000,993 4,069,427 5,183,474 12,886,946   Golf Course 2,436,389 7,539,000 7,231,000 2,744,389 Total Enterprise Funds 55,000,772 79,111,589 86,396,957 47,715,404 Internal Service Funds   Workers' Compensation 6,596,807 4,754,730 3,933,699 7,417,838   Risk Management 2,174,837 3,401,080 3,207,702 2,368,215   Self‐Insured Benefits 0 0 0 0   Vehicle Maintenance 1,723,948 3,340,562 3,516,373 1,548,137   Vehicle Replacement 19,377,032 4,311,885 4,546,033 19,142,884   Information Technology 6,735,809 14,860,389 14,369,778 7,226,420 Total Internal Service Funds 36,608,434 30,668,646 29,573,585 37,703,495 Successor Agency Housing Trust Fund 2,480,365 1,078,000 1,067,495 2,490,870 Total Operating Funds $232,369,850 $303,554,429 $316,835,231 $219,089,048 *  For the General Fund only, this represents unassigned fund balance.  June 8, 2021 Item #11 Page 138 of 336 SCHEDULE OF REVENUE ESTIMATES 2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 General Fund Taxes    Property Tax $72,289,510 $75,211,000 $76,587,000 1.8% $1,376,000    Sales Tax 37,584,621    39,840,000        44,015,000           10.5% 4,175,000            Transient Occupancy Tax 18,898,325    12,585,000        18,441,000           46.5% 5,856,000            Franchise Tax 5,863,614      5,724,000          5,666,000   ‐1.0%(58,000)                Business License Tax 5,414,292      5,550,000          5,817,000   4.8%267,000               Transfer Tax 1,247,218      1,260,000          1,285,000   2.0%25,000    Total Taxes 141,297,580 140,170,000 151,811,000 8.3% 11,641,000 Intergovernmental    Homeowners Exemption 358,819         350,000  350,000      0.0%‐              Other Intergovernmental 2,998,306      9,370,000          7,223,975   ‐22.9% (2,146,025)       Total Intergovernmental 3,357,125 9,720,000 7,573,975 ‐22.1% (2,146,025) Licenses and Permits    Building Permits 1,445,892      1,011,000          521,000      ‐48.5% (490,000)              Other Licenses and Permits 1,293,657      904,000  944,000      4.4%40,000    Total Licenses And Permits 2,739,549 1,915,000 1,465,000 ‐23.5% (450,000) Charges for Services    Planning Fees 356,382         249,000  274,000      10.0%25,000       Building Department Fees 956,138         668,000  617,000      ‐7.6%(51,000)                Engineering Fees 620,302         434,000  441,000      1.6%7,000         Ambulance Fees 2,752,261      2,521,000          2,584,000   2.5%63,000       Recreation Fees 2,093,196      1,425,000          1,760,000   23.5%335,000               Other Charges or Fees 709,034         1,109,000          550,000      ‐50.4% (559,000)           Total Charges For Services 7,487,313 6,406,000 6,226,000 ‐2.8% (180,000) Fines and Forfeitures 522,814     396,000        406,000           2.5%10,000          Income from Investments and Property 11,978,846          7,517,000     4,879,925        ‐35.1% (2,637,075)   Interdepartmental Charges 5,047,596  5,052,000     5,181,349        2.6%129,349        Other Revenue Sources 1,711,070  1,558,000     1,269,813        ‐18.5% (288,187)       Total General Fund $174,141,893 $172,734,000 $178,813,062 3.5% $6,079,062 * Interest is calculated on an amortized cost basis. Attachment A2 June 8, 2021 Item #11 Page 139 of 336    SCHEDULE OF REVENUE ESTIMATES                2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 Special Revenue Funds Affordable Housing    Affordable Housing Fees $537,168 $248,000 $140,000 ‐43.6% ($108,000)    Property Tax 762,948                   520,000                   ‐                            ‐100.0% (520,000)                    Interest Income 877,998                   406,279                   345,000                   ‐15.1%(61,279)                      Other Revenue 78,553                      30,000                      30,000                      0.0%0 Total Affordable Housing 2,256,667 1,204,279 515,000 ‐57.2% (689,279) Agricultural Mitigation Fee    Agricultural Mitigation Fees 227,552                   ‐                            ‐                            0.0%‐                              Interest Income 31,969                      14,000                      15,000                      7.1%1,000                      Total Agriculutural Mitigation Fee 259,521 14,000 15,000 7.1%1,000 Buena Vista Channel Maintenance    Assessment Fees 70,510                      105,000                   100,000                   ‐4.8%(5,000)                        Interest Income 48,684                      20,800                      20,000                      ‐3.9%(800)                        Total Buena Vista Channel Maintenance 119,194 125,800 120,000 ‐4.6%(5,800) Citizen's Option for Public Safety    State Funding (AB3229)256,588                   182,318                   185,000                   1.5%2,682                         Interest Income 9,389                        2,000                        2,000                        0.0%‐                           Total Citizen'S Option For Public Safety 265,977 184,318 187,000 1.5%2,682 Community Activity Grants    Interest Income 37,980                      15,000                      15,000                      0.0%‐                           Total Community Activity Grants 37,980 15,000 15,000 0.0%0 Community Development Block Grant    Federal Grant 742,101                   1,551,030                520,000                   ‐66.5% (1,031,030)                Interest Income 1,135                        ‐                            500                           0.0%500                             Other Revenue 216,218                   ‐                            ‐                            0.0%‐                           Total Community Dev. Block Grant 959,454 1,551,030 520,500 ‐66.4% (1,030,530) Cultural Arts Donations    Donations 58,828                      58,342                      43,000                      ‐26.3%(15,342)                      Interest Income 10,357                      2,725                        3,200                        17.4%475                             Other Revenue ‐                            ‐                            ‐                            0.0%‐                           Total Cultural Arts Donations 69,185 61,067 46,200 ‐24.4%(14,867) Flower Fields Grant Program    Interest Income 9,757                        ‐                            ‐                            0.0%‐                           Total Flower Fields Grant Program 9,757 0 0 0.0%0 Habitat Mitigation Fee    Mitigation Fees 29,071                      16,000                      15,000                      ‐6.3%(1,000)                        Interest Income 2,007                        230                           ‐                            ‐100.0%(230)                        Total Habitat Mitigation Fee 31,078 16,230 15,000 ‐7.6%(1,230) June 8, 2021 Item #11 Page 140 of 336 SCHEDULE OF REVENUE ESTIMATES       2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 Special Revenue Funds ‐ Continued Library And Arts Endowment Fund    Interest Income 9,143                        2,244                        3,000                        33.7%756                          Total Library And Arts Endowment Fund 9,143 2,244 3,000 33.7%756 Library Gifts/Bequests    Gifts and Bequests 339,291                   241,677                   164,000                   ‐32.1%(77,677)                      Interest Income 51,128                      12,318                      14,100                      14.5%1,782                         Other Revenue ‐                            ‐                            ‐                            0.0%‐                           Total Library Gifts/Bequests 390,419 253,995 178,100 ‐29.9%(75,895) Lighting And Landscaping District No. #2    Assessment Fees 625,925                   638,000                   648,300                   1.6%10,300                       Interest Income 139,771                   56,000                      54,000                      ‐3.6%(2,000)                        Other Revenue ‐                            ‐                            ‐                            0.0%‐                           Total Lighting And Landscaping Dist. No. #2 765,696 694,000 702,300 1.2%8,300 Local Cable Infrastructure Fund    Cable Fees 308,090                   285,000                   285,000                   0.0%‐                              Interest Income 30,810                      11,000                      10,000                      ‐9.1%(1,000)                     Total Local Cable Infrastructure Fund 338,900 296,000 295,000 ‐0.3%(1,000) Median Maintenance    Assessment Fees 351,656                   350,000                   365,000                   4.3%15,000                       Other 552,817                   700,000                   950,000                   35.7%250,000                  Total Median Maintenance 904,473 1,050,000 1,315,000 25.2%265,000 Parking In Lieu    Parking In Lieu Fees 147,180                   ‐                            ‐                            0.0%‐                              Interest Income 39,121                      17,064                      15,358                      ‐10.0%(1,706)                     Total Parking In Lieu 186,301 17,064 15,358 ‐10.0%(1,706) June 8, 2021 Item #11 Page 141 of 336    SCHEDULE OF REVENUE ESTIMATES       2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 Special Revenue Funds ‐ Continued Police Asset Forfeiture    Asset Forfeitures 237,478                   5,000                        14,000                      180.0%9,000                         Interest Income 11,733                      2,000                        2,000                        0.0%‐                           Total Police Asset Forfeiture 249,211 7,000 16,000 128.6%9,000 Public Safety Grants    Federal Grant 143,094                   233,939                   ‐                            ‐100.0% (233,939)                 Total Police Grants 143,094 233,939 0 ‐100.0% (233,939) Recreation Donations      Donations 45,364                      6,000                        82,000                      1266.7%76,000                       Interest Income 10,344                      2,235                        4,223                        89.0%1,988                      Total Recreation Donations 55,708 8,235 86,223 947.0%77,988 Rental Assistance    Federal Grant 7,496,947                8,644,524                7,480,000                ‐13.5% (1,164,524)                Other Revenue 178,430                   255,600                   68,000                      ‐73.4% (187,600)                 Total Rental Assistance 7,675,377 8,900,124 7,548,000 ‐15.2% (1,352,124) Senior Donations    Donations 4,917                        6,000                        6,000                        0.0%‐                              Interest Income 11,501                      5,000                        6,000                        20.0%1,000                         Other Revenue 8,103                        ‐                            8,000                        0.0%8,000                      Total Senior Donations 24,521 11,000 20,000 81.8%9,000 Street Lighting    Assessment Fees 733,743                   735,000                   740,000                   0.7%5,000                         Other Revenue 168,321                   154,266                   141,051                   ‐8.6%(13,215)                      Interest Income 94,699                      35,000                      35,000                      0.0%‐                           Total Street Lighting 996,763 924,266 916,051 ‐0.9%(8,215) Street Tree Maintenance    Assessment Fees 465,371                   465,000                   470,000                   1.1%5,000                         Other Revenue 400,707                   ‐                            240,000                   0.0%240,000                  Total Street Tree Maintenance 866,078 465,000 710,000 52.7%245,000 Tyler Court Apartments    Rental Income 552,480                   600,000                   641,891                   7.0%41,891                       Other Revenue 7,625                        2,500                        2,509                        0.4%9                                 Interest Income (86)                            12                             ‐                            ‐100.0%(12)                           Total Tyler Court Apartments 560,019 602,512 644,400 7.0%41,888 Total Special Revenue Funds $17,174,516 $16,637,103 $13,883,132 ‐16.6% ($2,753,971) June 8, 2021 Item #11 Page 142 of 336 SCHEDULE OF REVENUE ESTIMATES       2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 Enterprise Funds Water Operations    Water Sales $26,283,507 $27,496,504 $28,046,435 2.0% $549,931    Ready‐to‐Serve charge 12,103,128              12,290,845              12,536,662              2.0%245,817                     Water Rebates ‐                            ‐                            ‐                            0.0%‐                              Property Tax 4,204,447                3,628,154                3,680,499                1.4%52,345                       New Account Charges 123,168                   132,416                   132,416                   0.0%‐                              Back‐Flow Program Fees 165,813                   138,859                   138,859                   0.0%‐                              Penalty Fees 202,884                   3,000                        104,651                   3388.4%101,651                     Interest Income 1,137,240                374,898                   374,897                   0.0%(1)                                Engineering Overhead 46,691                      35,000                      40,000                      14.3%5,000                         Service Connection Fees 57,358                      42,600                      42,600                      0.0%‐                              Other Revenue 286,909                   380,826                   369,436                   ‐3.0%(11,390)                   Total Water Operations 44,611,145 44,523,102 45,466,455 2.1%943,353 Recycled Water Operations    Water Sales 6,223,138                6,770,361                6,860,887                1.3%90,526                       Ready‐to‐Serve charge 1,187,012                1,203,743                1,209,771                0.5%6,028                         Recycled Water Credits ‐                            ‐                            ‐                            0.0%‐                              Interest Income 41,194                      (23,389)                    (23,389)                    0.0%‐                              Other Revenue 111,440                   21,356                      25,577                      19.8%4,221                      Total Recycled Water Operations 7,562,784 7,972,071 8,072,846 1.3%100,775 Wastewater Operations      Service Charges 13,763,966              13,372,679              13,773,859              3.0%401,180                     Misc. Sewer 23,958                      7,890                        ‐                            ‐100.0%(7,890)                        Engineering Overhead 33,377                      15,931                      15,931                      0.0%‐                              Penalty Fees 60,798                      ‐                            30,399                      0.0%30,399                       Interest Income 374,741                   75,000                      75,000                      0.0%‐                              Other Revenue 66,272                      211,628                   68,672                      ‐67.6%(142,956)                 Total Wastewater Operations 14,323,112 13,683,128 13,963,861 2.1%280,733 Solid Waste Management    Recycling Fees (AB939)403,239                   290,000                   300,000                   3.5%10,000                       Penalty Fees 39,238                      ‐                            20,000                      0.0%20,000                       Trash Surcharge 3,120,429                3,000,000                3,000,000                0.0%‐                              Interest Income 497,353                   182,080                   185,080                   1.7%3,000                         Other Revenue 437,499                   448,738                   564,347                   25.8%115,609                  Total Solid Waste Management 4,497,758 3,920,818 4,069,427 3.8%148,609 Golf Course Operations    Charges for Services 6,558,857                7,709,022                7,400,000                ‐4.0% (309,022)                    Interest Income 34,755                      8,300                        4,000                        ‐51.8%(4,300)                        Other Revenue 149,855                   74,800                      135,000                   80.5%60,200                    Total Golf Course Operations 6,743,467 7,792,122 7,539,000 ‐3.3% (253,122) Total Enterprise Funds $77,738,266 $77,891,241 $79,111,589 1.6% $1,220,348 June 8, 2021 Item #11 Page 143 of 336    SCHEDULE OF REVENUE ESTIMATES       2020‐21 2021‐22 Change as % Difference  2019‐20 Estimated Estimated of  20‐21 2020‐21 to Revenue Source Actuals Revenue Revenue Estimated 2021‐22 Internal Service Funds Workers' Compensation    Interdepartmental Charges $3,455,136 $1,880,930 $4,524,730 140.6% $2,643,800    Interest Income 448,532                   190,000                   215,000                   13.2%25,000                       Other Revenue 190,508                   1,834,163                15,000                      ‐99.2% (1,819,163)             Total Workers' Compensation 4,094,176 3,905,093 4,754,730 21.8%849,637 Risk Management    Interdepartmental Charges 2,195,820                2,309,460                3,306,080                43.2%996,620                     Interest Income 162,698                   65,000                      75,000                      15.4%10,000                       Other Revenue 28,856                      47,950                      20,000                      ‐58.3%(27,950)                   Total Risk Management 2,387,374 2,422,410 3,401,080 40.4%978,670   Self‐Insured Benefits      Interdepartmental Charges ‐                            ‐                            ‐                            0.0%‐                              Other Revenue ‐                            ‐                            ‐                            0.0%‐                           Total Self‐Insured Benefits 0 0 0 0.0%0 Vehicle Maintenance      Interdepartmental Charges 2,852,757                3,500,050                3,291,562                ‐6.0%(208,488)                    Interest Income 21,840                      8,199                        9,000                        9.8%801                             Other Revenue 46,345                      8,093                        40,000                      394.3%31,907                    Total Vehicle Maintenance 2,920,942 3,516,342 3,340,562 ‐5.0% (175,780) Vehicle Replacement    Interdepartmental Charges 2,366,412                2,192,070                3,881,885                77.1% 1,689,815                  Interest Income 602,631                   350,000                   350,000                   0.0%‐                              Other Revenue 50,090                      137,937                   80,000                      ‐42.0%(57,937)                   Total Vehicle Replacement 3,019,133 2,680,007 4,311,885 60.9% 1,631,878 Information Technology    Interdepartmental Charges 13,275,060              12,379,451              14,752,389              19.2% 2,372,938                  Interest Income 296,030                   108,000                   108,000                   0.0%‐                              Other Revenue 47,417                      48,000                      ‐                            ‐100.0%(48,000)                   Total Information Technology 13,618,507 12,535,451 14,860,389 18.6% 2,324,938    Total Internal Service Funds $26,040,132 $25,059,303 $30,668,646 22.4% $5,609,343 Trust Funds Sucssessor Agency Housing Fund    Property Tax Increment 5,006,144                4,000,000                1,060,000                ‐73.5% (2,940,000)                Interest Income 105,205                   127,400                   18,000                      ‐85.9% (109,400)                 Total Successor Agency Housing Fund 5,111,349 4,127,400 1,078,000 ‐73.9% (3,049,400) Total Trust Funds $5,111,349 $4,127,400 $1,078,000 ‐73.9% ($3,049,400) Total Operating Funds $300,206,156 $296,449,047 $303,554,429 2.4% $7,105,382 June 8, 2021 Item #11 Page 144 of 336 SCHEDULE OF BUDGET EXPENDITURES  % Incr / (Decr) 2020‐21 20‐21 Budget 2018‐19 2019‐20 Estimated  2020‐21 2021‐22 to Department Actuals Actuals Expenditures Budget Budget 21‐22 Budget General Fund Policy And Leadership Group City Council $453,386 $466,528 $535,532 $586,317 $649,975 10.9% City Attorney 1,751,649     1,910,060       1,981,318     1,987,318        2,037,136         2.5% City Clerk 1,013,027     1,126,417       1,190,810     1,263,159        1,300,469         3.0% City Manager 2,329,708     2,574,961       2,065,119     2,153,294        2,112,097         ‐1.9% City Treasurer 212,225     215,784       227,235    244,090       250,752         2.7% Community Outreach And Engagement 1,602,350     1,651,700       1,692,761     1,692,761        1,771,173         4.6% Total Policy And Leadership Group 7,362,345        7,945,450   7,692,775       7,926,939   8,121,602     2.5% Administrative Services Administration ‐      ‐        ‐      ‐        568,883         ‐ Finance 5,195,794     5,617,702       5,750,000     5,989,716        5,632,387         ‐6.0% Human Resources 3,561,005     4,302,513       4,374,700     5,010,104        4,797,011         ‐4.3% Innovation and Economic Development 673,700     1,097,395       1,129,110     1,131,877        1,264,626         11.7% Total Administrative Services 9,430,499        11,017,610     11,253,810   12,131,697      12,262,907       1.1% Community Services Community Services Administration ‐      ‐        500,000    581,849       656,221         12.8% Community Development 10,692,924      10,328,444   10,767,000      10,781,168   15,899,492     47.5% Library And Cultural Arts 12,969,709      13,030,148   12,353,998      13,291,868   13,780,555     3.7% Parks And Recreation 17,165,407      17,584,182   16,304,411      17,993,237   19,159,380     6.5% Total Community Services 40,828,040    40,942,774     39,925,409   42,648,122      49,495,648       16.1% Public Safety Fire 24,017,515      25,620,353   28,882,000      27,173,120   33,521,412     23.4% Police 39,009,548      44,841,600   44,041,378      44,593,457   49,260,017     10.5% Total Public Safety 63,027,063    70,461,953     72,923,378   71,766,577      82,781,429       15.3% Public Works Public Works Administration 1,626,845     1,768,613       1,787,962     1,786,198        1,941,613         8.7% Construction Management & Inspections 2,575,598     2,944,509       2,717,631     2,893,903        2,990,665         3.3% Environmental Management 669,711     758,852       780,799    808,946       1,282,225         58.5% Facilities 5,058,965     5,537,243       5,309,605     5,862,683        6,555,934         11.8% Transportation 6,877,759     7,583,250       7,920,763     7,410,972        8,405,466         13.4% Total Public Works 16,808,878    18,592,467     18,516,760   18,762,702      21,175,903       12.9% Miscellaneous Non‐Departmental Expenditures Community Contributions 11,213 7,983 3,000 0 0 ‐ Dues & Subscriptions 51,688 71,519 75,000 75,000 80,000 6.7% Legal Services 793,094 697,114 670,000 750,000 1,200,000 60.0% Professional Services 39,830 39,195 35,000 42,000 42,000 0.0% Other Miscellaneous Expenditures 738,439 3,860,320 0 0 0 ‐ Personnel Related 149,563 152,582 200,000 284,000 850,000 199.3% COVID‐related 0 910,211 1,432,000 0 0 ‐ Property Tax & Other Administration 660,633     658,895       725,000    725,000       750,000         3.4% Total Expenditures 2,444,460        6,397,819   3,140,000       1,876,000   2,922,000     55.8% Attachment A3 June 8, 2021 Item #11 Page 145 of 336    SCHEDULE OF BUDGET EXPENDITURES         % Incr / (Decr) 2020‐21 20‐21 Budget 2018‐19 2019‐20 Estimated  2020‐21 2021‐22 to Department Actuals Actuals Expenditures Budget Budget 21‐22 Budget General Fund ‐ Continued Transfers Transfer to General Capital Construction Fund 0 5,111,500 4,500,000 4,500,000 5,353,000 19.0% Transfer to Infrastructure Replacement Fund 10,681,000 5,111,500 4,500,000 1,000,000 5,353,000 435.3% Transfer from Infrastructure Replacement Fund 0 0 0 0 (5,070,000)‐ Transfer To LLD#1 (Medians & Trees) 775,000 950,000 700,000 700,000 1,190,000 70.0% Transfer To Storm Water Program 219,274 303,052 312,000 309,000 322,000 4.2% Other Miscellaneous Transfers 1,500,000 2,090,114 10,000,000 500,000 0 ‐100.0% Total Transfers 13,175,274       13,566,166        20,012,000       7,009,000           7,148,000          2.0% Total Miscellaneous Non‐Departmental 15,619,734       19,963,985        23,152,000       8,885,000           10,070,000       13.3% Subtotal General Fund 153,076,559    168,924,239    173,464,132    162,121,037     183,907,489    13.4% Contingencies ‐                    ‐                      1,076,000        1,500,000          500,000            ‐66.7% Total General Fund 153,076,559    168,924,239    174,540,132    163,621,037     184,407,489    12.7% Special Revenue Funds Affordable Housing $704,106 $868,053 $5,034,346 $880,698 $811,197 ‐7.9% Agricultural Mitigation Fee 149,893 0 0 0 0 ‐ Buena Vista Channel Maintenance 135,419 71,738 116,298 195,245 195,245 0.0% Citizen's Option For Public Safety 236,881 247,072 200,000 253,937 266,106 4.8% Community Activity Grants 0 0 0 30,000 30,000 0.0% Community Development Block Grant 509,402 324,153 1,428,953 655,643 638,299 ‐2.6% Cultural Arts Donations 29,920 29,510 122,385 122,385 131,750 7.7% Flower Fields Grant Program 50,000 943,272 0 0 0 ‐ Habitat Mitigation Fee 3,637 1,115,129 0 0 0 ‐ Library And Arts Endowment Fund 1,493 0 6,000 6,000 6,000 0.0% Library Gifts/Bequests 301,371 217,268 426,910 426,910 384,270 ‐10.0% Lighting And Landscaping District No. 2 253,519 353,503 375,750 354,681 376,001 6.0% Local Cable Infrastructure Fund 270,649 207,119 351,000 351,000 345,000 ‐1.7% Median Maintenance 960,502 1,077,147 1,005,000 1,221,612 1,369,415 12.1% Parking In Lieu 46,102 47,547 50,000 50,000 50,000 0.0% Police Asset Forfeiture 25,600 122,365 65,000 316,000 170,000 ‐46.2% Public Safety Grants 566,987 170,871 233,939 0 0 ‐ Recreation Donations 47,518 28,289 37,957 98,700 82,591 ‐16.3% Rental Assistance 7,479,464 7,832,253 8,510,000 7,723,066 7,898,443 2.3% Senior Donations 105,492 20,592 13,200 104,500 79,600 ‐23.8% Street Lighting 754,086 633,162 685,000 967,581 971,246 0.4% Street Tree Maintenance 658,389 575,205 625,000 877,810 943,555 7.5% Tyler Court Apartments 560,568 497,143 430,000 608,388 640,987 5.4% Total Special Revenue Funds 13,290,430      14,884,248       19,716,738      15,244,156        15,389,705       1.0% June 8, 2021 Item #11 Page 146 of 336 SCHEDULE OF BUDGET EXPENDITURES      % Incr / (Decr) 2020‐21 20‐21 Budget 2018‐19 2019‐20 Estimated  2020‐21 2021‐22 to Department Actuals Actuals Expenditures Budget Budget 21‐22 Budget Enterprise Funds Water Operations $42,715,366 $45,759,077 $46,126,865 $46,126,865 $47,821,220 3.7% Recycled Water Operations 9,342,838        9,687,430         10,333,658      10,583,658        10,103,790       ‐4.5% Wastewater Operations 18,534,329      12,872,742       15,235,755      15,235,755        16,057,473       5.4% Solid Waste Management 3,955,189        4,442,825         4,498,833        5,022,951          5,183,474         3.2% Golf Course Operations 7,794,389        7,033,434         6,340,807        6,571,000          7,231,000         10.0% Total Enterprise Funds 82,342,111      79,795,508       82,535,918      83,540,229        86,396,957       3.4% Internal Service Funds Workers' Compensation $5,411,518 $3,707,498 $1,950,000 $3,664,554 $3,933,699 7.3% Risk Management 2,181,589        2,508,452         3,048,468        2,684,739          3,207,702         19.5% Self‐Insured Benefits 382,552            66,103              1,834,163        1,920,163          ‐                     ‐100.0% Vehicle Maintenance 2,844,293        2,914,153         2,782,841        3,296,304          3,516,373         6.7% Vehicle Replacement 2,067,034        3,599,851         795,000           3,779,298          4,546,033         20.3% Information Technology 12,433,677      9,351,645         15,600,562      13,567,910        14,369,778       5.9% Total Internal Service Funds 25,320,663      22,147,702       26,011,034      28,912,968        29,573,585       2.3% Trust Funds Successor Agency Housing Fund 1,769,568        1,213,597         1,049,406        1,933,523          1,067,495         ‐44.8% Total Trust Funds 1,769,568        1,213,597         1,049,406        1,933,523          1,067,495         ‐44.8% Total Operating Funds 275,799,331$  286,965,294$  303,853,228$ 293,251,913$   316,835,231$  8.0% June 8, 2021 Item #11 Page 147 of 336 CITY OF CARLSBAD CAPITAL PROJECT FUNDS July 1, 2020 Projected June 30, 2021 Unreserved Projected Projected Debt Service Projected Fund Balance Revenues Expenditures Loans & Other Balance BTD#2 ‐ Poinsettia Lane/Aviara Pkwy 11,920,207        1,907,682         ‐‐13,827,889         BTD#3 ‐ Cannon Road West 513,549             7,150               ‐‐520,699              Community Development Block Grant ‐ ‐ ‐‐‐  CFD #1  ‐ Citywide 91,328,320        3,479,363        1,434,067              149,600 93,224,016         Gas Tax 13,457,554        2,875,081        2,509,390              610,000 13,213,245         Gas Tax (Road Maint. & Rehab Acct.)2,477,640          2,096,490        175,728 ‐4,398,401           General Capital Const.42,273,928        4,500,000        14,470,611           ‐32,303,317         Grants ‐ Federal ‐ 1,398,825        136 ‐1,398,689           Infrastructure Replacement 120,681,890      2,665,814        5,919,603              ‐117,428,102       Other 1,897,038          26,352             6,602 ‐1,916,789           Park Fee Zones 5,13,16, 17, 18 4,613,836          186,853           ‐‐4,800,689           Park‐In‐Lieu NE 4,121,004          513,129           ‐‐4,634,133           Park‐In‐Lieu NW 1,735,200          423,441           ‐‐2,158,641           Park‐In‐Lieu SE 1,724,128          24,030             ‐‐1,748,158           Park‐In‐Lieu SW 433,069             355,373           ‐‐788,442              Planned Local Drainage Area A 939,865             71,988             38,820 ‐973,033              Planned Local Drainage Area B 2,317,826          185,550           370,867 ‐2,132,510           Planned Local Drainage Area C 1,530,437          23,498             2,640 ‐1,551,294           Planned Local Drainage Area D 695,123             35,343             80,217 ‐650,249              Public Facilities Fee 28,883,659        2,164,267        385,361 ‐30,662,565         Sewer Connection 8,266,772          522,778           2,863,782              ‐5,925,767           Sewer Replacement 23,632,552        5,601,306        5,416,628              ‐23,817,231         TDA ‐ ‐ ‐‐‐  Traffic Impact Fee 23,538,276        2,754,390        2,459,678              ‐23,832,987         Transnet/Local 25,877,351        4,112,892        3,253,329              ‐26,736,914         Transnet/STP ‐ ‐ ‐‐‐  Water ‐ Potable 35,338,444        1,423,518        107,255 ‐36,654,707         Water ‐ Recycled (8,177,289)         261,688           5,145,298              ‐(13,060,899)        Water Replacement ‐ Potable 55,513,647        6,961,434        6,744,933              ‐55,730,148         Water Replacement ‐ Recycled 18,242,217        245,107           250,008 ‐18,237,317         Total 513,776,242      44,823,342      51,634,953           759,600 506,205,030       PROJECTED FUND BALANCES FOR FY 2020‐21 Attachment B June 8, 2021 Item #11 Page 148 of 336 CITY OF CARLSBAD CAPITAL PROJECT FUNDS July 1, 2021 June 30, 2021 July 01, 2021 2021‐22 June 30, 2022 Projected Estimated Continuing New Total CIP Projected Fund Balance Revenues Appropriations Appropriations Appropriations Balance BTD#2 ‐ Poinsettia Lane/Aviara Pkwy 13,827,889         ‐                    13,499,116            ‐                         13,499,116        328,773                BTD#3 ‐ Cannon Road West 520,699             60,984              ‐                          ‐                          ‐                      581,683                Community Development Block Grant ‐                       ‐                    ‐                         ‐                         ‐                      ‐                        CFD #1  ‐ Citywide 93,224,016        4,518,318        30,650,767           2,106,890              32,757,657        64,984,677          Gas Tax 13,213,245        2,955,545        11,008,383           4,372,489              15,380,872        787,918                Gas Tax (Road Maint. & Rehab Acct.)4,398,401          2,252,350        3,724,993              2,520,000              6,244,993          405,758                General Capital Const.32,303,317        5,353,000        21,302,072           2,247,000              23,549,072        14,107,245          Grants ‐ Federal 1,398,689          2,367,600        1,398,689              2,367,600              3,766,289          (0)                          Infrastructure Replacement 117,428,102      5,353,000        28,655,339           16,097,910           44,753,249        78,027,853          Other 1,916,789          ‐                    1,287,990              ‐                         1,287,990          628,799                Park Fee Zones 5,13,16, 17, 18 4,800,689          12,955             ‐                         ‐                         ‐                      4,813,644            Park‐In‐Lieu NE 4,634,133          ‐                    200,000                 200,000                 400,000             4,234,133            Park‐In‐Lieu NW 2,158,641          593,015           792                         ‐                         792                     2,750,864            Park‐In‐Lieu SE 1,748,158          301,228           4,111                     ‐                         4,111                  2,045,275            Park‐In‐Lieu SW 788,442             ‐                    223,037                 ‐                         223,037             565,405                Planned Local Drainage Area A 973,033             ‐                    16,254                   25,000                   41,254                931,779                Planned Local Drainage Area B 2,132,510          75,256             1,739,651              ‐                         1,739,651          468,115                Planned Local Drainage Area C 1,551,294          67,764             17,610                   25,000                   42,610                1,576,448            Planned Local Drainage Area D 650,249             35,927             19,645                   25,000                   44,645                641,531                Public Facilities Fee 30,662,565        763,379           3,185,749              4,633,000              7,818,749          23,607,195          Sewer Connection 5,925,767          251,948           3,609,613              (620,000)                2,989,613          3,188,102            Sewer Replacement 23,817,231        5,599,836        26,723,829           8,576,620              35,300,449        (5,883,383)           TDA ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Traffic Impact Fee 23,832,987        604,551           16,510,568           3,076,000              19,586,568        4,850,970            Transnet/Local 26,736,914        4,304,000        21,110,881           4,790,000              25,900,881        5,140,032            Transnet/STP ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Water ‐ Potable 36,654,707        998,529           4,235,114              7,000,183              11,235,297        26,417,939          Water ‐ Recycled (13,060,899)       20,217,580      6,920,441              ‐                         6,920,441          236,239                Water Replacement ‐ Potable 55,730,148        9,122,706        44,404,925           (3,460,116)            40,944,809        23,908,045          Water Replacement ‐ Recycled 18,237,317        ‐                    5,983,629              2,172,100              8,155,729          10,081,588          Total 506,205,030      65,809,472      246,433,198         56,154,676           302,587,874      269,426,628        PROJECTED FUND BALANCES FOR FY 2021‐22 June 8, 2021 Item #11 Page 149 of 336 CITY OF CARLSBAD CAPITAL PROJECT FUNDS REVENUES ACTUAL AND ESTIMATED 2017‐18 2018‐19 2019‐20 2020‐21 2021‐22 Actual Actual Actual Projected Estimated Fund Revenue Revenue Revenue Revenue Revenue BTD#2 ‐ Poinsettia Lane/Aviara Pkwy 305,677             751,810           217,466                 1,907,682              ‐                       BTD#3 ‐ Cannon Road West 4,293                  18,996             17,696                   7,150                     60,984                 Community Development Block Grant 16,335                ‐                    ‐                         ‐                         ‐                       CFD #1  ‐ Citywide 2,795,212          6,095,889        5,736,415              3,479,363              4,518,318           Gas Tax 2,749,382          3,299,173        3,118,353              2,875,081              2,955,545           Gas Tax (Road Maint. & Rehab Acct.)661,528             2,132,844        2,067,614              2,096,490              2,252,350           General Capital Const.‐                      1,077,525        5,111,500              4,500,000              5,353,000           Grants ‐ Federal 40,371                956,847           41,175                   1,398,825              2,367,600           Infrastructure Replacement 10,358,061        15,073,019      9,369,345              2,665,814              5,353,000           Other 11,763                19,704             65,369                   26,352                   ‐                       Park Fee Zones 5,13,16, 17, 18 501,489             244,229           255,028                 186,853                 12,955                 Park‐In‐Lieu NE 69,308                1,441,530        347,407                 513,129                 ‐                       Park‐In‐Lieu NW 771,528             1,086,531        260,256                 423,441                 593,015              Park‐In‐Lieu SE 16,622                372,419           326,671                 24,030                   301,228              Park‐In‐Lieu SW 61,225                190,127           271,373                 355,373                 ‐                       Planned Local Drainage Area A 77,773                155,094           48,111                   71,988                   ‐                       Planned Local Drainage Area B 75,817                136,887           174,328                 185,550                 75,256                 Planned Local Drainage Area C 5,489                  82,796             53,875                   23,498                   67,764                 Planned Local Drainage Area D 22,847                124,198           31,433                   35,343                   35,927                 Public Facilities Fee 4,947,110          3,673,762        3,439,781              2,164,267              763,379              Sewer Connection 842,150             874,464           749,326                 522,778                 251,948              Sewer Replacement 4,872,244          7,662,061        5,682,839              5,601,306              5,599,836           TDA 23,682                ‐                    ‐                         ‐                         ‐                       Traffic Impact Fee 3,059,920          2,586,291        1,924,738              2,754,390              604,551              Transnet/Local 4,269,152          3,779,436        4,546,554              4,112,892              4,304,000           Transnet/STP ‐                      ‐                    ‐                         ‐                         ‐                       Water ‐ Potable 1,786,623          2,064,521        2,188,356              1,423,518              998,529              Water ‐ Recycled 1,231,038          2,144,721        2,815,693              261,688                 20,217,580         Water Replacement ‐ Potable 5,002,438          6,970,260        7,885,252              6,961,434              9,122,706           Water Replacement ‐ Recycled 1,348,906          2,046,796        1,995,701              245,107                 ‐                       Total 45,927,983        65,061,930      58,741,652           44,823,342           65,809,472         Note: Revenues include loans, advances and transfers. June 8, 2021 Item #11 Page 150 of 336 CITY OF CARLSBAD CAPITAL PROJECT FUNDS BUDGET EXPENDITURE SCHEDULE 2018‐19 2019‐20 2020‐21 2021‐22 2021‐22 2021‐22 Actual Actual Estimated Continuing New Total CIP 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 ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Community Development Block Grant ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        CFD #1  ‐ Citywide 665,531             381,703           1,583,667              30,650,767           2,106,890          32,757,657          Gas Tax 2,609,525          2,803,727        3,119,390              11,008,383           4,372,489          15,380,872          Gas Tax (Road Maint. & Rehab Acct.)1,441,968          889,601           175,728                 3,724,993              2,520,000          6,244,993            General Capital Const.3,355,394          5,503,817        14,470,611           21,302,072           2,247,000          23,549,072          Grants ‐ Federal ‐                      41,175             136                         1,398,689              2,367,600          3,766,289            Infrastructure Replacement 1,963,003          5,848,629        5,919,603              28,655,339           16,097,910        44,753,249          Other ‐                      ‐                    6,602                     1,287,990              ‐                      1,287,990            Park Fee Zones 5,13,16, 17, 18 ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Park‐In‐Lieu NE ‐                      ‐                    ‐                         200,000                 200,000             400,000                Park‐In‐Lieu NW (1,716)                 925                   ‐                         792                         ‐                      792                       Park‐In‐Lieu SE 432,960             4,850               ‐                         4,111                     ‐                      4,111                    Park‐In‐Lieu SW 2,458,313          383,869           ‐                         223,037                 ‐                      223,037                Planned Local Drainage Area A 3,352                  107,524           38,820                   16,254                   25,000               41,254                  Planned Local Drainage Area B 1,114,394          305,319           370,867                 1,739,651              ‐                      1,739,651            Planned Local Drainage Area C 2,168                  99,472             2,640                     17,610                   25,000               42,610                  Planned Local Drainage Area D 2,451                  107,285           80,217                   19,645                   25,000               44,645                  Public Facilities Fee 4,996,962          1,184,567        385,361                 3,185,749              4,633,000          7,818,749            Sewer Connection 1,293,191          190,119           2,863,782              3,609,613              (620,000)            2,989,613            Sewer Replacement 5,934,908          7,797,397        5,416,628              26,723,829           8,576,620          35,300,449          TDA ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Traffic Impact Fee 324,564             629,024           2,459,678              16,510,568           3,076,000          19,586,568          Transnet/Local 1,561,510          4,294,221        3,253,329              21,110,881           4,790,000          25,900,881          Transnet/STP ‐                      ‐                    ‐                         ‐                         ‐                      ‐                        Water ‐ Potable 6,700                  42,813             107,255                 4,235,114              7,000,183          11,235,297          Water ‐ Recycled 825,659             6,937,689        5,145,298              6,920,441              ‐                      6,920,441            Water Replacement ‐ Potable 7,089,068          6,761,187        6,744,933              44,404,925           (3,460,116)         40,944,809          Water Replacement ‐ Recycled 215,047             151,548           250,008                 5,983,629              2,172,100          8,155,729            Total 36,294,952        44,736,495      52,394,553           246,433,198         56,154,676        302,587,874        June 8, 2021 Item #11 Page 151 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Abandon Potable Services (New Recycled Services) Multiple Districts Medium 52051 WATER REPL ADA Beach Access - Pine to Tamarack District 1 Medium 60651 GCC ADA Improvement Program Multiple Districts High 60491 TRANSNET- LOC 60492 IRF Adaptive Traffic Signal Program Multiple Districts High 63261 TRANSNET- LOC 63264 TRANSNET- LOC 63265 IRF Advance Street Name Signs Multiple Districts High 60861 GAS TAX Agua Hedionda Creek Maintenance District 2 High 33381 PLDB 66292 IRF Agua Hedionda Lift Station Biological Monitoring and Maintenance District 2 Medium 55451 SEWER REPL Alga Norte Park Modifications District 3 Medium 47331 GCC Assessment District 97-1 MaintenanceDistrict 3 Medium 60841 GCC Avenida Encinas Pedestrian Access Improvements District 2 Critical 60911 GAS TAX Avenida Encinas Widening - South of Palomar Airport Road Multiple Districts High 60041 TIF 60042 FED GRNT Aviara and Hidden Canyon Parks Playground Safety Resurfacing Multiple Districts Low 47451 IRF Aviara Community Park - Phase 2 District 2 Low 46041 PIL-SW 46042 PIL-SW 46043 PFF Aviara Parkway and Plum Tree Waterline District 2 Low 19021 WATER REPL Aviara Reimbursement Agreement District 2 Low 36491 PIL-SW 40131 GCC 1,925,825---500,000500,00050,000-866,1751,742,000 2,875,000-----2,500,000-375,000 8,670,0002,225,0002,225,000175,000715,000175,000715,000640,0001,800,000 --------- 2,583,979-------2,583,979 1,000,000-------1,000,000 800,000------800,000- 40,000-------40,000 3,559,895-------3,559,895 298,000---80,00080,00080,00058,000- 225,000-------225,000 974,000-----660,000-314,000 420,000-------420,000 75,000-------75,000 5,177,903-----3,177,0002,000,000903 1,776,000------1,776,000- 600,000-------600,000 3,120,500-------3,120,500 38,200-------38,200 700,000-------700,000 1,100,500-----900,500200,000- 238,000-------238,000 15-year Capital Improvement Program Attachment B2June 8, 2021 Item #11 Page 152 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Aviara Reimbursement Agreement District 2 Low 36491 PIL-SW Barrio Street Lighting District 1 High 40131 GCC 40132 Gas Tax 40133 TRANSNET- LOC Beach Access Repair and Upgrades - Pine Avenue to Tamarack District 1 Critical 38961 IRF 38962 GCC Bridge Preventative Maintenance Program Multiple Districts High 60661 IRF Buena Interceptor Sewer Access Road Improvements District 3 High 55371 SEWER REPL Buena Interceptor Sewer Improvements Multiple Districts Critical 55011 SEWER REPL 55012 SEWER CONN Buena Interceptor Sewer Realignment - East Segment District 2 High 55441 SEWER REPL Buena Vista Creek Concrete Channel Maintenance at El Camino Real Multiple Districts Critical 66191 GCC 66192 IRF Business Park Recreational Facility (Partial Funding)District 2 Low 19041 ZONE 5 Calavera Hills Community Center Refurbishment District 2 Medium 47461 IRF Calavera Hills Community Park Gateway Improvements District 2 High 46011 GCC 46012 GCC Camino De Los Coches and La Costa Avenue Intersection Control District 4 Critical 63251 GAS TAX Camino Hills and Jackspar Drive Slope Stabilization District 2 Medium 60301 GCC Cannon Road and Paseo del Norte Sustainable Mobility Plan and Growt..District 2 High 60951 Gas Tax Cannon Road Lift Station Improvements District 2 High 55521 SEWER REPL Carlsbad Boulevard and Tamarack Avenue Pedestrian Improvements District 1 High 60581 GAS TAX 60583 TRANSNET- LOC Carlsbad Boulevard Lane Reduction andEdgeStriping Multiple Districts High 60961 Gas Tax 760,000-------760,000 700,000------700,000- 3,590,000---1,030,0001,280,0001,280,000-- 4,112,750------2,500,0001,612,750 6,199,000-------6,199,000 3,477,511---500,000500,000250,000500,0001,727,511 1,150,000-------1,150,000 4,458,686-----3,500,000-2,799,8133,758,499 550,000-------550,000 2,533,000-----2,026,000-507,000 1,250,000-------1,250,000 3,550,000-----730,0002,820,000- 4,760,0004,760,000------- 685,000------540,000145,000 1,397,350------101,0001,296,350 10,500-------10,500 850,000-----500,000100,000250,000 859,400------700,000159,400 60,000------60,000- 680,000-----530,000150,000- 1,576,000-------1,576,000 1,054,000-------1,054,000 June 8, 2021 Item #11 Page 153 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceCarlsbadBoulevardandTamarack Avenue Pedestrian Improvements District 1 High 60583 TRANSNET- LOC Carlsbad Boulevard Lane Reduction and Edge Striping Multiple Districts High 60961 Gas Tax Carlsbad Boulevard Median - Tamarack Avenue to Pine Avenue District 1 Low 19071 GAS TAX Carlsbad Boulevard Pedestrian Improvement Project District 1 High 60971 GAS TAX 60972 FED GRNT Carlsbad Boulevard Pedestrian Lighting - Tamarack to State Street District 1 High 60681 TRANSNET- LOC Carlsbad Boulevard Realignment Multiple Districts Medium 60311 TRANSNET- LOC Carlsbad Boulevard Realignment / Palomar Airport Road (Segment 2)District 2 Low 19081 TIF Carlsbad Boulevard Realignment / Palomar Airport Road (Segment 2) (R..District 2 Low 19091 TIF Carlsbad Boulevard Waterline Replacement at Terramar District 2 Critical 50481 WATER REPL Carlsbad Boulevard Widening Mountain View Drive to Northerly City Limits District 1 Low 19101 TIF 19102 TIF Carlsbad Village Drive and Grand Avenue Pedestrian and Crossing Impr..District 1 Medium 19121 TRANSNET- LOC Carlsbad Village Drive Widening - Pontiac Drive to Victoria Avenue Multiple Districts Low 19131 TIF Carlsbad Water Recycling Facility (Encina Capital Projects) District 3 Critical 52031 WATER REPL 52032 RECL REPL Carlsbad Water Recycling Facility Irrigation and Landscape District 3 Low 52131 RECL REPL Carlsbad Water Recycling Facility Roof Replacement District 3 Low 47491 RECL REPL Cathodic Protection Program Multiple Districts Critical 50071 WATER REPL CFD#1 Administration Multiple Districts Low 19151 CFD#1 Chestnut Avenue Complete Street Improvements - Valley to Pio Pico District 1 Medium 19161 TRANSNET- LOC Chestnut Complete Street I-5 to Railroad Project Study District 1 Medium 60691 TRANSNET- LOC Chestnut Underpass Public Art Project District 1 Medium 60981 GCC Christiansen Way Improvements District 1 Medium 19171 TRANSNET- LOC 300,000------300,000- 2,763,0002,763,000------- 108,400------108,400- 591,600------591,600- 1,325,000-------1,325,000 1,779,026-------1,779,026 932,000932,000------- 3,681,0003,681,000------- 5,080,000-----1,650,0001,000,0002,430,000 984,000984,000------- 1,274,0001,274,000------- 1,320,000-----1,320,000-- 3,102,0003,102,000------- 599,944-------109,446709,390 7,336,7101,300,0001,200,000200,000310,000320,000315,0001,460,0002,231,710 175,000-------175,000 225,000------225,000- 2,906,700280,000260,000190,000190,000190,000190,000180,0001,426,700 440,000---110,000110,000110,000110,000- 1,080,000-----1,080,000-- 85,000-----85,000-- 250,000-----150,000100,000- June 8, 2021 Item #11 Page 154 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Chestnut Underpass Public Art Project District 1 Medium 60981 GCC Christiansen Way Improvements District 1 Medium 19171 TRANSNET- LOC City Facility Accessibility Upgrades Multiple Districts Medium 47271 GCC City Facility Safety and Parking Lot Lighting Assessment Multiple Districts High 60741 IRF City Hall Complex Multiple Districts Critical 40081 CFD#1 City Hall Complex Refurbishment District 1 Medium 47181 IRF City Hall Exterior Refurbishment District 1 Critical 47251 GCC Citywide Drainage Improvement Program Multiple Districts High 66082 GAS TAX 66083 IRF Citywide Street Lighting Program Multiple Districts Medium 60921 GAS TAX Citywide Thermoplastic Pavement Markings Multiple Districts Critical 60931 GAS TAX Cole Library Expansion District 1 Low 19211 CFD#1 19212 PFF 19213 GCC Cole Library Security Fencing District 1 Low 47501 IRF College Boulevard - Cannon Road To Badger Lane (375 Zone)District 2 Medium 50131 WATER CONN College Boulevard - Cannon Road To Badger Lane (490 Zone)District 2 Medium 50121 WATER CONN College Boulevard Reach A and Cannon Road Reach 4A District 2 High 36362 OTHER 36363 PLDB 36364 TRANSNET- LOC Concrete Repair/Replacement Program Multiple Districts Medium 60132 GAS TAX 60133 RMRA Crestview Drive Transmission Main District 2 Low 50331 WATER REPL Curb Inlet Filter Retrofit Program Multiple Districts Medium 66261 IRF 310,000-----310,000-- 500,000-------500,000 1,910,000------500,0001,410,000 51,028,105-50,000,000-----1,028,105 1,144,000------85,0001,059,000 2,250,000-------2,250,000 6,090,594-------6,090,594 8,721,5001,325,0001,325,000265,000265,000265,000595,0002,297,5002,384,000 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,095,000-----844,817-809,8171,060,000 1,460,000-----1,160,000-790,0001,090,000 1,713,002-------1,713,002 --------- 2,705,000----1,500,000--1,205,000 2,933,000-------2,933,000 5,837,0001,250,0001,250,000750,000620,000620,000620,000620,000107,000 800,000-----500,00060,000240,000 June 8, 2021 Item #11 Page 155 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Crestview Drive Transmission Main District 2 Low 50331 WATER REPL Curb Inlet Filter Retrofit Program Multiple Districts Medium 66261 IRF Desalinated Water Flow Control Facility No. 5 District 2 High 50381 WATER CONN DMP Facility AAA (Jefferson Street) District 1 Low 19231 PLDA DMP Facility AAAA (Madison Street) District 1 Medium 19241 PLDA DMP Facility AC (Highland Drive Drainage Project)District 1 Medium 66091 PLDA DMP Facility AFA (Hidden Valley Drainage Restoration and Enhanceme..District 2 Low 19251 PLDA DMP Facility AFB (Calavera Hills Drainage Restoration and Enhanceme..District 2 Low 19261 PLDA DMP Facility BB 1 and 2 (Washington Street)District 1 Low 19271 PLDB DMP Facility BCB (Magnolia Avenue) District 1 Medium 19281 PLDB DMP Facility BFA (Country Store) District 2 High 66271 PLDB DMP Facility BFB-L and BFB-1 (Tamarack and El Camino Real Plda "..District 2 Low 19291 PLDB DMP Facility BFB-U (El Camino Real) District 2 High 66221 PLDB 66222 IRF DMP Facility BL-L (College Boulevard Bridge Reimbursement Plda "B")District 2 Low 19301 PLDB DMP Facility BL-U (College Boulevard) District 2 Low 19311 PLDB DMP Facility BM (Cantarini/College Boulevard Box Culvert)District 2 Low 19321 PLDB DMP Facility BQ (Sunny Creek) District 2 Low 19331 PLDB DMP Facility BR (Cantarini/College Boulevard Pipe Drainage)District 2 Low 19341 PLDB DMP Facility C2 (Paseo Del Norte) District 3 Low 19351 PLDC DMP Facility CA (Avenida Encinas) District 3 Low 19361 PLDC DMP Facility DBB (Avenida Encinas) District 4 Low 19381 PLDD DMP Facility DFA (Batiquitos Lagoon Stormwater Treatment)District 4 Low 19391 PLDD DMP Facility DH (Altive Place Canyon Restoration) District 3 Low 19401 PLDD 3,230,000-1,500,000300,000300,000300,000300,000300,000230,000 10,104,300------7,950,0002,154,300 289,534289,534------- 416,500416,500------- 921,408921,408------- 91,60891,608------- 163,164163,164------- 1,086,0651,086,065------- 468,096468,096------- 963,673-------963,673 904,329904,329------- 891,220-------891,220 1,578,00030,00030,0006,0006,0006,000750,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------- June 8, 2021 Item #11 Page 156 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceDMPFacilityDFA(BatiquitosLagoon Stormwater Treatment)District 4 Low 19391 PLDD DMP Facility DH (Altive Place Canyon Restoration)District 3 Low 19401 PLDD DMP Facility DQB (La Costa Town Center)District 4 Medium 19411 PLDD DMP Facility DZ (Poinsettia Lane) District 3 High 19421 PLDD Dove Library Lighting Improvements District 3 Low 40811 GCC Dove Library Parking Lot Renovation District 3 Medium 47441 GCC Drainage Master Plan Facility DBA (Poinsettia Village)District 4 Low 19371 PLDD Drainage Master Plan Update Multiple Districts High 66231 PLDA 66232 PLDB 66233 PLDC 66234 PLDD El Camino Real and Agua Hedionda Creek Bridge Railing and Sidewalk District 2 Critical 60561 IRF El Camino Real and Cannon Road Intersection Improvements District 2 Critical 60421 TIF 60422 Gas Tax El Camino Real and Carlsbad Village Drive Dual Left Turns District 1 Low 19431 TIF El Camino Real and College Boulevard Intersection Improvements District 2 Critical 60711 GAS TAX 60712 GCC El Camino Real Medians Multiple Districts Low 36431 PFF 36432 GAS TAX El Camino Real Right Turn Lane to East Bound Alga Road District 3 Low 19441 TIF El Camino Real Widening - Arenal Road to La Costa Avenue District 4 High 60511 TIF El Camino Real Widening - Poinsettia Lane to Camino Vida Roble Multiple Districts Critical 60721 TRANSNET- LOC 60722 FED GRNT El Camino Real Widening - Sunny Creek toJackspar District 2 Critical 60941 TRANSNET- LOC 232,812232,812------- 745,842745,842------- 642,063642,063------- 225,000-------225,000 475,000-------475,000 167,215167,215------- 191,512------25,000166,512 558,000-------558,000 146,890------25,000121,890 234,598------25,000209,598 210,000-------210,000 3,536,000-------3,536,000 837,000------325,000512,000 1,132,000-1,132,000------ 1,020,000------75,000945,000 131,000-------131,000 695,781-------695,781 904,530-------500,0001,404,530 438,000-438,000------ 5,750,000-----2,500,00050,0003,200,000 3,105,000------1,550,0001,555,000 1,440,000-------1,440,000 June 8, 2021 Item #11 Page 157 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceElCaminoRealWidening-Poinsettia Lane to Camino Vida Roble Multiple Districts Critical 60722 FED GRNT El Camino Real Widening - Sunny Creek to Jackspar District 2 Critical 60941 TRANSNET- LOC El Fuerte Lift Station Pump Addition District 2 Medium 55531 SEWER CONN Encina Capital Projects Multiple Districts High 58011 SEWER REPL Faraday and El Camino Real Sewer Replacement - Orion to Palomar Airpo..District 2 High 55391 SEWER CONN Faraday Avenue Improvements District 2 High 60991 GCC Faraday Center Refurbishment District 2 Medium 47201 IRF Fire Administration Offices District 2 Medium 40891 GCC Fire Flow Capacity System Improvements Multiple Districts High 50431 WATER REPL Fire Station No. 2 Replacement District 4 High 40601 GCC Fire Station No. 4 Expansion District 3 High 47401 IRF Fire Station No. 5 New Roof and Storage Building District 2 Medium 47361 GCC Fire Station No. 6 Renovation District 4 Low 47511 IRF Fire Stations No. 1 and No. 5 Drainage Improvements Multiple Districts Medium 66161 GCC Fleet Fuel Island Upgrade District 2 High 47471 IRF Fleet Maintenance Refurbishment District 2 High 47141 IRF 47142 GCC Foxes Landing Lift Station Wetwell and Pump Replacement District 1 Critical 55261 SEWER REPL Gas Tax Transfer to General Fund (Transportation Operating Budget) Multiple Districts Null Null GAS TAX Guardrail Replacement and Improvement Program Multiple Districts Medium 60871 GAS TAX Harding Center Refurbishment District 1 Low 47081 IRF Headwall Replacement Program Multiple Districts High 66241 IRF Hosp Grove Park Improvements District 1 Low 47281 IRF Hydroelectric Generation at Water Facilities District 2 Medium 50591 WATER CONN 4,000,000-------4,000,000 780,000-----600,000180,000- 152,783,30139,288,00033,894,0008,240,0007,910,0007,877,0006,751,0006,822,00042,001,301 1,340,000-----1,200,000-140,000 100,000------100,000- 3,154,380-------3,154,380 150,000------150,000- 2,174,000---264,000100,000100,000-1,710,000 13,000,000-------13,000,000 267,410-------5,067,5905,335,000 345,000------120,000225,000 35,000------35,000- 280,000-------200,000480,000 1,650,000------1,500,000150,000 2,074,000------700,0001,374,000 896,100-------896,100 5,692,000------200,0005,492,000 9,000,0003,000,0003,000,000600,000600,000600,000600,000600,000- 300,000------150,000150,000 305,000-----140,000-165,000 510,000-------510,000 1,757,000-----195,000-1,562,000 June 8, 2021 Item #11 Page 158 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Hosp Grove Park Improvements District 1 Low 47281 IRF Hydroelectric Generation at Water Facilities District 2 Medium 50591 WATER CONN Intelligent Traffic Control Devices Multiple Districts Low 66341 GAS TAX Jefferson Street Sustainable Mobility Plan Improvements District 1 High 70001 Gas Tax Kelly Drive and Park Drive Complete Street Improvements Multiple Districts Critical 60751 TRANSNET- LOC 60753 GAS TAX 60754 PFF Kelly Drive Channel Repair District 2 Medium 66061 IRF La Costa Avenue Sustainable Mobility Plan Improvements District 4 High 70011 Gas Tax La Costa Avenue Traffic ImprovementsDistrict 4 Medium 60761 GAS TAX Laguna Drive Storm Drain District 1 Medium 66281 GAS TAX Lake Calavera Outlet Improvements District 2 High 50541 GCC Lake Calavera Reservoir Maintenance District 2 High 50492 GCC Lake Calavera Trails Master Plan/Construction (Prop C)District 2 Medium 38661 GCC Las Flores Drive Sustainable Mobility Plan Improvements District 1 High Temp1 Gas Tax Las Palmas Roof Replacement District 2 Medium 47521 IRF Las Palmas Trunk Sewer District 2 High 55401 SEWER CONN Left Turn Lane Extensions Multiple Districts High 60771 GAS TAX Leo Carrillo Ranch Park Phase 3 - Stables Restoration and Restroom Construction District 2 Low 46021 PFF 46022 PIL-SE 46023 PFF Leo Carrillo Ranch Roof Repairs District 2 High 47481 IRF Library Fire Alarm Panel Upgrades Multiple Districts Low 47411 IRF Limited Access Pipeline Relocation Program Multiple Districts Critical 50351 WATER REPL 2,275,000-----1,875,000200,000200,000 200,000-------200,000 75,000------75,000- 4,175,000-------4,175,000 130,000-------130,000 1,085,000------1,085,000- 1,041,000-------1,041,000 110,000------110,000- 863,000-----741,700100,00021,300 2,750,000-1,494,0001,000,000----200,000456,000 1,436,001------40,0001,396,001 531,001-------531,001 1,128,250-------1,128,250 85,000-----85,000-- 500,000------500,000- 3,463,000-----2,907,000-556,000 200,000-------200,000 1,631,500-------1,631,500 1,334,100-------1,334,100 29,655-------29,655 1,450,000------1,100,000350,000 180,000-------180,000 June 8, 2021 Item #11 Page 159 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Library Fire Alarm Panel Upgrades Multiple Districts Low 47411 IRF Limited Access Pipeline Relocation Program Multiple Districts Critical 50351 WATER REPL Loan repay - Park-in-Lieu SW to Public Facility Fee Fund Null Null Null PIL-SW Loan Repay - Sewer Conn to Sewer Repl Null Null Null SEWER CONN Loan Repayment Park-in-Lieu NE to Public Facility Fee Fund Null Null Null PIL-NE Maerkle Facility Improvements District 2 Critical 50091 WATER REPL Maerkle Reservoir Floating Cover Replacement District 2 Critical 50361 WATER REPL Maerkle Reservoir Solar Project District 2 Medium 47221 GCC Maerkle Reservoir Transmission Main District 2 Medium 50011 WATER REPL Marca Place Drainage Improvements District 4 Medium 66141 GAS TAX Melrose Drive and Alga Road Dual Left Turn Lanes (RTCIP)District 2 Low 19531 TIF Melrose Drive Right Turn Lane to West Bound Palomar Airport Road District 2 Critical 60341 TIF Miscellaneous City Building Improvements Multiple Districts Medium 47231 IRF Monroe Street Pool Replacement District 1 High 47241 IRF 47242 GCC New Village Arts Building Roof and Exterior Refurbishment District 1 Low 47391 IRF Normally Closed Valve (Install Motorized Valve)District 2 High 50501 WATER REPL North Batiquitos Access Road Improvement District 4 High 55471 SEWER REPL North Batiquitos Lift Station Forcemain Rehabilitation District 4 Medium 55361 SEWER REPL Ocean Street Reconfiguration Concepts Study District 1 Medium 60781 GCC Ocean Street Restroom Facility District 1 Medium 47291 GCC Odor and Corrosion Prevention Assessment Multiple Districts Medium 55201 SEWER REPL Open Space and Trail Acquisition (Prop C) Multiple Districts High 40831 GCC 35721 CFD#1 4,940,000----1,000,0002,000,000-1,940,000 1,100,0001,100,000------- 4,700,0004,700,000------- 4,550,0004,550,000------- 2,235,200-------2,235,200 11,032,844-------2,022,15613,055,000 250,000-----249,170-830 6,330,000----4,557,0001,000,000-5,557,0006,330,000 65,000-------65,000 1,237,0001,237,000------- 911,000------200,000711,000 3,665,000750,000750,000-150,000150,000150,000150,0001,565,000 6,187,000-------6,187,000 62,000-------62,000 313,626-------313,626 485,000-------485,000 340,000-----90,000-250,000 950,000------400,000550,000 200,000-----200,000-- 775,000-------775,000 320,000-------320,000 4,015,000-------4,015,000 June 8, 2021 Item #11 Page 160 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceOpenSpaceandTrailAcquisition(Prop C) Multiple Districts High 40831 GCC Orion Center District 2 High 35721 CFD#1 35722 WATER REPL 35723 SEWER REPL 35724 CFD#1 35725 RECL REPL Palomar Airport Road and Avenida Encinas Growth Management Plan Im.. Multiple Districts High 70021 Gas Tax Palomar Airport Road and College Boulevard Improvements District 2 Critical 60281 TIF Palomar Airport Road/El Fuerte Street Right Turn Lane District 2 Low 19581 TIF Palomar Airport Road/Paseo Del Norte Left Turn Lane Extension Multiple Districts High 60431 Gas Tax 60432 TRANSNET- LOC Palomar Airport Road/Paseo Del Norte Right Turn Lane Multiple Districts High 60441 Gas Tax 60442 TRANSNET- LOC Palomar Airport Waterline Realignment District 2 High 50551 WATER REPL Park Drive Street and Drainage Improvement District 1 Critical 66111 GCC 66112 GAS TAX Parking Lot Maintenance Program Multiple Districts High 60521 IRF Pavement Management Program Multiple Districts High 60011 TRANSNET- LOC 60012 GAS TAX 60013 TRANSNET- LOC 60016 RMRA Pine Avenue Park - Phase II (Community Building) District 1 Medium 46031 PIL-NW 46032 PFF 46033 PFF 34,717,156------721,89033,995,266 6,789,409------139,0106,650,399 4,078,500------83,5003,995,000 541,000-------541,000 2,715,600------55,6002,660,000 230,000------230,000- 1,295,500------300,000995,500 1,198,000-1,198,000------ 194,546------50,000144,546 250,277-------250,277 430,538------80,000350,538 925,639-------925,639 1,750,000------750,0001,000,000 717,439-------717,439 3,965,000-----1,030,0001,070,0001,865,000 2,860,000475,000475,000130,00060,000130,00060,000500,0001,030,000 37,186,5637,500,0007,500,0001,500,0001,500,000---19,186,563 7,927,219-------210,9118,138,130 30,546,4765,500,0005,500,0001,100,0001,100,0001,600,0001,600,0002,600,00011,546,476 34,636,0009,500,0009,500,0001,900,0001,900,0001,900,0001,900,0001,900,0006,136,000 2,197,000-------2,197,000 10,016,040-------10,016,040 June 8, 2021 Item #11 Page 161 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Pine Avenue Park - Phase II (Community Building) District 1 Medium 46032 PFF 46033 PFF Poinsettia Community Park - Phase 3 District 3 Medium 46051 PFF 46052 PFF Poinsettia Community Park - Phase 4 - Dog Park District 3 High 46081 PFF 46082 PFF Poinsettia Lane - Cassia Road to Skimmer Court (Reimbursement Agre..District 3 Medium 50451 WATER CONN Poinsettia Lane - Reach E Cassia Road to Skimmer Court District 3 High 39221 BTD#2 Poinsettia Lane - Reaches A,B,C,F,G and Aviara Parkway Reimbursement District 2 High 19591 BTD#2 Poinsettia Lane Widening - Paseo Del Norte to Batiquitos Drive (RTCIP)District 3 Medium 19601 TIF Police and Fire Headquarters Renovation District 2 High 47151 IRF 47152 GCC Pressure Reducing Station Program Multiple Districts Critical 50201 WATER REPL Public Beach Access Improvements (Ocean Street) District 1 Low 60571 GCC 60572 IRF Railroad Double Tracking Multiple Districts Low 60591 GCC Rancho Carlsbad Groundwater Supply District 2 Low 19621 WATER CONN 19622 WATER REPL Rancho Santa Fe Trail Slope Improvements District 4 High 60881 GCC Recycled Water Condition Assessment Program Multiple Districts Critical 52111 RECL REPL Recycled Water Line - Carlsbad Water Recycling Facility to Agua Hedionda Lagoon Multiple Districts Critical 50271 WATER REPL 50272 RECL WATER Recycled Water Phase 3 - Pipelines Multiple Districts Critical 52081 WATER REPL 52082 RECL WATER 123,300-------123,300 5,231,475-------5,231,475 43,225-------43,225 2,792,000------731,0002,061,000 21,140-------21,140 600,000-------600,000 14,081,200-------14,081,200 1,168,8331,168,833------- 1,039,0001,039,000------- 5,953,050-------5,953,050 2,013,500-------2,013,500 12,462,0003,000,0003,000,000600,000600,000600,000600,000600,0003,462,000 3,610,336-------3,610,336 726,683-------726,683 560,105-------560,105 1,750,000-1,425,000---125,000200,000- 1,750,000-1,425,000---125,000200,000- 350,000-------350,000 1,490,000310,000280,00050,00050,00050,00050,00050,000650,000 1,632,594-------1,632,594 3,417,406-------3,417,406 2,497,529-------2,497,529 June 8, 2021 Item #11 Page 162 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Recycled Water Phase 3 - Pipelines Multiple Districts Critical 52081 WATER REPL 52082 RECL WATER Recycled Water Phase 3 - Reservoir District 3 High 52101 WATER REPL 52102 RECL WATER Recycled Water Pipeline Replacement District 2 High 19541 RECL REPL Recycled Water Valve and Appurtenance Replacement Program Multiple Districts Critical 52121 RECL REPL Reservoir Repair and Maintenance Program Multiple Districts Critical 50241 WATER REPL Retroreflectivity Sign Replacement Program Multiple Districts Medium 60371 GAS TAX Roadway Improvements - Coastal Area Analysis and Implementation Multiple Districts Medium 60791 GCC Roadway Slope Stabilization Multiple Districts High 60811 GAS TAX Robertson Ranch Park Development (Partial Funding) District 2 Medium 38011 PIL-NE 38012 PFF Romeria Drainage Improvements District 4 High 66041 GCC 66042 GAS TAX Safety Training Center Settlement District 2 Low 47431 GCC San Luis Rey Mission Basin Groundwater Supply Multiple Districts Low 50441 WATER CONN 50442 WATER REPL Santa Fe II Inlet Pipeline Null High 50571 WATER REPL Santa Fe II Reservoir Site Electrical Improvements District 2 Medium 50461 WATER REPL SCADA Improvements Multiple Districts Critical 55421 SEWER REPL 55422 WATER REPL 55423 RECL REPL Schulman Auditorium and Cannon Art Gallery District 3 Medium 47531 IRF Senior Center Refurbishment District 1 Medium 47381 IRF 21,256,331-------21,256,331 980,000-------980,000 3,120,000-------3,120,000 6,110,0002,910,0002,150,000350,000350,000350,000--- 1,830,000700,000630,000-120,000-120,000-260,000 14,490,0003,610,0003,070,000--1,960,000--5,850,000 1,240,000-----240,000-1,000,000 200,000-------200,000 900,000-----320,000166,000414,000 2,850,000----2,450,000-200,000200,000 12,592,000----12,592,000--- 410,000-------410,000 347,940-------347,940 1,156,995-------1,156,995 8,577,5002,500,0005,500,000---300,000200,00077,500 8,577,5002,500,0006,000,000-----77,500 2,865,000-----2,370,000-495,000 33,581-------116,419150,000 4,684,632---380,734175,165-2,160,9331,967,800 10,155,600---610,5002,412,5003,209,2001,858,1002,065,300 2,394,000---398,000337,600631,500381,500645,400 200,000------200,000- June 8, 2021 Item #11 Page 163 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceSchulmanAuditoriumandCannonArt Gallery District 3 Medium 47531 IRF Senior Center Refurbishment District 1 Medium 47381 IRF Senior Center Security Fencing District 1 Low 47541 IRF Sewer Condition Assessment Multiple Districts Critical 55131 SEWER REPL Sewer Lift Station Repairs and Upgrades Multiple Districts Critical 38401 SEWER REPL Sewer Line Capacity Improvements Multiple Districts High 55481 SEWER REPL Sewer Modeling Multiple Districts Low 55461 SEWER CONN Sewer Monitoring Program (Capacity)Multiple Districts Critical 55041 SEWER CONN Sewer System Rehabilitation and Replacement Multiple Districts High 55031 SEWER REPL Sidewalk/Street Construction Program Multiple Districts High 60021 TIF 60022 GAS TAX South Shore Agua Hedionda Lagoon Trail District 2 High 40851 GCC Stagecoach Park Synthetic Turf Replacement District 4 Low 47421 IRF State Street and Grand Avenue Road Improvements District 1 Medium 60821 TRANSNET- LOC State Street Parking Lot Electric Vehicle Charging Stations District 1 Medium 41901 PFF Storm Drain Condition Assessment Multiple Districts High 66201 IRF Storm Drain System Rehab and Repair Program Multiple Districts High 66071 IRF Street Lighting Replacement Program Multiple Districts High 60621 GCC 60622 TRANSNET- LOC Tamarack Avenue Sustainable Mobility Plan Improvements District 2 Medium Temp1 Gas Tax Temporary Fire Station No. 7 District 2 High 41911 GCC Terramar Area Coastal Improvements District 2 High 60541 TIF 60542 GCC 60543 TRANSNET- LOC 1,248,000-------1,248,000 78,000-----58,00020,000- 3,358,000750,000750,000100,000100,000100,000100,000-1,458,000 6,335,380750,000750,000150,000150,000150,000150,0001,150,0003,085,380 3,073,000-----2,873,000-200,000 300,000-------300,000 950,000110,000154,000-44,000---642,000 41,726,47514,050,00013,350,0001,850,0001,850,0001,200,0001,200,000850,0007,376,475 4,600,000---300,000300,000200,000300,0003,500,000 3,300,0001,500,0001,500,000300,000----- 755,500------36,000719,500 2,200,000-------2,200,000 325,000-----325,000-- 300,000------300,000- 3,400,0001,000,0001,000,000200,000200,000200,000200,000-600,000 8,831,3601,520,0001,520,000200,000200,000200,000200,000200,0004,791,360 319,269-------319,269 3,325,000-------3,325,000 710,000----510,000200,000-- 900,000------900,000- 6,650,001-------6,650,001 999,999-------999,999 June 8, 2021 Item #11 Page 164 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Terramar Area Coastal Improvements District 2 High 60542 GCC 60543 TRANSNET- LOC 60544 SEWER REPL 60545 PFF The Crossings Golf Course Lake Liner Replacement District 2 High 40841 GCC Traffic Control Improvements - Poinsettia Lane and Cassia Road Multiple Districts High 63292 GAS TAX Traffic Control Improvements - Poinsettia Lane and Oriole Court District 3 High 63302 GAS TAX Traffic Impact Fee Funds to CFD #1 Null Null Null TIF Traffic Impact Fee Update Multiple Districts High 60401 TIF Traffic Improvement Program Multiple Districts Critical 60701 GAS TAX 60702 GCC Traffic Monitoring Program Multiple Districts High 60031 TIF Traffic Signal - Faraday Avenue and Camino Hills Drive District 2 Medium 63311 GAS TAX Traffic Signal - La Costa Avenue and Levante Street District 4 Low 39381 GAS TAX Traffic Signal - Maverick Way and Camino De Los Coches District 4 Critical 63322 GAS TAX Traffic Signal - Poinsettia Lane and Brigantine Road Multiple Districts Low 19711 GAS TAX Traffic Signal - Tamarack Avenue and Valley Street District 1 Medium 19721 GAS TAX Traffic Signal Master Plan Multiple Districts High 63331 GCC Traffic Signal Operations Modifications Multiple Districts Medium 63271 GAS TAX Trail Connectivity to Tamarack State Beach (Prop C)District 1 Low 40631 GCC Transfer Fire Station No. 4 Funds to General Fund District 3 Null Null IRF Tri-Agency Water Transmission Pipeline Replacement District 2 High 50081 WATER REPL Utility Undergrounding Program Study Multiple Districts Medium 60831 GCC Vallecitos Interceptor Sewer Cleaning andCCTV Multiple Districts High 55491 SEWER REPL 1,000,000-------1,000,000 --------1,000,0001,000,000 2,450,000------2,450,000- 1,035,500------200,000835,500 411,000-------411,000 411,000-------411,000 1,944,0001,404,00090,00090,00090,00090,00090,00090,000- 240,000------40,000200,000 2,388,000------400,0001,988,000 400,000-----400,000-- 2,198,900-288,000-96,00096,00096,00096,0001,526,900 210,000----210,000--- 250,000-------250,000 140,000-------140,000 210,000----210,000--- --------- 150,000-------150,000 180,000-------180,000 3,276,000----3,123,844--152,156 5,070,000------5,070,000- 6,455,000-----2,836,030-2,836,0306,455,000 100,000-----100,000-- June 8, 2021 Item #11 Page 165 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding Source Utility Undergrounding Program Study Multiple Districts Medium 60831 GCC Vallecitos Interceptor Sewer Cleaning and CCTV Multiple Districts High 55491 SEWER REPL Valley and Magnolia Complete Streets District 1 High 60191 TIF 60192 WATER REPL 60193 TRANSNET- LOC Valley Street Road Diet and Traffic Calming District 1 Medium 19741 TRANSNET- LOC Veteran's Memorial Park (All Quadrants) Multiple Districts Critical 46091 CFD#1 Village and Barrio Traffic Circles District 1 High 40151 GCC 40152 TRANSNET- LOC 40153 SEWER REPL 40154 GAS TAX Village Decorative Lighting District 1 Medium 40161 GCC Village H South Off Leash Dog Area and Trail Segment 5B District 2 Medium 46101 PFF Village Intelligent Parking Implementation District 1 Low 60891 GCC Village Public Gathering Spaces Study District 1 Medium 40611 GCC Villas Sewer Lift Station Replacement District 2 Critical 55501 SEWER REPL Vista Carlsbad Interceptor - Agua Hedionda LS and Forcemain (VC12-VC..District 2 Critical 34921 SEWER CONN Vista Carlsbad Interceptor - Buena Vista Lift Station Improvements District 1 Critical 55351 SEWER CONN Vista Carlsbad Interceptor - Lagoon Bridge Replacement (VC11B) Multiple Districts Critical 38861 SEWER CONN Vista Carlsbad Interceptor - Reach VC3 District 1 Critical 39501 SEWER CONN Vista Carlsbad Interceptor - Reach VC14 To VC15 Multiple Districts High 39491 SEWER CONN Vista Carlsbad Interceptor - Rehabilitation (VC1 and VC2)District 2 Critical 55511 SEWER REPL Water Infrastructure Condition Assessment Program Multiple Districts Critical 50511 WATER REPL Water Loss Monitoring Program Multiple Districts High 50521 WATER REPL 250,000-------250,000 3,536,206-------3,536,206 71,000-------71,000 1,200,000-----1,200,000-- 1,645,000-----1,645,000-- 27,547,200---22,085,0001,175,0001,175,0001,275,0001,837,200 415,000-------415,000 1,025,000-------1,025,000 160,000-------400,000560,000 2,759,000------584,0002,175,000 1,103,853-----400,000-703,853 1,394,800-----872,80067,000455,000 300,000-----300,000-- 345,000-----345,000-- 1,090,000------960,000130,000 31,175,821-------31,175,821 4,346,000-3,150,000---800,000-800,0001,196,000 9,464,833-------9,464,833 2,689,000----2,092,000--597,000 21,350,390-------21,350,390 1,936,000-----1,795,000-141,000 8,170,0002,480,0002,250,000420,000420,000410,000410,000400,0001,380,000 June 8, 2021 Item #11 Page 166 of 336 Project Name District Score Funding ID Funding Source Prior Appropriation Year 1 (2021-22) Year 2 (2022-23) Year 3 (2023-24) Year 4 (2024-25) Year 5 (2025-26) Year 6-10 (2027-31) Year 11-15 (2032-36) Total Funding SourceWaterInfrastructureCondition Assessment Program Multiple Districts Critical 50511 WATER REPL Water Loss Monitoring Program Multiple Districts High 50521 WATER REPL Water Modeling Multiple Districts Low 50581 WATER CONN Water System Rehabilitation and Replacement Multiple Districts Critical 39041 WATER REPL Water Valve Repair/Replacement Program Multiple Districts Critical 50191 WATER REPL 1,700,000500,000500,000100,000100,000100,00050,000-350,000 425,000---25,00025,00025,00050,000300,000 62,028,36621,080,00019,890,0003,000,0003,000,0002,800,0002,690,0001,730,0007,838,366 21,500,0005,650,0005,110,000960,000960,000960,000940,000930,0005,990,000 June 8, 2021 Item #11 Page 167 of 336 PERSONNEL ALLOCATIONS  Adopted Adopted Adopted Proposed Budget Budget Budget Budget Department(*) 2018‐19 2019‐20 2020‐21 2021‐22 City Attorney 7.00 8.00 8.00 8.00 City Clerk Services 7.00 7.00 7.00 7.00 City Council 2.00 2.00 2.00 2.00 City Manager 9.00 12.00 7.00 7.00 City Treasurer 0.75 1.00 1.00 1.00 Communication & Engagement 7.00 7.00 7.00 7.00 Administrative Services ‐ Administration 0.00 0.00 0.00 3.00 Finance 30.00 31.00 31.00 28.00 Human Resources 13.00 17.00 17.00 16.00 Information Technology 32.00 35.00 37.00 37.00 Innovation & Economic Development 3.00 2.00 4.00 4.00 Community Services ‐ Administration 0.00 0.00 3.00 3.00 Community Development 59.75 63.75 61.75 67.00 Library & Cultural Arts 50.50 52.50 52.50 52.50 Parks & Recreation 55.00 55.00 55.00 55.00 Fire 92.00 97.75 97.75 111.00 Police 170.00 184.00 184.00 186.00 Public Works 166.75 172.75 172.75 177.75 Total Full‐Time Personnel 704.75 747.75 747.75 772.25 Hourly Full‐Time Equivalent Personnel 185.87 199.97 186.59 193.81 Total 890.62 947.72 934.34 966.06 *Notes: FY 2018‐19, includes reorganization of (5.0) FTE from Police ‐ IT to Administrative Services ‐ IT. FY 2019‐20, includes reorganizations within Finance, Human Resources, Community Development, and Police; as well as an increase of (2.0) FTE for Police approved by City Council mid‐year. This table excludes paid interns, due to transitional nature of intern employment. FY 2020‐21, includes reorganization of (5.0) FTE from City Manager to Comm. Serv. Admin. and Innovation &  Economic Development. FY 2021‐22, includes reorganization of (1.0) FTE from Human Resources to Fire, (3.0) FTE from Finance to  Administrative Services ‐ Administration, and (1.0) from Police to Community Development, as well as an  increase of (3.0) FTE for Police approved by City Council in FY 2020‐21. Attachment C June 8, 2021 Item #11 Page 168 of 336 FIVE‐YEAR SCHEDULE OF SDTIP PROJECTS BY FUND ConnectedEstimated Estimated Estimated Estimated Estimated EstimatedFunding Carlsbad Funding Project Prior Year 1 Year 2 Year 3 Year 4 Year 5TotalProject NameSource Goal ID Type Appropriation 2021‐22 2022‐23 2023‐24 2024‐25 2025‐26 FundingInnovation FundAudio Visual UpgradesIF FVCEC 95371 Major 525,000$        100,000$        100,000$        100,000$        100,000$        100,000$        1,025,000$    Civic Engagement with Open DataIF EAT NA Major‐180,000          ‐‐‐‐     180,000       Computer Aided Dispatch (CAD)IF PSSC NA Major‐1,000,000       ‐‐‐‐     1,000,000    Consolidation & Replacement of Core SystemsIF PCDT 95921 Major 400,000          ‐2,000,000       2,000,000       ‐‐     4,400,000    Cyber Security Program DevelopmentIF PSSC NA Major 250,000          100,000          100,000       100,000          100,000          100,000          750,000       Data Governance and Operational AnalyticsIF BCDDM NA Major‐295,000          ‐‐‐‐     295,000       Digital Engagement & Analytics ConsultantIF FVCEC 95911 Major 200,000          ‐‐‐‐‐     200,000       Digital Information NetworkIF PCDT 95891 Major 4,725,584       100,000          ‐‐‐‐     4,825,584    Discovery Management AssessmentIF BCDDM NA Major‐30,000            ‐‐‐‐     30,000         Enterprise Asset Management SystemIF PCDT NA Major 100,000          1,000,000       500,000          ‐‐‐     1,600,000    Enterprise Digital Asset ManagementIF EAT NA Major‐50,000            ‐‐‐‐     50,000         Exploration Hub Audio Visual UpgradeIF EAT NA Major‐41,852            ‐‐‐‐     41,852         Facility Security Master PlanIF PSSC 95811 Major 100,000          ‐‐‐‐‐     100,000       Financial System UpgradeIF PCDT 95691 Major 500,000          ‐‐‐‐‐     500,000       Intranet UpgradeIF PCDT NA Major‐‐60,000            ‐‐‐     60,000         Learning Management System (LMS)IF PCDT 95971 Major 410,000          ‐‐‐‐‐     410,000       Mobile Computer ProgramIF PCDT 95841 Major 350,000          ‐‐‐‐‐     350,000       Next Generation Online CatalogIF EAT NA Major‐40,000            ‐‐‐‐     40,000         OKTA/ServiceNow AutomationIF PCDT NA Major 200,000          (200,000)        ‐‐‐‐     ‐               Online Permitting/Electronic Reviews (E‐Reviews)IF EAT NA Major‐645,000          ‐‐‐‐     645,000       Outdoor Wireless Study IF FVCEC NA Major 100,000          ‐‐‐‐‐     100,000       Project Portfolio Management Tool & ConsultingIF PCDT 95821 Major 200,000          300,000          ‐‐‐‐     500,000       Records Management System ExpansionIF EAT 95871 Major 533,128          110,420          ‐‐‐‐     643,548       ServiceNow SAM ImplementationIF PCDT NA Major 150,000          ‐‐‐‐‐     150,000       ServiceNow Service PortalIF PCDT NA Major 150,000          ‐‐‐‐‐     150,000       Teleconferencing Services for Public MeetingsIF FVCEC 95961 Major 240,000          (90,000)           ‐‐‐‐     150,000       Timekeeping System UpgradeIF PCDT NA Major‐‐120,000          ‐‐‐     120,000       Virtual Permitting CounterIF EAT NA Major‐61,000            23,000            ‐‐‐     84,000         Global Positioning System (GPS) Technology HardwareIF PCDT NA Minor45,916            ‐‐‐‐‐     45,916         Innovation Fund Total9,179,628       3,763,272       2,903,000       2,200,000       200,000          200,000          18,445,900    Information Technology Replacement FundAnnual Hardware and Infrastructure ReplacementITR PSSC NA Major Annual 1,102,635       920,000       1,030,000       1,485,000       1,110,000       5,647,635    Unified Communications SystemITR PSSC NA Major 2,200,000       ‐‐‐‐‐     2,200,000    Information Technology Replacement Fund Total2,200,000       1,102,635       920,000          1,030,000       1,485,000       1,110,000       7,847,635    Local Cable InfrastructureCouncil Chamber Technology UpgradeLCI FVCEC NA Major 150,000          ‐‐‐‐‐     150,000       PendingMeter Data Management/Utility AnalyticsPending BCDDM NA Major‐‐500,000          ‐‐‐     500,000       11,529,628$  4,865,907$    4,323,000$    3,230,000$    1,685,000$    1,310,000$    26,943,535$  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 = PCDTDIGITAL TRANSFORMATION AND TECHNOLOGY INVESTMENT PROJECTSConnected Carlsbad GoalProjectsTotalAttachment D June 8, 2021Item #11 Page 169 of 336