Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Engineering Department FY21 Budget Presentation
City of Dubuque Public Hearings # 4. ITEM TITLE: SUMMARY: SUGGESTED DISPOSITION: Copyrighted April 16, 2020 Engineering Department FY21 Budget Presentation ATTACHMENTS: Description Type Engineering Department FY21 Policy Budget Outline Supporting Documentation Presentation Supporting Documentation Engineering -109- This page intentionally left blank. -110- ENGINEERING DEPARTMENT Budget Highlights Expenses Employee Expense Supplies and Services Machinery and Equipment Payment to Construction Fund Less Recharges to Service Funds Administrative Overhead Charges Total Expenses Resources Operating Revenue - General Lease Expense Reimbursement Administrative OH Recharges Road Use Tax Funds Utility Charges - Parking Utility Charges - Water Utility Charges - Stormwater Utility Charges - Sanitary Total Resources Debt Service Stormwater debt abated with Stormwater User Fees Stormwater debt abated with Sales Tax Increment Street Projects Debt abated with Sales Tax Fund (30%)/RUT America's River Debt Abated with TIF & General Total Debt Service Property Tax Support Percent Increase/(Decrease) FY 2019 Actual 2,753,468 1,339,936 321,971 1,525,000 (1,392,720) 469,385 FY 2020 FY 2021 % Change From Budget Requested FY 2020 Budget 2,970,550 1,504,928 566,194 1,210,000 (1,619,636) 527,544 3,098,790 1,664,443 747,433 880,000 (1,675,236) 608,650 5,017,040 5,159,580 5,324,080 60,515 145,691 109,716 105,746 94,596 110,614 411,666 390,986 399,221 296,963 499,494 702,317 2,045 - 2,832 33,400 20,010 20,707 3,086,549 2,914,854 2,775,669 159,611 280,899 251,566 4,156,495 4,346,530 4,372,642 1,866,877 2,161,259 2,759,445 2,642,669 2,562,323 2,561,881 251,865 246,836 244,287 892,736 883,286 883,275 5,654,147 5,853,704 6,448,888 860,545 813,050 Personnel - Authorized FTE 30.23 29.96 951,438 30.71 4.3 % 10.6 % 32.0 % (27.3)% 3.4% 15.4 % 3.2 % (24.7)% 16.9 % 2.1 % 40.6 % - 3.5 Vo (4.8)% (10.4)% 0.6 % 27.7 % 10.2 % 138,388 17.0 % -111- STORMWATER UTILITY Budget Highlights Expenses Employee Expense Supplies and Services Payment to Construction Fund Less Recharges to Service Funds Machinery and Equipment Administrative Overhead Recharge Park Stormwater Maintenance Charges Public Information Office Public Works Stormwater Maintenance Charges Debt Service Total Expenses Resources Operating Revenue Sales Tax Increment Total Resources Net Operating Surplus (Deficit) Personnel - Authorized FTE Stormwater User Fee Rate Increase Stormwater User Fee (per SFU) Revenue 1% Rate Increase Generates FY 2019 FY 2020 FY 2021 % Change From Actual Budget Requested FY 2020 Budget 352,317 771,077 669,450 (13.2)% 723,771 813,491 932,982 14.7 % 1,525,000 1,210,000 880,000 (27.3)% (134) (552,757) (457,783) (17.2)% 16,210 75,186 70,620 (6.1)% 469,385 527,544 608,650 15.4 % 111,094 202,644 122,777 (39.4)% 70,313 71,750 2.0 % 282,721 258,342 284,305 10.0 % 4,509,546 4,723,582 5,321,326 12.7 % 7,989,910 8,099,422 8,504,077 5.0 % 5,252,452 5,544,639 5,928,093 6.9 % 2,642,669 2,562,323 2,561,881 — % 7,895,121 8,106,962 8,489,974 4.7 % (94,789) 7,540 (14,103) (21,643) 5.85 5.70 4.78 6.75% 6.74% 6.83% $ 7.76 $ 8.29 $ 8.85 $ 48,494 Improvement Package Summary 1 of 10 This improvement request is to upgrade an existing, vacant position within the Engineering Department from an Engineering Technician (GE-31) to Civil Engineer (GE-38). The Civil Engineer position would be staffed with an individual with environmental/water resource expertise. The Civil Engineer would oversee activities associated with the compliance with the City's National Pollution Discharge Elimination System (NPDES) Municipal Separate Storm Sewer System (MS4) permit and that portion of the City's NPDES wastewater treatment permit (and associated consent decree with the EPA) related to the sanitary sewer collection system. In addition, the improvement request would provide an additional $50,000 for growing the City's partnership with Dubuque County and the Dubuque Soil & Water Conservation District through an existing 28e agreement. The total cost of the improvement package (recurring) would be $66,449.00, split between the stormwater utility (+$19,731) and sanitary sewer (+$46,736) funds. -112- Related Cost: Related Cost: Related Cost: Related Cost Savings: Total Cost: Stormwater User Fee Impact Sanitary User Fee Impact Activity: Stormwater/Sanitary $5,485 Sanitary User Fee $46,344 Internal Service Fund $65,969 Stormwater User Fee $48,722 Stormwater User Fee 69,076 1.36% 0.54% Recurring Recurring Recurring Recurring Recommend - Yes 2 of 10 This decision package would provide for a full-time employee in the position of Camera Systems Technician (Camera and Traffic Networking GE-28B). The city has roughly 1,200 cameras to manage. Approximately 2 - 5% of the cameras are down at any one time. Maintenance of the existing system is overwhelming field staff constantly and additional help is needed to fulfill new camera requests while also providing assistance to the maintenance and upgrading of existing systems. The addition of a Camera Systems Technician would significantly reduce camera downtime, and improve the reliability and functionality of the citywide traffic camera surveillance system. This position would be utilized to shorten camera repair response time, while at the same time reduce ongoing installation and maintenance costs associated with outsourcing these services to commercial vendors. Currently many of the City's cameras and associated networking equipment are out of service on a regular basis. The lack of available city staff to respond to service requests leads to a delay in restoration of services, sometimes taking weeks at a time to restore equipment. The City of Dubuque's camera surveillance system is heavily leveraged by many departments and has become a key component of the City's public safety infrastructure. The system is used daily for several observational tasks including dispatcher reference, vehicle accident investigations, traffic flow improvement operations, drug task force investigations, construction project inspection, construction contractor claims investigation, emergency management storm event tracking, parking division monitoring and various other types of criminal investigations. The Camera Systems Technician would provide the following services to the department: 1. Configure, install and test low voltage communications. 2. Install and configure IP equipment in the field and in the Traffic Operations Center. This includes items such as cameras, network equipment, vehicle detection sensors, street lighting controllers, and other camera and vehicle transportation control system equipment. 3. Install and maintain automated control systems operation for enhance traffic flow, including, but not limited to: radio, cellular, fiber, and Ethernet communications systems, programmable logic controller hardware and software maintenance. 4. Knowledge and hands on experience of surge protection including proper grounding and bonding techniques to provide greater protection to City infrastructure from lightning strikes. 5. Application of the NEC, NEMA and MUTCD standards to the traffic camera surveillance system. 6. Knowledge and experience in servicing fiber optic communication systems. 7. Electrical schematic and construction plan reading. 8. Construction inspection related to traffic camera surveillance systems. This improvement package supports the organizational goal of Financially Responsible City Government and High Performance City Organization and Partnership for a Better Dubuque, and Connected Community. It also aides in the Management Agenda High Priority of Community Security /Surveillance System Expansion because it will allow new camera placements at a quicker rate, higher quality data provided with timely equipment upgrades, and an additional staff member to aide in all aspects of camera maintenance. -113- Related Cost: Related Cost: Related Cost: Total Cost: Property Tax Impact: Activity: Traffic Engineering $33,777 General Fund Recurring $32,672 Internal Service Fund Recurring $10,300 General Fund Non -Recurring $76,749 $ 0.0173 0.17% Recommend - Yes 3 of 10 This decision package would provide for the upgrading from a small car to a small 4-wheel drive pickup. The traffic engineer position needs to ability to go onto unimproved construction sites, jump curbs, etc in performance of their work. Additionally, a small car is not conducive to carrying traffic paint and aerosol cans, lathe, flags and other equipment. This vehicle also would carry the engineering department drone and requires more room than a small car. This improvement directly relates to Connected Community. Related Cost: Property Tax Impact: Activity: Traffic Engineering $ 7,500 Tax Funds $ 0.003 0.03% Non -Recurring Recommend - No 4 of 10 This decision package would provide for additional funding to maintain and rehab ditches within city right- of-way or on city property. Maintenance includes such things as mowing, vegetation removal, debris removal. Rehab includes minor grading and re -seeding. The additional funding will allow the City to hire contractors to better maintain ditches that are part of the overall public municipal separate storm sewer system (MS4) permitted as part of the federal clean water act. Currently, the City has been allocating $5,000 per year for this activity. The addition $10,000 will allow the City to address more ditch maintenance related issues on a more timely basis. Related Cost: $ 10,000 Stormwater User Fee Recurring Recommend - Yes Stormwater User Fee Impact 0.21% Activity: Stormwater 5 of 10 This improvement package would provide the funding to join the Iowa Stormwater Education Partnership (ISWEP). ISWEP is a member -driven organization formed in 2004 to address the educational needs of cities and others impacted by federal stormwater regulations. ISWEP focuses on two things: creating and providing its members with educational tools and resources and providing training. The educational tools can be used to help inform the public about the importance of clean stormwater and how to prevent pollution and soak up more rainfall and . They have been developed for various target audiences including city staff and councils, homeowners, builders, developers, contractors, business owners, and children. The training programs help to establish statewide standards to assist with implementation of stormwater regulations that includes the use and maintenance of appropriate pollution prevention practices. Events are held across the state every year. Additional training events address green infrastructure and urban stormwater management. The majority of Municipal Storm Sewer System (MS4) cities in Iowa are members of ISWEP. We are also comprised of educational organizations, professional firms, businesses, and individuals. Even though Dubuque has a robust stormwater and watershed program, citizens would benefit from further enhanced programs. Membership will also allow for the City to better share and collaborate with other communities across the state who deal with similar opportunities and challenges as Dubuque. Related Cost: Stormwater User Fee Impact Activity: Stormwater $ 5,250 Stormwater User Fee Recurring Recommend - Yes 0.11 -114- 6 of 10 This improvement package would provide the funding for adding automatic vehicle monitoring technology to all department vehicles. On a daily basis the Engineering Department staff make numerous daily trips from city hall to various project and inspection sites. For most personnel in the office, a trip into the field often results at multiple location stops during one trip. If better information was available relative to which staff were actively working in certain areas of the city, new requests for inspections or site visits could be dispatched by department administration staff in a much more efficient way. By eliminating unnecessary travel time, staff productivity will be increased. Related Cost: Related Cost: Related Cost: Related Cost: Related Cost: Related Cost: Total Cost: Property Tax Impact: Stormwater User Fee Impact: Sanitary User Fee Impact: Activity: Project Engineering $ 6,000 $ 1,000 $ 1,500 $ 1,440 $ 240 $ 360 $ 10,540 $ 0.0029 0.03% 0.02% Tax Funds Stormwater User Fees Sanitary User Fees Tax Funds Stormwater User Fees Sanitary User Fees 0.03% Non -Recurring Non -Recurring Non -Recurring Recurring Recurring Recurring Recommend - Yes 7 of 10 This decision package is for limited grant funding to assist low to moderate income individuals who lack financial capacity to pay for clearing of snow from sidewalks along public roadways. In past years the City has had to direct hire contractors to remove snow from public sidewalks adjacent to private residences. In some situations age or a physical disability prevents some homeowners from removing the snow themselves. The Engineering Department has also found that some of these individuals do not have the option to request assistance from friends or family. If this request is approved an application and financial assistance program formula will be developed. Assistance will go directly toward offsetting the cost of snow removal on a one-time or two-time per season basis until all funding is exhausted. Related Cost: Property Tax Impact: Activity: Project Engineering $ 5,000 Tax Funds Recurring Recommend - Yes $ 0.002 0.02% 8 of 10 This decision package is for a Traffic Intern (NA-34D, 624 hours annually, 0.30 FTE). This position would provide for an intern to be able to initially populate the database and make updates to reflect the continual changes that are happening as the result of new public -private partnerships, new city equipment installations, repairs, or modifications. The City's broadband public -private partnership initiative has been highly successful. In just the past two years the city has entered into numerous conduit or fiber optic cable sharing agreements with private entities that has resulted in a significant expansion of the City's fiber network or making multiple broadband service providers available to city businesses and residents. The time spent by city staff managing the locations and specific types of infrastructure shared as part of these agreements has grown significantly in the past two years. As future public -private partnerships are proposed, city staff is required to make trips to the field to inspect the roadside infrastructure in order to determine what city -owned broadband infrastructure is still remaining and available to be shared. In order to improve efficiently and best manage our infrastructure, the Engineering and Information Services Departments have recently invested in an industry specific software which actively manages fiber and conduit utilization in a database. Since none of the City's broadband infrastructure has been stored in this type of format, considerable time and effort is needed to initially populate the database with all -115- infrastructure that is owned by the City, including fiber counts, conduit configurations, traffic cabinets and server rack locations, rack mounted equipment at each location, and cable connections between various rack mounted equipment. An up-to-date and accurate database will save numerous hours of full time staff having to make site visits in order to assess and inventory existing city -owned broadband infrastructure. Related Cost: Property Tax Impact: Activity: Traffic Engineering $ 10,438 Tax Funds Recurring Recommend - No $ 0.0041 0.04% 9 of 10 This decision package is for fire extinguisher for each department assigned vehicle. All the Engineering vehicles regularly visit construction sites which can be inherently dangerous. Having fire extinguishers readily available on construction sites is an industry best practice and if ever needed can be essential in extinguishing any potential fires before they grow into catastrophic events. Since the vehicles travel extensively throughout Dubuque on a daily basis, having a fire extinguisher on board also provides a secondary benefit to Dubuque residents if one were ever needed in an emergency and staff happened to be nearby. Related Cost: Related Cost: Related Cost: Related Cost: Related Cost: Related Cost: Total Cost: Property Tax Impact: Stormwater User Fee Impact: Sanitary User Fee Impact: Activity: Project Engineering $ 720 Tax Funds $ 120 Stormwater User Fees $ 180 Sanitary User Fees $ 120 Tax Funds $ 20 Stormwater User Fees $ 30 Sanitary User Fees $ 1,190 $ 0.0003 0.003% 0.002% 0.004% Non -Recurring Non -Recurring Non -Recurring Recurring Recurring Recurring Recommend - Yes 10 of 10 This decision package is for software to manage critical fiber infrastructure. Most of today's critical infrastructure is controlled by complex network communications. These communications usually run via fiber optic and wireless connectivity. The platform for these communications is Ethernet which is comprised of a series of switches and computer equipment that runs across these communication lines. This same system connects employees together on their computers and phones also connects critical infrastructure used for water, flood control, storm sewer, wastewater, city surveillance, traffic control, Police and Fire communications, code blue phones and other critical public safety infrastructure. These systems will continue to grow and expand as the Internet of Things's expand. The importance of keeping these networks running at their optimal level is of vital importance. Troubleshooting these system to find the root cause of the network failure issue can be very laborious to nearly impossible without the supporting tools needed for this specialized task. This Path Solutions software was developed to resolve these critical network issues quickly and reduce the City's dependency on outside vendors for this type of help. In traffic, there is a vast network of equipment that demands constant care. There are intermittent users, which can actually create a void in performance since staff is not notified of issues when the problems arise. At times network problems occur when nobody is using or monitoring a particular network device. An example of this is the recording of surveillance footage on the video management software. Often staff is asked to pull footage of an occurrence that happened weeks ago. When pulling this footage, the video jumps and sometimes misses several seconds of video frames during critical moments that may be needed to solve a crime or accident investigation. These skipped frames are due to glitches in the network and can have various causes that are difficult to track down. Approval of this request would result -116- in higher network reliability and less money being spent on contracted vendors being hired to find network problems. Related Cost: Related Cost: Total Cost: Property Tax Impact: Activity: Traffic Engineering $ 30,240 Tax Funds Non -Recurring $ 5,600 Tax Funds Recurring $ 35,840 $ 0.0141 0.14% Significant Line Items Recommend - Yes Employee Expense 1. FY 2021 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution of 9.44% is unchanged from FY 2020 The employee contribution of 6.29% is unchanged from FY 2020. 3. The City portion of health insurance expense is increased from $921 in FY 2020 to $1,013 in FY 2021 per month per contract which results in an annual cost increase of $49,954 or 11.26%. 4. Overtime is unchanged from $72,640 in FY 2020 to $72,640 in FY 2021. FY 2019 actual was $79,982. 5. Five -Year Retiree Sick leave payout decreased from $11,977 in FY 2020 to $11,976 in FY 2021. 6. 50% Sick Leave Payout increased from $0 in FY 2020 to $14,473 in FY 2021 based on FY 2020 actual to -date. Effective July 1, 2019, employees over the sick leave cap can convert 50% of the sick leave over the cap to vacation or be paid out. 7. During FY 2020, the City Council approved a non -recurring engineering intern position to do a comprehensive update to the City's current policies and standards related to OSHA compliance and protection of the public during construction projects. This position will expire June 30, 2020. The elimination of this position in FY 2021 results in -0.25 FTE and a savings of $9,982. 8. The Fiscal Year 2021 budget includes the following changes in the funding allocation of positions: a. Civil Engineer I i. +0.25 FTE to General Fund (+$27,863) ii. +0.15 FTE to Sanitary Sewer Internal Service Fund (+$16,285) iii. +0.20 FTE to General Project Engineering Internal Service Fund (+$24,060) iv. -0.05 FTE from Sanitary Sewer Fund (-$5,429) v. -0.10 FTE from Stormwater Fund (-$10,858) vi. -0.45 FTE from Stormwater Internal Service Fund (-$51,921) b. Civil Engineer II i. +0.15 FTE to Stormwater Fund (+$19,561) ii. -0.15 FTE from General Fund (-$19,561) c. Engineering Technician i. +0.03 FTE to Parking Fund (+$2,774) ii. +0.17 FTE to General Project Engineering Internal Service Fund (+$15,716) iii. +0.15 FTE to Sanitary Sewer Internal Service Fund (+$13,867) iv. -0.35 FTE from Stormwater Internal Service Fund (-$32,357) -117- d. Traffic Engineer i. +0.10 FTE to General Project Engineering Internal Service Fund (+$11,069) ii. -0.10 FTE from General Fund (-$11,069) e. Secretary i. +0.55 FTE to General Fund (+$38,669) ii. +0.05 FTE to Stormwater Fund (+$3,513) iii. -0.20 FTE from Sanitary Sewer Fund (-$14,060) iv. -0.20 FTE from Sanitary Sewer Internal Service Fund (-$14,061) v. -0.20 FTE from Stormwater Internal Service Fund (-$14,062) f. Confidential Account Clerk i. +0.05 FTE to Sanitary Sewer Internal Service Fund (+$3,016) ii. +0.05 FTE to Stormwater Internal Service Fund (+$3,017) iii. -0.05 FTE from Sanitary Sewer Fund (-$3,016) iv. -0.05 FTE from Stormwater Fund (-$3,017) Supplies & Services 9. Consultant Services is increased from $72,051 in FY 2020 to $85,801 in FY 2021. This line item represents Stormwater Maintenance ($52,000), NPDES consultant services ($7,250), Stormwater I&I Prevention ($6,000), and Detention Basin Maintenance ($3,936). 10. Inspection Reimbursement is unchanged from $36,000 in FY 2020 to $36,000 in FY 2021. This line item represents the refund to developers for subdivision inspection fees paid that were more than actual cost. There is offsetting revenue of $65,000 in the Subdivision Inspection Fee revenue line item. 11. Pay to Other Agency is increased from $67,957 in FY 2020 to $117,957 in FY 2021. This line item represents the contract with East Central Iowa Association for transportation planning ($20,000) and the Catfish Creek Watershed Partnership payment ($97,957). 12. Grant expense increased from $438,506 in FY 2020 to $472,090 in FY 2021. This line item is the stormwater enterprise fund subsidies for low income households ($34,326), residential farms ($12,155), and property tax-exempt properties ($400,609), lateral replacement assistance ($10,000), as well as streambank rehabilitation grants ($5,000) and rain gardens/barrel grants ($5,000). The increase represents the planned increase in the Stormwater User Fee in FY 2021. There are 118 customers that receive the property tax-exempt subsidy, of which the top ten include schools, universities and hospitals, which account for 71 % of the property tax-exempt subsidy paid. There are 18 customers that receive the residential farm subsidy and there are 465 customers that receive the low-income subsidy. 13. Sales Tax increased from $166,099 in FY 2020 to $178,403 in FY 2021 based on increased stormwater rates in FY 2021. This expense is directly offset by sales tax revenue. 14. Software License increased from $162,194 in FY 2020 to $181,200 in FY 2021. FY 2019 actual was $89,026. In FY 2020, Milestone camera licenses increased $22,000 and Milestone camera software maintenance was added for $23,000. In FY 2021, Traffic Engineering increased $20,699 due to an increase in the Milestone camera software ($25,000) and a decrease in the Windows 2008 Server software (-$7,800). Project Engineering increased $6,467 due to an increase in the Drone Deploy license ($500) and an increase in AutoCAD Civil 3D ($4,527). Sanitary Sewer Engineering decreased $(4,435) due to an increase in Win911pro ($2,500), Mobile911 ($1,200), an increase in hachWIMS custom report writer for SCADA ($1,445), and an increase in Wonderware Historian Client ($6,525). Stormwater decreased $(4,003) due to adding 87 Milestone licenses for cameras. -118- 15. Camera Maintenance decreased from $63,592 in FY 2020 to $60,400 in FY 2021. FY 2019 actual was $26,094. Stormwater decreased $3,192 due to moving camera annual software maintenance to the software maintenance line item. This line item represents maintenance contracts associated with the equipment and software used to run the Traffic Operations Center ($36,500) and the Milestone Camera licenses ($23,900). 16. Property Tax increased from $87,645 in FY 2020 to $89,498 in FY 2021. FY 2019 actual was $85,092. This line item represents the property taxes paid on property that the City leases to other entities and is offset by lease revenue. 17. Education and Training increased from $48,988 in FY 2020 to $49,246 in FY 2021 based on FY 2020 plus 1%. 18. Conferences increased from $31,526 in FY 2020 to $35,264 in FY 2021. Project Engineering increased $3,738 due to adding the ESRI User Conference and American Association of Highway Transportation Officials GIS-T symposium for the Engineering Technician. 19. Machinery and Equipment Maintenance increased from $52,895 in FY 2020 to $63,137 in FY 2021. FY 2019 actual was $35,231. Stormwater increased $8,242 due to adding a budget for the Bee Branch Pump Station maintenance and repairs ($8,242). Traffic Engineering increased $2,000 for traffic counter maintenance. Machinery & Equipment 20. Equipment replacement items include ($747,433): Equipment Replacements Engineering Administration Chairs/Desks $ 1,000 Label Maker $ 200 Spiral Binding System $ 2,500 Emergency Radio $ 3,800 Smart Phone $ 700 Project Engineering General Fund Digital Cameras (1) $ 200 ASTM Manuals/Lab Equipment $ 1,000 Desks/Chairs $ 1,000 Metal Detector $ 900 Auto Levels (2) $ 300 Motorola Radius Radios (2) $ 1,000 Ford Connect Van $ 38,000 Security Cameras (7) $ 8,400 Smart Phones (10) $ 3,850 Traffic Engineering General Fund Computer $ 2,400 2008 Toyota Prius $ 17,500 Traffic Engineering Road Use Tax Fund -119- Equipment Replacements Label Printer $ 200 PTZ Cameras (2) $ 22,400 Battery Back -Up Systems (5) $ 25,000 Milestone Video Servers (4) $ 30,000 Virtual Servers (4) $ 8,000 Network Switch - City Hall $ 8,150 Network Switch - Operations and Maintenance (2) $ 16,275 Network Switch - Brocade Fiber (2) $ 11,500 HP Video Monitor CPU (2) $ 10,000 Axis Servers (10) $ 6,500 Wireless Point to Point (2) $ 10,000 Hardened Intersection Switches (17) $ 51,000 Nitek Extenders for cameras (5) $ 5,000 Data Collector $ 10,000 Milestone SAN - 2 CHASSIS $ 120,000 Mobile GPS (5) $ 2,100 ITERIS Cameras (4) $ 4,800 Axis Cameras (91) $ 109,200 Batteries (60) $ 12,000 APC Battery Back -Up (1) $ 3,000 Traffic Counters (3) $ 4,500 Smart Phone (1) $ 350 Project Engineering Sanitary Sewer Fund E-One Pumps (3) $ 6,000 Gas Air Meters (4) & Field Safety Equipment $ 2,400 Smart Phones (2) Project Engineering Stormwater Fund $ 1,050 Label Maker $ 200 Level Transducers $ 2,500 Weather Station $ 1,100 Smart Phones (2) $ 700 Annual Projects General Sanitary Sewer Repairs/Maintenance $ 92,868 General Stormwater Repairs/Maintenance $ 50,000 Detention Basin Maintenance $ 15,000 Recommended Improvement Packages $ 22,890 Total Equipment $ 747,433 -120- Debt Service 21. Annual Debt Service Payments for FY 2021 are as follows ($6,448,888): Amount Debt Series Source Purpose Final Call Payment Date $ 23,876 2017A G.O. Sales Tax 30% Fiber Optic & Street Light 2029 2025 $ 193,600 2017A G.O. Stormwater Fees Stormwater Improvements 2029 2025 $ 876,221 2017A G.O. GDTIF/General America's River Project 2021 2021 $ 420 2017A G.O. Sales Tax 30% Street Improvements 2030 2025 $ 55,048 2006 SRF Stormwater Fees North Catfish Creek 2030 $ 115,520 2009 SRF Stormwater Fees West 32nd Detention Basin 2030 $ 71,155 2018A G.O. Sales Tax 30% Southwest Arterial 2031 2026 $ 158,122 2018A G.O. Stormwater Fees Stormwater Improvements 2031 2026 $ 127,732 2012B G.O. Stormwater Fees Stormwater Improvements 2031 2020 $ 7,054 2019C G.O. Sales Tax 30% FEMA Flood Buyout 2027 2026 $ 31,726 2019C G.O. Stormwater Fees Stormwater Improvements 2033 2026 $ 79,563 2012E G.O. Sales Tax 30% Southwest Arterial 2032 2019 $ 9,039 2012E G.O. Stormwater Fees Stormwater Improvements 2032 2019 $ 413,280 2010 SRF Stormwater Fees Lower Bee Branch 2032 $ 323,100 2014A G.O. Sales Tax Increment Bee Branch Watershed 2029 2024 $ 51,197 2014B G.O. Sales Tax 30% Street Improvements 2034 2021 $ 20,660 2014 SRF Sales Tax 30% Lower Bee Branch 2034 $ 1,476,131 2015B SRF Sales Tax Increment Upper Bee Branch 2035 $ 762,650 2015A Revenue Sales Tax Increment Bee Branch Watershed 2029 2026 $ 724,650 2016B G.O. Sales Tax 20% Stormwater Refunding 2036 2024 $ 18,076 2016C G.O. Stormwater Fees Federal Building Roof 2037 2024 $ 910,068 2019 SRF Stormwater Fees Bee Branch Watershed 2038 $ 6,448,888 Total Engineering Annual Debt Service Revenue 22. Riverfront Leases increased from $2,270,423 in FY 2020 to $2,678,025 in FY 2021 based on the projected revenue which is as follows: Riverfront Lease FY20 Budget FY21 Budget Artco Fleeting Service $ 1,050 $ 1,200 Colleen Bradley Lindstrom $ 3,600 $ 3,600 Dubuque Marina $ 31,653 $ 32,128 Dubuque Terminals - South Port Inland $ 13,900 $ Dubuque Terminals Dove Harbor $ 121,890 $ 123,718 Dubuque Yacht Basin $ 24,813 $ 195,300 Flint Hill Resources $ 676,700 $ 686,850 Freebird II, LLC - Lease 2 $ 6,792 $ Freebird III, LLC $ 58,000 $ Hodge Transit Warehouse Co $ 355,064 $ 360,390 Klauer Manufacturing $ 100 $ 100 Riverboat Twilight $ 5,500 $ 5,300 -121- Riverfront Lease FY20 Budget FY21 Budget Gavilon - 7th Street $ - $ 107,500 Gavilon - Purina Drive $ $ 178,750 Gavilon - Land By City Salt Pile $ 264,180 $ 268,143 Gavilon Dove Harbor $ 537,540 $ 545,603 Thompson Truck and Trailer LLC $ 7,341 $ 7,451 Port of Dubuque Brewery Development $ 62,100 $ 62,100 Diamond Jo Patio Lease $ 25,000 $ 25,000 Platinum Holdings LLC $ 75,200 $ 74,892 Total $ 2,270,423 $ 2,678,025 23. Wharfage Fees on Leased Property increased from $123,000 in FY 2020 to $148,024 in FY 2021 and is dependent on how much business is being conducted at the Wharf. Wharfage Fees on Leased Property FY20 Budget FY21 Budget Freebird II, LLC - Lease 2 $ 22,000 Gavilon - 7th Street $ $ 53,008 Gavilon Dove Harbor $ 65,000 $ 40,968 Gavilon - Salt Site $ 16,000 $ 33,048 Flint Hill Resources $ 20,000 $ 21,000 Total $ 123,000 $ 148,024 24. Non-Riverfront Lease increased from $135,138 in FY 2020 to $137,923 in FY 2021. Non-Riverfront Lease FY20 Budget FY21 Budget Dubuque Rescue Mission HHH Enterprises $ 2,093 $ 2,135 Hartig Drug $ 1,844 $ 1,881 16th St. Detention Basin - Rainbo Oil $ 123,031 $ 125,492 Interstate Power & Light Co (Graf Farm Solar) $ 8,169 $ 8,414 Total $ 135,138 $ 137,923 25. Fiber Leases increased from $0 in FY 2020 to $14,178 in FY 2021 based on FY 2019 actual. 26. Telecomm Leases increased from $0 in FY 2020 to $9,600 in FY 2021 based on FY 2019 actual. 27. Subdivision Inspection Fees decreased from $100,000 in FY 2020 to $65,000 in FY 2021 based on projected construction of subdivisions. 28. Stormwater Penalties increased from $28,845 in FY 2020 to $31,295 in FY 2021 based on FY 2019 actual of $31,295. -122- 29. The FY 2021 Stormwater User Fee increased from $8.29 per SFU to $8.85 per SFU, a 6.83% increase, consistent with Ordinance 16-14 passed on March 5, 2014. FY 2016 FY 2017 FY 2018 FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 Adopted Per Ordinance 21-12 $ 8.50 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 Adopted Per Ordinance 16-14 $ 6.38 $ 6.81 $ 7.27 $ 7.76 $ 8.29 $ 8.85 $ 9.00 $ 9.00 % Decrease From Ordinance 21-12 -24.94%-24.33% -19.22% -13.78% -7.89% -1.69% —% —% * The recommended rates for FY16 through FY20 reflect the rates previously established by Ordinance 16-14 following the State's approval of $98.5 million in State Flood Mitigation state sales tax increment funds for the Bee Branch Watershed Flood Mitigation Project. Ordinance 21-12 was the ordinance adopted prior to the City receiving the Flood Mitigation grant. -123- Assistant Engineer Project Manager Confidential Secretary Account Clerk (2) I Right -of -Way Management Streets ROW Management Technician Engineering Technician Interns (1.25) Stormwater and Sanitary Civil Engineer II Civil Engineer I Engineering Technician (6) Surveyor Survey Crew Chief Survey Technician Traffic Engineering Civil Engineer II Engineering Technician (2) I&I Inspector PT (1.48) Utility Locator (0.75) Engineering Assistant II L Civil Engineer II Traffic Engineer (2) Utility Locator (0.25) -124- ENGINEERING DEPARTMENT The mission of the Engineering Department is to promote public safety by providing engineering services related to the planning, development, construction, and maintenance of the City's public infrastructure systems. Right -of -Way Management Assistant Engineer Project Manager Confidential Secretary t Account Clerk (2) Streets ROW Management Technician Engineering Technician Interns (1.25) Stormwater and Sanitary Civil Engineer II Civil Engineer I Engineering Technician (6) Surveyor Survey Crew Chief Survey Technician Traffic Engineering Civil Engineer II Engineering Technician (2) I&I Inspector PT (1.48) Utility Locator (0.75) Engineering Assistant II Civil Engineer II Traffic Engineer (2) Utility Locator (0.25) -125- SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PEOPLE Engineering continues in its emphasis on public information meetings concerning projects that have a significant impact on property owners. These meetings provide an opportunity for meaningful exchange between the City and property owners on the project scope and its impact. PLANNING Engineering coordinates its project planning with multiple City Departments. In addition the department is involved in the Dubuque Metropolitan Area Transportation Study and works with the East Central Intergovernmental Agency in planning projects. This ensures a regional view is considered in project development. PARTN ERSHI PS The Engineering Department works with the Iowa Department of Transportation (IDOT). the Access Board. Federal Highway Administration (FHWA). East Central Intergovernmental Agency (ECIA), Dubuque County_ Historic Preservation Commission. Neighborhood Groups. Tri-State Trail Vision and many other entities when planning and constructing projects -126- $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 so ENGINEERING DEPARTMENT FY 2019 FY 2020 FY 2021 Full -Time Equivalent 30.23 29.96 30.71 Resources ■ OPerahrkgRevenue Pdmkr\kstratNeRechar9es FY 2019 Road Use TaX FY 2020 StormWa<er Sar'ktaN Sewer FY 2021 The Engineering Department is supported by 30.71 full-time equivalent employees, which accounts for 58.20% of the department expense as seen below. Overall, the department's expenses are expected to increase by 3.19% in FY 2021 compared to FY 2020. Employee Expense Supplies and Services Machinery and Equipment Construction Fund Administrative Overhead Charges $2,753,468 $2,970,550 $3,098,790 $1,339,936 $1,504,928 $1,664,443 $321,971 $566,194 $747,433 $1,525,000 $1,210,000 $880,000 $469,385 $527,544 $608,650 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 FY 2019 FY 2020 FY 2021 -127- ENGINEERING DEPARTMENT Activity: Right-of-way Management and Streets Mission & Services These activities manage the public right-of-way so it is safe and accessible for all users and constructing and maintaining streets in a fiscally -responsible way that also provides safe and efficient transportation. Responsibilities include monitoring right-of-way, excavations, sidewalk inspections, appeals, management of compliance, utility locate services, and street and alley planning, inspection, reconstruction, and maintenance. Right-of-way and Streets Funding Summary FY 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $2,642,157 $2,056,049 $2,200,504 Resources $(670,994) $1,221,090 $(1,535,862) Right-of-way and Streets Position Summary FY 2021 City Engineer 0.30 City Engineer - Service Fund 0.15 Assistant City Engineer 0.30 Assistant City Engineer- Svc Fd 0.70 Project Manager 0.40 Project Manager - Service Fund 0.10 Civil Engineer II 0.80 Civil Engineer II - Service Fund 1.20 Survey Technician 0.15 Survey Technician - Service Fund 0.30 Survey Party Chief 0.15 Survey Party Chief - Service Fd 0.30 Engineering Technician 1.90 Engineering Technician - Service Fd 2.67 Engineering Assistant II 0.10 Engineering Assistant II - Service Fd 0.40 Surveyor 0.80 Surveyor - Service Fund 0.20 Engineering Aide 0.00 Engineering Aide - Service Fund 1.00 Traffic Engineer 0.50 Traffic Engineer - Service Fund 0.50 Confidential Account Clerk 0.65 Confidential Acct Clerk - Service Fd 0.00 Secretary - Admin 0.05 Secretary - Admin Internal Svc 0.00 ROW Technician 0.90 ROW Technician - Service Fd 0.10 Engineering Aide - Seasonal 0.00 Total FT Equivalent Employees 14.62 -128- ENGINEERING DEPARTMENT Right -of -Way Management and Streets Performance Measures City Council Goal: Connected Communit Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate Indicator 1 Activity Objective: Provide safe walking pathways throughout the City, including pedestrian access ramps. of property notices resolved within alloted time for un-shoveled sidewalks 80% 57% 94% 80% # of ADA curb ramps installed 100 104 95 100 2 Activity Objective: Provide complete, safe, and efficient street systems. Avg. condition rating (out of 100) of all Dubuque streets # of vehicle crashes in the City of Dubuque 70 78 73 73 N/A 1,546 1,261 1,300 N/A City Council Goal: Livable Neighborhoods & Housing 3 Activity Objective: Manage the work in right-of-way permits. # of Right of Way excavation permits/ person N/A 227 306 350 N/A -129- ENGINEERING DEPARTMENT Stormwater Management Mission & Services The mission of the City's Stormwater Management Utility is to help protect the health of citizens and both the natural and built environment by designing, implementing, and maintaining an effective, efficient municipal stormwater management system. The City of Dubuque has the responsibility as private property owners: manage stormwater on its property. Programs include construction of new detention basins, extension of storm sewer systems, maintenance of ditches, sewers, and basins, and limiting pollutants associated with stormwater runoff. Stormwater Funding Summary FY 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $4,662,633 $5,275,137 $5,612,766 Resources $4,662,633 $5,275,137 $5,612,766 Stormwater Position Summary FY 2021 Civil Engineer II 0.77 Civil Engineer II - Service Fund 0.68 City Engineer 0.15 City Engineer - Service Fund 0.10 Engineering Technician 0.15 Engineering Technician - Service Fd 1.35 Engineering Assistant II 0.10 Engineering Assistant II - Service Fd 0.40 Survey Party Chief - Service Fund 0.25 Survey Technician - Service Fund 0.25 Project Manager - Service Fund 0.25 Utility Locator - Stormwater 0.25 Utility Locator - Water 0.25 Confidential Account Clerk 0.25 I&I Inspector 1.46 Confidential Account Clerk - Service Fd 0.40 Total FT Equivalent Employees 7.06 Performance Measures City Council Goal: Livable Neighborhoods and Housing Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate Indicator 1 Activity Objective: Engineer, construct, and maintain facilities to mitigate the effects of flooding. # of phases completed in Bee Branch Watershed Flood Mitigation Project 12 4 5 5 2 Activity Objective: Design and oversee construction of street/public ROW drainage systems to mitigate flooding and make the street available to the public during a rain event. of storm sewer construction occurring in conjunction with street replacement 80 95 95 85 -130- ENGINEERING DEPARTMENT Sanitary Sewer Collection Mission & Services The City of Dubuque's Sanitary Sewer Collection system delivers wastewater to the Water and Resource Recovery Center (W&RRC) where it is treated in accordance with the federal Clean Water Act before being discharged in the Mississippi River. This activity defines and implements capital improvements to improve the City's existing sanitary sewer collection infrastructure and provides direction and standards for future expansion and connections to the system. Sanitary Sewer Collection Funding Summary FY 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $159,603 $557,989 $603,695 Resources $159,603 $557,989 $603,695 Sanitary Sewer Collection Position Summary FY 2021 City Engineer 0.15 City Engineer - Service Fund 0.15 Civil Engineer II 0.10 Project Manager 0.10 Project Manager - Service Fund 0.15 Engineering Technician 0.10 Engineering Technician - Service Fund 1.80 Survey Party Chief - Service Fund 0.30 Survey Technician - Service Fund 0.30 Secretary 0.05 Secretary - Service Fund 0.05 Confidential Account Clerk 0.25 Confidential Account Clerk - Svc Fund 0.15 Utility Locator 0.25 Total FT Equivalent Employees 3.90 Performance Measures City Council Goal: Sustainable Environment Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate Indicator 1 Activity Objective: Reduce inflow and infiltration (I&I) into the sanitary sewer collection system and work to eliminate the source or secure the sanitary sewer from the source. # of feet pipe lined through I&I Program 1,000 6,239 0 300 2 Activity Objective: Reconstruct Sanitary Sewer Manholes and Pipe # of brick sanitary sewer manholes replaced 15 18 15 18 -131- ENGINEERING DEPARTMENT Traffic Engineering Mission & Services This Activity is responsible for overseeing the planning, inspection and daily operation of active projects for the movement of pedestrians, vehicular traffic, fiber optic expansion, street lighting, traffic signals, traffic controls, fiber optic and communications infrastructure, traffic and security cameras, traffic signage and pavement markings throughout the City and provides guidance to the Public Works Department. Other activities involve the review and recommendations for parking meter districts, residential parking districts and accessible parking spaces according to local, state and federal guidelines. This activity is highly called upon during emergency events and crises. Traffic Engineering Funding Summary FY 2019 Actual FY 2020 Budget FY 2021 Requested Expenditures $82,968 $153,780 $196,937 Resources $7,200 $17,681 $17,893 Traffic Engineering Position Summary FY 2021 Confidential Account Clerk 0.20 Utility Locator 0.25 Traffic Engineering Assistant 0.00 Traffic Engineering Assistant - Svc Fd 0.00 ` Total FT Equivalent Employees 0.45 Performance Measures City Council Goal: Financially Responsible, High Performance Organization Performance Measure (KPI) Target FY18 FY19 FY20 Performance Actual Actual Estimate Indicator 1 Activity Objective: Reduce energy and maintenance costs as well as increase safety by replacing existing street lights with LED lighting. % of city -owned lights converted to LED 100% 32% 51% 53% CO City Council Goal: Connected Community 2 Activity Objective: Provide a road network that ensures a high level of safety for vehicles, cyclists, and pedestrians. % of signalized Intersections with Microwave Detection 100% 26% 29% 2 Activity Objective: Continue growth of traffic operation cameras, security cameras, and fiber and conduit. % of signalized Intersections with security cameras 100% N/A 74% 80% CO # of miles annually of conduit installed N/A 12.51 4.75 4.29 CO -132- Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Revenue FY19 Actual Revenue FY20 Adopted Budget FY21 Recomm'd Budget 100 42170 100 42225 100 42240 620 42260 100 42305 100 42315 610 42,315 640 42315 MISC-LICENSES DUMPSTER PERMITS EXCAVATION PERMITS PERMIT, MISC SIDEWALK PERMIT SUBDIV. INSPECTION FEE 3% SUBDIV. INSPECTION FEE 3% SUBDIV. INSPECTION FEE 3% 3,381 2,960 22,363 6,095 8,193 139,318 0 0 2,986 3,140 25,418 3,795 11,999 850 1,017 1,306 3,381 2,960 22,363 6,095 8,193 100,000 0 0 800 3,200 23,000 3,795 8,400 65,000 0 0 42 LICENSES AND PERMITS - Total 142,992 620 43110 INVESTMENT EARNINGS 29,235 58,744 41,628 52,869 100 43230 LEASE, PROPERTY 155,937 209,003 135,138 137,923 100 43231 LEASE, RIVERFRONT 1,922,503 2,208,827 2,270,423 2,678,025 100 43233 SIDEWALK CAFE LEASES 1,050 600 800 800 100 43259 LEASE, FIBER 0 26,034 0 14,178 100 43,265 LEASE, TELECOMM 0 9,600 0 9,600 100 43320 LEASE, WHARFAGE 164,152 158,975 123,000 148,024 100 43325 LEASE, OTHER 0 240 120 120 43 USE OF MONEY AND PROPERTY - Total 620 44405 FEMA PUBLIC ASSISTANCE 2,152 0 0 0 44 2,152 620 45701 STATE GRANTS 0 1,236 0 0 r .5 STATE GRANTS - 620 51215 LATE PAYMENT PENALTY 28,845 31,295 28,845 31,295 610 51245 SEWER CONNECTION CHARGES 2,539 0 2,539 0 620 51805 STORMWATER USER FEE 4,224,607 4,539,386 4,849,462 5,180,637 620 51820 STORMWATERHALFRATE 28,178 30,466 32,131 32,131 MIPZIMEEs FORota 4,284,168 4,60 5,244,063 100 53403 IA DISTRICT COURT FINES 0 85 0 85 800 53530 SPECIALIZED SERVICES 1,683,777 1,392,719 1,619,636 1,675,236 100 53605 MISCELLANEOUS REVENUE 673 572 0 400 100 53610 INSURANCE CLAIMS 12,725 0 0 0 620 53610 INSURANCE CLAIMS 0 41,262 0 0 100 53615 DAMAGE CLAIMS 1,348 0 0 0 100 53620 REIMBURSEMENTS -GENERAL 10,504 14,863 6,150 6,150 620 53620 REIMBURSEMENTS -GENERAL 1,873 8,748 1,873 1,873 620 53630 SALES TAX COLLECTION 145,662 156,452 166,099 178,403 53 MISCELLANEOUS 1,856,563 1,793,758 1,862,147 100 54105 _ LAND SALES 12 1 0 0 400 54210 GO BOND PROCEEDS 771,500 650 0 0 620 54210 GO BOND PROCEEDS 1,714,500 2,925 0 0 400 54220 _ BOND DISCOUNT 11,250 29 0 0 620 54220 BOND DISCOUNT 25,000 133 0 0 54 OTHER FINANCING SOURCES - Total 2,522,262 400 59100 FR GENERAL 541,984 388,568 548,936 543,375 620 59102 FR DRA DISTRIBUTION 125,876 258,990 299,600 177,978 400 59240 FR DOWNTOWN TIF 340,766 343,800 334,350 339,900 400 59250 FR ROAD USE TAX 21,267 21,381 23,992 23,876 620 59255 FR SPECIAL ASSESSMENT 105 114 0 0 400 59300 FR STREET CONSTRUCTION 210,097 209,125 204,096 201,915 400 59340 FR SALES TAX INCREMENT 2,118,792 2,642,669 2,562,323 2,561,881 400 59350 FR SALES TAX CONSTRUCTION 19,209 32,890 18,748 18,496 620 59350 FR SALES TAX CONSTRUCTION 226,950 118,906 118,906 269,112 100 59610 FR WPC OPERATING 330,040 291,095 261,845 273,439 100 59620 FR STORMWATER OPERATING 76,041 68,174 72,400 82,032 100 59640 FR WATER UTILITY 20,184 52,397 56,741 43,750 RANSFER IN AND INTERNAL - Total 4,031,311 4,428,110 4,501,937 4,535,754 ENGINEERING - Total 15,151,643 13,371,467 13,922,773 1 14,787,698 -133- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 61010 61010 61010 61010 61010 61010 61020 61020 61020 61020 61020 61030 61030 61030 61030 61030 61050 61050 61050 61050 61050 61050 61071 61071 61071 61071 61091 61092 61092 61096 61096 61310 61310 61310 61310 61310 61310 61320 61320 61320 61320 61320 61320 61410 61410 61410 61410 61410 FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES FULL-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES PART-TIME EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES SEASONAL EMPLOYEES OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY OVERTIME PAY HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME HOLIDAY PAY -OVERTIME SICK LEAVE PAYOFF VACATION PAYOFF VACATION PAYOFF 50% SICK LEAVE PAYOUT 50% SICK LEAVE PAYOUT IPERS IPERS IPERS IPERS IPERS IPERS SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY SOCIAL SECURITY HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE HEALTH INSURANCE 555,757 567,280 651,051 700,433 59,279 66,646 89,908 77,781 227,196 216,514 145,000 143,790 0 1,398 0 2,069 21,471 21,800 14,374 14,654 1,144,644 1,065,354 1,136,419 1,189,268 8,539 2,601 0 0 0 3,388 0 0 24,179 31,312 74,638 75,480 0 2,069 0 0 36,235 1,261 0 0 12,006 24,852 17,050 7,423 258 710 0 0 4,366 7,168 0 0 0 418 0 0 49,238 79,307 34,100 29,692 14,443 19,407 18,390 18,390 1,022 1,306 0 0 6,325 8,148 0 0 0 71 0 0 1,053 1,281 0 0 27,942 49,770 54,250 54,250 0 32 0 0 0 79 0 0 0 31 0 0 0 283 0 0 7,769 9,554 11,977 11,976 9,300 7,918 0 0 7,579 0 0 0 0 0 0 12,138 0 0 0 2,335 51,936 56,644 63,567 68,558 5,418 6,737 8,489 7,342 23,121 24,174 20,735 20,699 0 139 0 195 2,016 2,377 1,357 1,384 111,330 109,461 115,622 117,391 43,952 45,871 52,430 57,401 4,268 5,200 6,879 5,950 19,028 18,658 16,802 16,953 0 99 0 158 1,580 1,818 1,100 1,121 90,759 86,396 93,698 97,398 (106,753) 112,855 91,778 116,751 24,319 21,609 12,461 11,068 56,286 40,509 20,585 15,306 0 296 0 368 5,332 3,578 2,709 3,074 -134- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 800 61410 HEALTH INSURANCE 100 61415 WORKMENS' COMPENSATION 610 61415 WORKMENS' COMPENSATION 620 61415 WORKMENS' COMPENSATION 640 61,415 WORKMENS' COMPENSATION 800 61415 WORKMENS' COMPENSATION 100 61416 LIFE INSURANCE 610 61416 LIFE INSURANCE 620 61416 LIFE INSURANCE 630 61416 LIFE INSURANCE 640 61416 LIFE INSURANCE 800 61416 LIFE INSURANCE 620 61417 UNEMPLOYMENT INSURANCE 100 61640 SAFETY EQUIPMENT 100 61660 EMPLOYEE PHYSICALS 620 61660 EMPLOYEE PHYSICALS 800 61660 EMPLOYEE PHYSICALS 100 61680 EMPLOYEE MOVING EXPENSE 222,761 0 154,196 42,143 14,337 14,773 9,455 2,110 2,451 26,788 5,451 5,725 0 0 456 0 0 30,533 0 418 422 496 556 51 53 71 57 172 170 117 115 0 2 0 2 20 21 14 14 867 755 818 882 5,031 0 5,031 2,516 327 0 250 250 888 1,887 250 2,084 495 0 0 0 0 134 0 134 0 1,750 0 0 185,116 16,705 2,880 6,223 460 61 - WAGES AND BENEFITS 2,860,608 2,753,468 2,970,550 3,098,790 100 62010 OFFICE SUPPLIES 6,635 7,066 6,634 7,065 250 62010 OFFICE SUPPLIES 0 208 0 208 610 62010 OFFICE SUPPLIES 0 8 0 8 620 62010 OFFICE SUPPLIES 0 283 0 198 100 62011 UNIFORM PURCHASES 0 0 400 400 100 62030 POSTAGE AND SHIPPING 2,324 2,440 2,395 2,950 610 62030 POSTAGE AND SHIPPING 25 169 26 186 620 62030 POSTAGE AND SHIPPING 307 323 316 355 100 62034 REPAIR PARTS/SUPPLIES 244 0 244 0 100 62050 OFFICE EQUIPMENT MAINT 0 428 1,740 900 100 62061 DP EQUIP. MAINT CONTRACTS 27,982 27,562 26,580 26,854 100 62090 PRINTING & BINDING 25 68 527 527 620 62090 PRINTING & BINDING 0 4,955 0 5,302 100 62110 COPYING/REPRODUCTION 5,823 4,458 6,231 4,459 610 62110 COPYING/REPRODUCTION 0 0 0 0 620 62110 COPYING/REPRODUCTION 356 417 381 417 100 62130 LEGAL NOTICES &ADS 223 2,985 223 2,985 610 62130 LEGAL NOTICES & ADS 0 27 0 27 620 62130 LEGAL NOTICES & ADS 0 534 0 533 630 62130 LEGAL NOTICES & ADS 0 40 0 40 100 62170 SUBSCRIPTIONS -BOOKS -MAPS 4,563 5,287 4,068 5,493 250 62170 SUBSCRIPTIONS -BOOKS -MAPS 0 352 735 710 610 62170 SUBSCRIPTIONS -BOOKS -MAPS 86 995 221 400 620 62170 SUBSCRIPTIONS -BOOKS -MAPS 0 0 126 322 100 62190 DUES & MEMBERSHIPS 2,898 2,410 4,584 6,551 250 62190 DUES & MEMBERSHIPS 0 410 995 995 610 62190 DUES & MEMBERSHIPS 0 0 0 510 620 62190 DUES & MEMBERSHIPS 0 0 648 541 610 62204 REFUNDS 1,721 0 1,721 0 -135- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 620 62204 100 62206 250 62206 620 62206 100 62208 250 62208 610 62208 620 62208 620 62210 100 62211 100 62212 100 62230 100 62310 250 62310 610 62310 620 62310 100 62320 620 62320 100 62340 620 62340 100 62360 250 62360 610 62360 620 62360 100 62411 620 62411 100 62415 100 62416 620 62419 100 62421 250 62421 610 62421 620 62421 800 62421 100 62424 100 62431 250 62431 610 62431 620 62431 100 62436 620 62436 100 62438 610 62438 620 62438 100 62511 610 62511 620 62511 100 62521 REFUNDS PROPERTY INSURANCE PROPERTY INSURANCE PROPERTY INSURANCE GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN GENERAL LIABILITY INSURAN SALES TAX PROPERTY TAX TECH/OTHER EQUIP INSURANC COURT COSTS & RECORD FEES TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CONFERENCES TRAVEL -CITY BUSINESS TRAVEL -CITY BUSINESS MILEAGE/LOCAL TRANSP MILEAGE/LOCAL TRANSP EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING EDUCATION & TRAINING UTILITY EXP-ELECTRICITY UTILITY EXP-ELECTRICITY UTILITY EXPENSE STORMWATR UTILITY EXP-WATER UTILITY EXP-ELEC ST LING TELEPHONE TELEPHONE TELEPHONE TELEPHONE TELEPHONE RADIO/PAGER FEE PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE PROPERTY MAINTENANCE RENTAL OF SPACE RENTAL OF SPACE FIRE SUPPRESSION FIRE SUPPRESSION FIRE SUPPRESSION FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE FUEL, MOTOR VEHICLE MOTOR VEHICLE MAINT. 1,518 5,052 15,992 1,007 0 0 0 4,062 3,758 3,987 3,946 0 348 0 366 146,943 153,999 166,099 178,403 86,580 85,092 87,645 89,498 251 0 264 277 1,636 540 1,636 540 14,436 15,610 18,469 22,207 3,185 4,638 5,334 5,334 0 0 1,730 1,730 3,953 5,826 5,993 5,993 188 559 644 644 295 1,381 124 124 37 472 40 489 0 77 0 80 6,794 11,616 34,321 34,449 3,700 3,132 6,077 6,077 695 471 1,674 1,777 2,497 2,329 6,916 6,943 1,432 3,151 1,920 3,403 5,251 19,008 5,250 20,529 2,579 3,243 4,428 7,566 52 160 120 785 542 1,604 542 1,764 12,266 13,414 12,265 14,039 1,295 1,306 1,920 1,306 1,706 1,791 1,706 1,791 1,970 2,148 1,970 2,148 0 0 0 625 1,967 2,205 2,633 1,630 157 1,018 1,000 1,233 1,367 0 0 0 1,367 0 0 0 14,984 700 15,590 11,290 9,354 7,920 14,314 13,096 480 440 480 400 0 0 0 120 0 0 0 30 0 0 0 20 10,710 12,502 10,710 10,999 689 0 689 708 494 448 494 508 6,994 13,600 7,133 13,872 1,484 29 0 14,414 0 1,952 16,441 1,518 33 14,414 2,214 17,445 1,484 30 15,135 2,050 17,263 -136- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 610 62521 620 62521 100 62522 100 62528 100 62611 250 62611 610 62611 620 62611 100 62614 100 62627 250 62627 620 62627 100 62663 250 62663 610 62663 620 62663 100 62664 620 62664 100 62667 250 62667 610 62667 620 62667 800 62667 620 62668 100 62671 100 62683 250 62683 620 62683 620 62692 100 62696 620 62696 620 62712 100 62713 400 62713 610 62713 620 62713 100 62716 610 62716 620 62716 400 62721 620 62721 620 62726 100 62731 400 62731 620 62731 100 62734 620 62734 610 62746 MOTOR VEHICLE MAINT. 337 0 344 MOTOR VEHICLE MAINT. 234 270 73 VEHICLE MAINT., ACCIDENT 4,602 71 4,694 MOTOR VEH. MAINT. OUTSOUR 1,358 1,933 1,386 MACH/EQUIP MAINTENANCE 254 1,193 2,840 MACH/EQUIP MAINTENANCE 22,000 22,000 22,000 MACH/EQUIP MAINTENANCE 359 3,796 12,480 MACH/EQUIP MAINTENANCE 15,575 8,242 15,575 EQUIP MAINT CONTRACT 0 0 5,309 CAMERA MAINTENANCE 401 23,118 23,900 CAMERA MAINTENANCE 0 0 36,500 CAMERA MAINTENANCE 3,192 2,976 3,192 0 SOFTWARE LICENSE EXP 23,497 35,778 31,904 38,649 SOFTWARE LICENSE EXP 37,235 43,127 116,522 137,221 SOFTWARE LICENSE EXP 3,663 4,180 4,795 360 SOFTWARE LICENSE EXP 20,169 5,940 8,973 4,970 LICENSE/PERMIT FEES 650 0 650 650 LICENSE/PERMIT FEES 0 1,250 0 1,250 DATA SERVICES 1,912 2,336 5,520 5,692 DATA SERVICES 5,033 4,761 7,920 4,856 DATA SERVICES 341 404 2,400 2,400 DATA SERVICES 1,081 1,124 2,400 2,400 DATA SERVICES 0 0 0 480 PROGRAM EQUIP/SUPPLIES 2,286 0 0 0 MISC. OPERATING SUPPLIES 0 (25) 0 0 FIELD OPERATIONS SUPPLIES 1,745 4,337 3,527 3,549 FIELD OPERATIONS SUPPLIES 31 0 31 0 FIELD OPERATIONS SUPPLIES 1,097 84 1,097 84 LANDFILL FEES 8,452 0 0 0 OUTSIDE COLLECTOR EXPENSE 8 91 8 91 OUTSIDE COLLECTOR EXPENSE 2,583 1,643 2,583 1,643 CONSULTING ENGINEERS 5,406 1,208 5,406 1,208 LEGAL SERVICES 816 379 500 500 LEGAL SERVICES 4,002 0 0 0 LEGAL SERVICES 995 0 500 500 LEGAL SERVICES 8,924 3,035 500 0 CONSULTANT SERVICES 9,335 23,106 6,615 6,615 CONSULTANT SERVICES 0 910 0 0 CONSULTANT SERVICES 15,067 52,381 65,436 79,186 FINANCIAL CONSULTANT 5,276 0 0 0 FINANCIAL CONSULTANT 11,724 0 0 0 AUDIT SERVICES 2,200 2,400 2,200 2,400 MISCELLANEOUS SERVICES 1,206 17,026 0 0 MISCELLANEOUS SERVICES 7,604 314 0 0 MISCELLANEOUS SERVICES 16,898 1,412 0 0 SPEAKERS/PROGRAMS 0 0 1,500 1,500 SPEAKERS/PROGRAMS 0 2,033 0 0 ONE CALL OPERATION 2,217 2,574 2,217 2,217 0 275 0 1,386 2,840 24,000 12,480 23,817 708 23,900 36,500 -137- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 620 62746 ONE CALL OPERATION 640 62746 ONE CALL OPERATION 100 62756 EMPLOYEE RECOGNITION 100 62757 INSPECTION REIMBURSEMENT 100 62761 PAY TO OTHER AGENCY 620 62761 PAY TO OTHER AGENCY 100 62765 GRANTS 610 62765 GRANTS 620 62765 GRANTS 620 62767 ENVIRON. TESTING/MON. 620 62781 LAWN CARE SERVICES 100 62811 ENG. DIVISION SERVICES 2,217 2,550 0 7 2,217 0 2,217 0 73 516 500 500 33,209 101,789 36,000 36,000 15,000 20,000 20,000 20,000 45,646 46,787 47,957 97,957 0 0 0 5,000 0 13,116 10,000 10,000 358,224 380,035 428,506 457,090 1,215 0 3,715 3,715 9,425 12,145 15,000 15,000 0 17,334 21,000 21,000 62 - SUPPLIES AND SERVICES 1,142,461 1,339,936 1,504,928 1,664,443 620 62724 BOND PAYING AGENT FEE 692 0 0 0 627 - CONTRACTUAL SERVICES 692 0 0 0 100 71110 MISC. OFFICE EQUIPMENT 0 0 0 2,500 100 71112 TYPEWRITERS 331 0 200 200 250 71112 TYPEWRITERS 106 0 0 200 620 71112 TYPEWRITERS 0 0 0 200 100 71118 PROJECTOR/CAMERA 0 35 0 200 250 71118 PROJECTOR/CAMERA 11,804 14,556 19,200 22,400 100 71120 PERIPHERALS, COMPUTER 40 5,533 4,200 1,050 250 71120 PERIPHERALS, COMPUTER 0 2,677 0 0 610 71120 PERIPHERALS, COMPUTER 0 0 3,150 980 620 71120 PERIPHERALS, COMPUTER 0 1,730 1,050 0 100 71123 SOFTWARE 0 180 0 6,000 610 71123 SOFTWARE 0 0 0 1,500 620 71123 SOFTWARE 0 0 0 1,000 100 71124 COMPUTER 0 0 2,400 4,800 250 71124 COMPUTER 0 0 6,000 2,100 610 71124 COMPUTER 0 0 2,400 2,440 620 71124 COMPUTER 0 0 2,400 0 250 71125 SERVERS 105,437 67,028 85,500 156,425 250 71127 UPS SYSTEM 140 0 3,000 3,000 100 71129 SCANNER 0 0 15,000 0 100 71211 DESKS/CHAIRS 783 5,604 2,000 2,000 100 71215 STORAGE CABINETS 0 0 8,600 0 100 71216 FURNITURE MISCELLANEOUS 0 563 0 0 100 71310 AUTO/JEEP REPLACEMENT 0 44,038 31,500 55,500 100 71329 VEHICLE ACCESSORIES 0 2,515 0 0 250 71405 SWITCH 0 0 45,000 0 250 71406 BATTERY BACKUP SYSTEM 0 0 25,000 0 250 71407 CAMERA BATTERIES 0 0 12,000 0 250 71408 AXIS CAMERAS 0 0 74,400 0 250 71409 ITERIS CAMERAS 0 0 9,600 0 250 71410 SHOP EQUIPMENT 589 0 0 0 100 71411 TRAFFIC CONTROL EQUIPMENT 13,625 4,241 0 8,400 250 71411 TRAFFIC CONTROL EQUIPMENT 48,724 108,255 4,500 285,500 -138- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING Fund Account Account Title FY18 Actual Expense FY19 Actual Expense FY20 Adopted Budget FY 21 Recomm'd Budget 100 71412 250 71412 100 71413 610 71,511 100 71550 610 72113 620 72113 100 72,116 610 72116 620 72116 100 72410 610 72,410 250 72414 620 72415 100 72417 250 72,417 100 72418 250 72418 610 72418 620 72,418 610 72510 620 72510 100 72515 SURVEY EQUIPMENT SURVEY EQUIPMENT LABORATORY EQUIPMENT PUMPS MISCELLANEOUS EQUIPMENT OTHER SAFETY EQUIPMENT OTHER SAFETY EQUIPMENT SAFETY EQUIP., FIRE DEPT SAFETY EQUIP., FIRE DEPT SAFETY EQUIP., FIRE DEPT PAGER/RADIO EQUIPMENT PAGER/RADIO EQUIPMENT TELEVISION ELECTRONIC DATA COLLECTOR CAMERA RELATED EQUIPMENT CAMERA RELATED EQUIPMENT TELEPHONE RELATED TELEPHONE RELATED TELEPHONE RELATED TELEPHONE RELATED FLOW TEST EQUIPMENT FLOW TEST EQUIPMENT TEST EQUIPMENT, OTHER 35,251 0 12,000 0 4,500 0 133 6,386 4,000 11,438 11,699 6,000 148 0 0 0 2,032 1,402 4,500 2,400 0 0 2,500 2,500 0 0 0 720 0 0 0 180 0 0 0 120 0 11,095 0 3,800 0 2,259 0 0 4,998 5,028 2,500 0 0 0 1,100 1,100 303 0 0 6,500 0 549 0 0 1,169 2,476 792 4,550 389 23 346 350 100 517 100 1,050 379 430 346 700 2,459 3,345 0 0 0 1,050 2,000 0 0 860 320 0 2,200 0 1,000 6,000 71 - EQUIPMENT 240,378 308,573 393,604 589,565 100 73210 CONST CONTRACT-BLDG 0 0 6,800 0 610 73211 CONST.CONTR-NOT BLDG 52,071 398 100,000 92,868 620 73211 CONST.CONTR-NOT BLDG 101,271 13,000 65,790 65,000 73 - CIP EXPENDITURES 153,342 13,398 172,590 157,868 400 74111 PRINCIPAL PAYMENT 2,308,537 2,113,465 2,149,239 2,188,864 620 74111 PRINCIPAL PAYMENT 2,974,050 1,291,254 1,362,242 2,039,980 400 74112 INTEREST PAYMENT 1,709,135 1,666,658 1,543,206 1,500,579 620 74112 INTEREST PAYMENT 620,431 575,623 799,017 719,465 74 - DEBT SERVICE 7,612,152 5,647,000 5,853,704 6,448,888 620 91100 TO GENERAL 470,674 469,385 527,544 608,650 620 91720 TO STORM SEWER CONST 0 1,525,000 1,210,000 880,000 91 TRANSFER TO 470,674 1,994,385 1,737,544 1,488,650 55 - ENGINEERING TOTAL 12,480,308 12,056,759 12,632,920 13,448,204 -139- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING ENGINEERING ADMIN. - 55100 FUNDING SOURCE: ENGINEERING SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES - 6,800 - EQUIPMENT 13,384 12,546 8,200 SUPPLIES AND SERVICES 83,658 92,325 96,949 WAGES AND BENEFITS 1,600,276 388,030 358,144 1.11Wi EERING ADMIN. LEASES 1,697,318 - 55150 MIMI FUNDING SOURCE: GENERAL Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 89,681 94,596 98,890 WAGES AND BENEFITS 16,066 11,724 LEASES 105,746 i 94,596 PROJECT ENGINEERING 55400 . 'IM FUNDING SOURCE: DEBT SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES 398 100,000 92,868 DEBT SERVICE 1,137,454 1,130,122 1,127,562 EQUIPMENT 282,944 367,162 551,345 SUPPLIES AND SERVICES 270,955 418,432 447,713 WAGES AND BENEFITS 716,698 1,383,810 1,529,161 PROJECT ENGINEERING 2,408,448 SUBDIVISION INSPECTIONS - 55405 3,399,526 FUNDING SOURCE: GENERAL Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 136,606 57,521 57,476 WAGES AND BENEFITS 8,484 24,701 26,730 SUBDIVISION INSPECTIONS 145,090 M FATS OILS GREASE - 55500 82,222 FUNDING SOURCE: SEWAGE FACILITY OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 8 8 FATS OILS GREASE 8 SANITARY SEWER INT SERV - 55610 FUNDING SOURCE: ENGINEERING SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget WAGES AND BENEFITS 277,090 352,137 NITARY SEWER INT SERV -11M277,09 5 , 7 STORMWATER UTILITY O&M - 55620 -140- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING FUNDING SOURCE: ENGINEERING SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES 6,600 50,000 50,000 CONTRACTUAL SERVICES - - - DEBT SERVICE 1,866,877 2,161,259 2,759,445 EQUIPMENT 3,210 9,396 5,620 SUPPLIES AND SERVICES 677,743 732,612 836,551 TRANSFER TO 1,994,385 1,737,544 1,488,650 WAGES AND BENEFITS 113,818 584,326 472,500 STORMWATER UTILITY O&M 4,662,633 5,275,137 5,612,766 RESIDENTIAL PARKING 55630 FUNDING SOURCE: PARKING OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 40 0 40 WAGES AND BENEFITS 1 2,004 2,792 RESIDENTIAL PARKING 2,045 TRAFFIC ENGINEERING - 55700 FUNDING SOURCE: ENGINEERING SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget EQUIPMENT 9,035 4,500 24,400 SUPPLIES AND SERVICES 35,344 28,563 30,385 WAGES AND BENEFITS 57,624 125,842 148,652 TRAFFIC ENGINEERING 102,003 158,905 203,437 NPDES DISCHARGE ELIM SYST- 55750 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 1,350 793 2,154 WAGES AND BENEFITS 24,187 5,032 6,529 NPDES DISCHARGE ELIM SYST 25,536 NPDES EROSION & SED CONTR- 55751 5,825 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 77 1,892 1,972 WAGES AND BENEFITS 25,157 37,195 2,151 1 NPDES EROSION & SED CONTR 25,234 NPDES DISCHARGE DETECTION- 55752 39,087 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 712 548 817 WAGES AND BENEFITS 4,305 1,860 1,320 -141- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING NPDES DISCHARGE DETECTION 5,017 2,408 2,137 NPDES MUNICIPAL OPERATION- 55753 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES - 790 - WAGES AND BENEFITS 9,636 5,804 5,347 NPDES MUNICIPAL OPERATION 9,636 NPDES PUBLIC EDUCATION - 55754 6,594 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 7,024 1,500 10,552 WAGES AND BENEFITS 19,394 5,834 12,942 MMIlir NPDES PUBLIC EDUCATION 26,418 NPDES PUBLIC PARTICIPATIO- 55755 EMI 7,334 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 2,314 5,000 5,000 WAGES AND BENEFITS 35,744 1,862 9,148 NPDES PUBLIC PARTICIPATIO 38,057 NPDES POST CONSTRUCTION - 55756 6,862 L 14,148 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES 2,450 SUPPLIES AND SERVICES 13,597 5,032 5,032 WAGES AND BENEFITS 45,600 34,341 49,641 11 NPDES POST CONSTRUCTION 61,647 39,373 54,673 SALES TAX INCR DEBT - 55800 FUNDING SOURCE: DEBT SERVICE Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget DEBT SERVICE 2,642,669 2,562,323 2,561,881 SALES TAX INCR DEBT 2,642,669 STORMWATER I & I PREVENT - 55900 2,562,323 r 2,561,881 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES SUPPLIES AND SERVICES WAGES AND BENEFITS 4,500 10,693 10,803 67,365 94,823 109,872 v STORMWATER I & I PREVENT 71,865 105,516 120,675 STORMWATER DITCH REMEDIAT- 55910 FUNDING SOURCE: STORM WATER OPERATION -142- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES 3,950 SUPPLIES AND SERVICES WAGES AND BENEFITS 453 5,000 10,000 3,785 0 0 STORMWATER DITCH REMEDIAT 8,188 5,000 10,000 STREAMBANK REHAB ASSIST - 55911 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES MI STREAMBANK REHAB ASSIST DETENTION BASIN MAINTENAN- 55920 FUNDING SOURCE: STORM WATER OPERATION Account 5,000 5,000 5,000 FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget CIP EXPENDITURES — 15,000 15,000 SUPPLIES AND SERVICES 16,001 41,251 40,931 WAGES AND BENEFITS 3,326 DETENTION BASIN MAINTENAN 19,327 56,251 55,931 STORM SEWER INSP & CLEAN - 55930 FUNDING SOURCE: STORM WATER OPERATION Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES 0 4,170 4,170 STORM SEWER INSP & CLEAN 0 PCARD CLEARING - 99999 FUNDING SOURCE: GENERAL Account FY19 Actual Expense FY20 Adopted Budget FY21 Recomm'd Budget SUPPLIES AND SERVICES (127) 0 0 PCARD CLEARING ENGINEERIN ENGINEERING TOTAL (127) 0 0 $12,056,759 $12,632,920 $13,448,204 -143- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FD JC WP- JOB CLASS 61010 Full Time Employee Expense 100 9425 GE-44 CITY ENGINEER 610 9425 GE-44 CITY ENGINEER 620 9425 GE-44 CITY ENGINEER 800 9425 GE-44 CITY ENGINEER 100 3125 GE-40 ASSISTANT CITY ENGINEER 800 3125 GE-40 ASSISTANT CITY ENGINEER 100 4060 GE-40 PROJECT MANAGER 610 4060 GE-40 PROJECT MANAGER 800 4060 GE-40 PROJECT MANAGER 100 GE-35 CIVIL ENGINEER I 800 GE-35 CIVIL ENGINEER I 620 5525 GE-38 CIVIL ENGINEER II 610 5525 GE-38 CIVIL ENGINEER II 100 5525 GE-38 CIVIL ENGINEER II 800 5525 GE-38 CIVIL ENGINEER II 100 GE-28 CAMERA SYSTEMS TECHNICIAN 800 GE-28 CAMERA SYSTEMS TECHNICIAN 100 5,700 GE-36 SURVEYOR 800 5,700 GE-36 SURVEYOR 100 5550 GE-33 TRAFFIC ENGINEERING 800 5550 GE-33 TRAFFIC ENGINEERING 100 GE-35 TRAFFIC ENGINEER 800 GE-35 TRAFFIC ENGINEER 100 5575 GE-33 SURVEY PARTY CHIEF 800 5575 GE-33 SURVEY PARTY CHIEF 100 GE-31 ROW TECHNICAN 800 GE-31 ROW TECHNICIAN 100 2700 GE-31 ENGINEERING ASSISTANT II 620 2700 GE-31 ENGINEERING ASSISTANT II 800 2700 GE-31 ENGINEERING ASSISTANT II 100 2700 GE-31 ENGINEERING TECHNICAN 610 2700 GE-31 ENGINEERING TECHNICAN 620 2700 GE-31 ENGINEERING TECHNICAN 630 2700 GE-31 ENGINEERING TECHNICAN 800 2700 GE-31 ENGINEERING TECHNICAN 100 2,725 GE-30 SURVEY TECHNICIAN 800 2,725 GE-30 SURVEY TECHNICIAN 100 4,870 GE-28 UTILITY LOCATOR 610 4870 GE-28 UTILITY LOCATOR 620 4870 GE-28 UTILITY LOCATOR 640 4870 GE-28 UTILITY LOCATOR 100 225 GE-25 SECRETARY 610 225 GE-25 SECRETARY 620 225 GE-25 SECRETARY 800 225 GE-25 SECRETARY 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 620 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK TOTAL FULL TIME EMPLOYEES FY 2019 FY 2020 FY 2021 FTE BUDGET FTE BUDGET FTE BUDGET 0.25 0.10 0.10 0.55 0.25 0.75 0.40 0.10 0.50 0.00 0.00 0.15 0.10 0.95 2.80 0.00 0.00 0.80 0.20 0.87 0.13 0.60 0.40 0.15 0.85 0.00 0.00 1.00 0.10 0.90 1.90 0.05 0.95 0.00 6.10 0.15 0.85 0.25 0.25 0.25 0.25 0.25 0.25 0.00 0.50 0.50 0.25 0.25 0.00 26.0 $ 34,431 $ 13,772 $ 13,772 $ 75,748 $ 27,375 $ 82,126 $ 43,170 $ 10,793 $ 53,962 $ $ $ 14,604 $ 9,799 $ 89,134 $ 262,024 $ $ $ 68,446 $ 17,112 $ 18,807 $ 2,810 $ 49,032 $ 32,689 $ 11,354 $ 64,337 $ $ $ 68,555 $ 6,796 $ 61,236 $ 127,219 $ 3,301 $ 62,449 $ $ 405,100 $ 9,645 $ 54,637 $ 14,054 $ 14,054 $ 14,054 $ 14,054 $ 12,044 $ 12,044 $ $ 24,088 $ 23,712 $ 11,856 $ 11,856 $ $1,946,051 0.30 0.15 0.15 0.40 0.30 0.70 0.40 0.10 0.50 0.00 0.00 0.20 0.10 0.95 2.75 0.00 0.00 0.80 0.20 0.00 0.00 1.47 0.53 0.15 0.85 0.90 0.10 0.10 0.10 0.80 1.90 0.10 1.00 0.00 6.00 0.15 0.85 0.25 0.25 0.25 0.25 0.25 0.25 0.00 0.50 0.90 0.30 0.30 0.50 27.0 $ 42,261 $ 21,131 $ 21,131 $ 56,349 $ 33,764 $ 78,782 $ 44,153 $ 11,038 $ 55,190 $ $ $ 19,951 $ 10,024 $ 91,171 $ 263,001 $ $ $ 70,622 $ 17,656 $ $ $ 108,299 $ 42,120 $ 11,611 $ 65,795 $ 48,594 $ 5,399 $ 6,999 $ 6,999 $ 55,990 $ 116,196 $ 6,784 $ 68,356 $ $ 394,773 $ 9,881 $ 55,992 $ 14,374 $ 14,374 $ 14,374 $ 14,374 $ 12,368 $ 12,368 $ $ 24,736 $ 40,758 $ 14,189 $ 14,189 $ 20,636 $2,036,752 0.30 $ 42,732 0.15 $ 21,366 0.15 $ 21,366 0.40 $ 54,220 0.30 $ 34,136 0.70 $ 79,652 0.40 $ 44,639 0.10 $ 11,160 0.50 $ 55,800 0.25 $ 21,292 0.75 $ 62,030 0.77 $ 76,511 0.10 $ 9,988 0.80 $ 80,990 2.33 $ 234,013 0.50 $ 23,239 0.50 $ 23,239 0.80 $ 55,693 0.20 $ 17,854 0.00 $ 0.00 $ - 1.37 $ 101,053 0.63 $ 51,038 0.15 $ 11,401 0.85 $ 66,522 0.90 $ 46,529 0.10 $ 5,757 0.10 $ 7,097 0.10 $ 7,097 0.80 $ 56,774 1.90 $ 126,691 0.10 $ 6,860 0.15 $ 10,409 0.03 $ 2,069 5.82 $ 393,387 0.15 $ 9,606 0.85 $ 56,610 0.25 $ 14,654 0.25 $ 14,654 0.25 $ 14,654 0.25 $ 14,654 0.80 $ 40,021 0.05 $ 2,501 0.05 $ 2,501 0.10 $ 5,002 0.90 $ 41,004 0.25 $ 11,252 0.25 $ 11,252 0.60 $ 27,714 28.0 $2,128,683 -144- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL - PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FD JC WP- JOB CLASS 61020 Part -Time Employee Expense 620 GE-26 I&I INSPECTOR 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK TOTAL PART TIME EMPLOYEES 61030 Seasonal Employee Expense 100 100 800 800 5325 NA-34 NA-34 NA-34 5325 NA-34 ENGINEERING AIDE -SEASONAL ENGINEERING INTERN ENGINEERING INTERN ENGINEERING AIDE -SEASONAL TOTAL SEASONAL EMPLOYEES FY 2019 FY 2020 FY 2021 FTE BUDGET FTE BUDGET FTE BUDGET 1.48 0.35 0.90 2.73 $ 73,974 $ 13,395 $ 34,445 $ 121,814 0.50 $ 0.00 $ 0.00 $ 1.00 $ 1.50 $ 1.46 0.00 0.00 1.46 $ 74,638 $ $ $ 74,638 16,672 0.50 $ — 0.00 $ — 0.00 $ 33,344 1.00 $ 50,016 1.50 $ 1.46 0.00 0.00 1.46 $ 75,480 $ $ 75,480 17,050 0.00 $ — 0.25 $ — 1.00 $ 34,100 0.00 $ 51,150 1.25 $ 7,423 29,692 37,115 TOTAL ENGINEERING 30.23 $ 2,117,881 29.96 $ 2,162,540 30.71 $ 2,241,278 -145- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP-GR POSITION CLASS FY 2019 FY 2020 FY 2021 FTE BUDGET FTE BUDGET FTE BUDGET Engineering Administration -FT General Fund 10055100 61010 100 225 GE-25 SECRETARY 0.25 $ 12,044 0.25 $ 12,368 0.05 $ 2,501 10055100 61010 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.25 $ 11,856 0.65 $ 28,633 0.65 $ 29,752 10055100 61010 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.25 $ 27,375 0.30 $ 33,764 0.30 $ 34,136 10055100 61010 100 4060 GE-40 PROJECT MANAGER 0.40 $ 43,170 0.40 $ 44,153 0.40 $ 44,639 10055100 61010 100 9425 GE-44 CITY ENGINEER 0.25 $ 34,431 0.30 $ 42,261 0.30 $ 42,732 Engineering Administration -PT General Fund 10055100 61020 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK Total 1.40 $ 128,876 1.90 $ 161,179 1.70 $ 153,760 0.35 $ 13,395 0.00 $ - 0.00 $ Total 0.35 $ 13,395 0.00 $ - 0.00 $ Engineering Administration -Seasonal General Fund 10055100 61030 100 NA-34 ENGINEERING AIDE 0.00 $ - 0.25 $ 8,525 0.00 $ Total 0.00 $ - 0.25 $ 8,525 0.00 $ Engineering Administration -FT Service Fund CONFIDENTIAL ACCOUNT 80055100 61010 800 1000 GE-25 CLERK 0.00 $ 0.05 $ 2,064 0.00 $ 80055100 61010 800 3125 GE-38 ASSISTANT CITY ENGINEER 0.75 $ 82,126 0.70 $ 78,782 0.70 $ 79,652 80055100 61010 800 4060 GE-40 PROJECT MANAGER 0.10 $ 10,793 0.10 $ 11,038 0.10 $ 11,160 80055100 61010 800 225 GE-25 SECRETARY 0.25 $ 12,044 0.25 $ 12,368 0.00 $ - 80055100 61010 800 9425 GE-44 CITY ENGINEER 0.25 $ 34,431 0.15 $ 21,131 0.15 $ 21,366 Total 1.35 $ 139,394 1.25 $ 125,383 0.95 $ 112,178 Engineering Leases - FT General Fund 10055150 61010 100 CONFIDENTIAL ACCOUNT GE-25 CLERK Total Engineering Leases - FT General Fund 10055150 61010 100 NA-24 ENGINEERING INTERN Total 0.00 $ - 0.00 $ - 0.05 $ 2,324 0.00 $ - 0.00 $ - 0.05 $ 2,324 0.00 $ - 0.00 $ - 0.25 $ 7,423 0.00 $ - 0.00 $ - 0.25 $ 7,423 Project Engineering -FT General Fund 10055400 61010 100 2700 GE-31 ENGINEERING ASSISTANT II 1.00 $ 68,555 0.10 $ 6,999 0.10 $ 7,097 10055400 61010 100 GE-31 ROW TECHNICIAN 0.00 $ 0.90 $ 48,594 0.90 $ 46,529 10055400 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 1.60 $ 107,277 1.60 $ 98,444 1.60 $ 107,514 10055400 61010 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 9,645 0.15 $ 9,881 0.15 $ 9,606 10055400 61010 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 11,354 0.15 $ 11,611 0.15 $ 11,401 10055400 61010 100 4710 GE-35 TRAFFIC ENGINEER 0.60 $ 49,032 0.60 $ 50,147 0.50 $ 42,251 10055400 61010 100 GE-35 CIVIL ENGINEER I 0.00 $ 0.00 $ 0.25 $ 21,292 CAMERA SYSTEMS 10055400 61010 100 GE-28 TECHNICIAN 0.00 $ 0.00 $ 0.50 $ 23,239 10055400 61010 100 GE-25 SECRETARY 0.00 $ 0.00 $ 0.45 $ 22,512 10055400 61010 100 5525 GE-38 CIVIL ENGINEER II 0.95 $ 89,134 0.95 $ 91,171 0.80 $ 80,990 10055400 61010 100 5700 GE-36 SURVEYOR 0.80 $ 68,446 0.80 $ 70,622 0.80 $ 55,693 Total 5.25 $ 403,443 5.25 $ 387,469 6.20 $ 428,124 Project Engineering -Seasonal General Fund 10055400 61030 100 5325 NA-34 ENGINEERING AIDE -SEASONAL 0.50 $ 16,672 0.25 $ 8,525 0.00 $ Total 0.50 $ 16,672 0.25 $ 8,525 0.00 $ Project Engineering Subdivision Inspection -FT General Fund 10055405 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 0.30 $ 19,942 0.30 $ 17,752 0.30 $ 19,177 Total 0.30 $ 19,942 0.30 $ 17,752 0.30 $ 19,177 -146- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP-GR POSITION CLASS Project Engineering -FT Service Fund 80055400 80055400 80055400 80055400 80055400 80055400 80055400 80055400 80055400 80055400 80055400 61010 61010 61010 61010 61010 61010 61010 61010 61010 61010 61010 800 800 800 800 800 800 800 800 800 800 800 GE-28 GE-31 2700 GE-31 2220 2725 5575 5525 4710 5700 GE-25 GE-35 GE-31 GE-30 GE-33 GE-38 GE-35 GE-36 CAMERA SYSTEMS TECHNICIAN ROW TECHNICIAN ENGINEERING ASSISTANT II CONFIDENTIAL ACCOUNT CLERK CIVIL ENGINEER I ENGINEERING TECHNICIAN SURVEY TECHNICIAN SURVEY PARTY CHIEF CIVIL ENGINEER II TRAFFIC ENGINEER SURVEYOR FY 2019 FTE BUDGET FY 2020 FY 2021 FTE BUDGET FTE BUDGET 0.00 0.00 0.50 0.00 0.00 2.90 0.30 0.30 1.55 0.40 0.20 $ 34,049 193,636 19,272 22,707 139,913 32,689 17,112 0.00 0.10 0.40 0.00 0.00 2.50 0.30 0.30 1.55 0.40 0.20 $ 5,399 $ 27,995 161,223 19,762 23,222 143,105 33,431 17,656 0.50 0.10 0.40 0.05 0.55 2.67 0.30 0.30 1.20 0.50 0.20 $ 23,239 $ 5,757 $ 28,387 $ 2,232 $ 45,488 $ 179,946 $ 19,980 $ 23,478 $ 120,746 $ 42,251 $ 17,854 Total 6.15 $ 459,378 5.75 $ 431,793 6.77 $ 509,358 Project Engineering -Seasonal Service Fund 80055400 61030 800 5325 NA-34 ENGINEERING AIDE -SEASONAL 1.00 $ 33,344 1.00 $ 34,100 1.00 $ 29,692 Total 1.00 $ 33,344 1.00 $ 34,100 1.00 $ 29,692 Traffic Engineering -FT General Fund CONFIDENTIAL ACCOUNT 10055700 61010 100 1000 GE-25 CLERK 0.25 $ 11,856 0.25 $ 12,125 0.20 $ 8,928 10055700 61010 100 GE-25 SECRETARY 0.30 $ 15,008 10055700 61010 100 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,054 0.25 $ 14,374 0.25 $ 14,654 10055700 61010 100 GE-35 TRAFFIC ENGINEER 0.00 $ 0.87 $ 58,152 0.87 $ 58,802 10055700 61010 100 5550 GE-33 TRAFFIC ENGINEERING ASSIST 0.87 $ 18,807 0.00 $ 0.00 $ - Total 1.37 $ 44,717 1.37 $ 84,651 1.62 $ 97,392 Traffic Engineering -FT Service Fund 80055700 61010 800 5550 GE-33 TRAFFIC ENGINEERING ASSIST 0.13 $ 80055700 61010 800 GE-35 TRAFFIC ENGINEER 0.00 $ Project Engineering -FT Sewer Fund 61055400 61010 610 4870 GE-28 61055400 61055400 61055400 61055400 61055400 61055400 61055400 61010 61010 61010 61010 61010 61010 61010 610 610 610 610 610 610 610 1000 5525 4060 9425 2710 225 2220 GE-25 GE-38 GE-40 GE-44 GE-26 GE-25 GE-31 NPDES PERMIT -FT Stormwater Fund 62055750 62055750 62055751 62055751 62055752 62055752 62055753 62055753 62055754 62055754 62055755 62055755 61010 61010 61010 61010 61010 61010 61010 61010 61010 61010 61010 61010 620 620 620 620 620 620 620 620 620 620 620 620 2220 1900 2220 2230 2220 2230 2220 1900 2220 1900 2220 GE-31 GE-38 GE-31 GE-38 GE-31 GE-38 GE-31 GE-38 GE-31 GE-38 GE-31 GE-38 UTILITY LOCATOR CONFIDENTIAL ACCOUNT CLERK 0.25 CIVIL ENGINEER II 0.10 PROJECT MANAGER 0.10 CITY ENGINEER 0.10 I&I INSPECTOR 0.00 SECRETARY 0.25 ENGINEERING TECHNICIAN 0.05 2,810 0.00 $ - 0.00 $ - 0.13 $ 8,689 0.13 $ 8,787 Total 0.13 $ 2,810 0.13 $ 8,689 0.13 $ 8,787 0.25 $ 14,054 $ 11,856 $ 9,799 $ 10,793 $ 13,772 $ $ 12,044 $ 3,301 0.25 $ 14,374 0.25 $ 14,654 0.30 0.10 0.10 0.15 0.00 0.25 0.10 $ 14,189 $ 10,024 $ 11,038 $ 21,131 $ $ 12,368 $ 6,784 0.25 0.10 0.10 0.15 0.00 0.05 0.10 $ 11,252 $ 9,988 $ 11,160 $ 21,366 $ $ 2,501 $ 6,860 Total 1.10 ENGINEERING TECHNICIAN CIVIL ENGINEER II ENGINEERING TECHNICIAN CIVIL ENGINEER II ENGINEERING TECHNICIAN CIVIL ENGINEER II ENGINEERING TECHNICIAN CIVIL ENGINEER II ENGINEERING TECHNICIAN CIVIL ENGINEER II ENGINEERING TECHNICIAN CIVIL ENGINEER II $ 75,619 1.25 $ 89,908 1.00 $ 77,781 0.04 $ 2,614 0.04 $ 0.01 $ 980 0.01 $ 0.40 $ 26,141 0.40 $ 0.00 $ - 0.00 $ 0.02 $ 1,307 0.02 $ 0.00 $ 0.00 $ 0.02 $ 1,307 0.02 $ 0.03 $ 2,940 0.03 $ 0.05 $ 3,431 0.05 $ 0.00 $ 0.01 $ 0.02 $ 1,372 0.02 $ 0.00 $ 0.00 $ 2,731 1,002 27,322 1,367 1,367 3,008 3,415 1,002 1,367 0.00 0.03 0.00 0.01 0.00 0.01 0.00 0.04 0.00 0.10 0.00 0.07 3,011 984 984 4,025 9,988 7,036 -147- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP-GR POSITION CLASS 62055756 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 62055756 61010 620 1900 GE-38 CIVIL ENGINEER II Sanitary Utility -FT Service Fund 80055610 80055610 80055610 80055610 80055610 80055610 80055610 80055610 80055610 61010 61010 61010 61010 61010 61010 61010 61010 61010 800 800 800 800 800 800 800 800 800 5525 GE-38 GE-35 9425 GE-44 2220 GE-31 2725 GE-30 5575 GE-33 1000 225 4060 Sanitary Utility -PT Service Fund GE-25 GE-25 GE-40 80055610 61010 800 1000 GE-25 Project Engineering -FT Stormwater Fund 62055620 61010 620 2220 GE-31 62055620 61010 620 4870 GE-28 62055620 62055620 62055620 62055620 62055620 61010 61010 61010 61010 61010 620 620 620 620 620 1000 9425 2700 225 1900 GE-33 GE-44 GE-31 GE-25 GE-38 Stormwater Utility FT Stormwater 62055900 61010 620 2230 GE-38 Stormwater Utility -PT Stormwater 62055900 61020 620 2710 GE-26 Stormwater Utility -FT Service Fund 80055620 80055620 80055620 80055620 80055620 80055620 80055620 80055620 80055620 61010 61010 61010 61010 61010 61010 61010 61010 61010 800 800 800 800 800 800 800 800 800 5525 GE-38 9425 GE-44 GE-35 GE-25 2220 GE-31 2700 GE-31 2725 GE-30 4060 GE-40 5575 GE-33 80055620 61010 800 1000 GE-25 80055620 61010 800 2710 GE-26 Stormwater Utility -PT Service Fund 80055620 61020 800 1000 GE-25 CIVIL ENGINEER II CIVIL ENGINEER I CITY ENGINEER FY 2019 FTE BUDGET 0.30 $ 19,606 0.01 $ 980 FY 2020 FTE BUDGET 0.30 $ 20,493 0.05 $ 5,012 FY 2021 FTE BUDGET 0.00 $ 0.38 $ 37,690 Total 0.90 $ 60,678 0.95 $ 68,086 0.64 $ 63,718 ENGINEERING TECHNICIAN SURVEY TECHNICIAN SURVEY PARTY CHIEF CONFIDENTIAL ACCOUNT CLERK SECRETARY PROJECT MANAGER CONFIDENTIAL ACCOUNT CLERK 0.00 $ - 0.00 $ 0.20 1.50 0.30 0.30 0.00 0.25 0.15 27,545 99,041 19,290 22,707 12,044 16,188 0.15 1.65 0.30 0.30 0.10 0.25 0.15 21,131 109,630 19,762 23,222 4,127 12,368 16,557 0.45 $ 0.10 $ 0.15 $ 1.80 $ 0.30 $ 0.30 $ 0.15 $ 0.05 $ 0.15 $ 44,431 8,271 21,366 121,911 19,980 23,478 6,982 2,501 16,740 Total 2.70 $ 196,815 2.90 $ 206,797 3.45 $ 265,660 0.15 $ 5,741 0.00 $ - 0.00 $ Total 0.15 $ 5,741 0.00 $ ENGINEERING TECHNICIAN UTILITY LOCATOR CONFIDENTIAL ACCOUNT CLERK CITY ENGINEER ENGINEERING ASST II SECRETARY CIVIL ENGINEER II CIVIL ENGINEER II Total I&I INSPECTOR - 0.00 $ 0.10 $ 6,671 0.15 $ 10,294 0.15 $ 10,409 0.25 $ 14,054 0.25 $ 14,374 0.25 $ 14,654 0.25 $ 11,856 0.30 $ 14,189 0.25 $ 0.10 $ 13,772 0.15 $ 21,131 0.15 $ 0.10 $ 6,796 0.10 $ 6,999 0.10 $ 0.00 $ - 0.00 $ - 0.05 $ 0.10 $ 9,704 0.10 $ 9,927 0.00 $ 11,252 21,366 7,097 2,501 Total 0.90 $ 62,853 1.05 $ 76,914 0.95 $ 67,279 0.00 $ - 0.00 $ - 0.13 $ 12,793 0.00 $ - 0.00 $ - 0.13 $ 12,793 1.48 $ 73,974 1.46 $ 74,638 1.46 $ 75,480 Total 1.48 $ 73,974 1.46 $ 74,638 1.46 $ 75,480 CIVIL ENGINEER II CITY ENGINEER CIVIL ENGINEER I SECRETARY ENGINEERING TECHNICIAN ENGINEERING ASST II SURVEY TECHNICIAN PROJECT MANAGER SURVEY PARTY CHIEF CONFIDENTIAL ACCOUNT CLERK I&I INSPECTOR CONFIDENTIAL ACCOUNT CLERK Total 1.25 0.10 0.00 0.00 1.70 0.40 0.25 0.25 0.25 $ 122,111 $ 13,772 $ $ 112,423 $ 27,187 $ 16,075 $ 26,981 $ 18,923 1.20 0.10 0.00 0.00 1.85 0.40 0.25 0.25 0.25 $ 119,896 $ 14,087 $ $ 123,920 $ 27,995 $ 16,468 $ 27,595 $ 19,351 0.68 0.10 0.10 0.05 1.35 0.40 0.25 0.25 0.25 $ 68,836 $ 11,488 $ 8,271 $ 2,501 $ 91,530 $ 28,387 $ 16,650 $ 27,900 $ 19,566 0.00 $ 0.35 $ 14,445 0.40 $ 0.00 $ - 0.00 $ - 0.00 $ 4.20 $ 337,472 4.65 $ 363,757 3.83 $ 0.75 $ 28,704 0.00 $ - 0.00 $ 18,500 293,629 Total 0.75 $ 28,704 0.00 $ - 0.00 $ -148- CITY OF DUBUQUE, IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY ACCT FD JC WP-GR POSITION CLASS Residential Parking - FT 63055630 61010 FY 2019 FY 2020 FY 2021 FTE BUDGET FTE BUDGET FTE BUDGET GE-31 ENGINEERING TECHNICIAN 0.00 $ — 0.00 $ — 0.03 $ 2,069 Total 0.00 $ — 0.00 $ — 0.03 $ 2,069 Water Utility -FT 64055400 61010 620 4870 GE-28 UTILITY LOCATOR 0.25 $ 14,054 0.25 $ 14,374 0.25 $ 14,654 Total 0.25 $ 14,054 0.25 $ 14,374 0.25 $ 14,654 TOTAL ENGINEERING DIVISION 30.23 $ 2,117,881 29.96 $ 2,162,540 30.71 $ 2,241,278 -149- Capital Improvement Projects by Department/Division CIP Number Capital Improvement Project Title FY 21 FY 18 Actual FY 19 Actual FY 20 Adopted Recomm'd Budget Expense Expense Budget 1001108 SIDEWALK REPAIR/MAINTENAN 1001200 RIVER DISCOVERY CENTER 1002779 EXCURSION BOAT DOCKS - 18,500 1021857 UTILITY FRANCHISE ANALYSI 606,303 1021963 RIVERWALK SECURITY CAMERA 1022673 16TH ST DET BASIN TRAIL 672 - 597,000 1022674 KERPER BLVD FIBER AND CAM 96,442 2,696 - 1022763 STREETS TRAFFIC CONTROL 250,000 1022798 PAVEMENT PRESERVATION 48,000 2501039 CORRIDOR STUDY ALTERNATES 1,948 159 0 2501210 GRANDVIEW AVE.LIGHT POLES - 0 2501281 JACKSON ST. RECONSTRUCTIO 0 2501287 SOUTHWEST ARTERIAL 18,217 0 2501576 VILLA WALL 2501702 3RD ST OVERPASS -PAINT - 0 2502253 ITS TRAFFIC CONTROL EQUIP 20,500 0 2502274 US 52/CENTRAL TRAFFIC IMP 71,077 537,095 0 2502422 TRAFFIC OPS CTR VIDEO SOF 0 2502676 CITY-WIDE SECURITY CAMERA 1,689 - 0 2502797 7TH ST EXT TO PINE 88,400 0 2502799 INET FIBER BUILD OUT 100,000 0 2601236 WHEEL CHAIR RAMPS - 12,600 0 2601239 NEIGHBORHOOD REL IMPROVEM 236,273 10,000 0 2601549 STREET LIGHT REPLACEMENT 8,084 - 0 2602767 LEAD SVC LINE REPLACE - 30,000 0 2602776 SIDEWALKS - 12,148 - 0 2642769 HUD RESILIENCY ENGINEER 2,121,753 6,245,593 8,128,055 8,194,419 3001011 SIGNALIZATION PROGRAM 40,256 60,751 80,000 70,000 3001023 INTERSECTION PREEMPTION 6,260 - 15,000 15,000 3001027 GUARDRAIL REPLACEMENT 8,718 - 10,000 0 3001029 STONE RETAINING WALLS 42,548 198,065 - 0 3001039 CORRIDOR STUDY -ALTERNATES - 12,000 - 0 3001041 CURB/CATCH BASIN REPL 69,969 10,684 10,000 25,000 3001133 TRAFFIC SIGNAL MASTARM RE 38,134 4,126 80,000 65,000 3001210 GRANDVIEW AVE.LIGHT POLES 110,571 13,015 50,000 35,000 3001229 TRAFFIC CONTR BATTERY PCK - 2,119 20,000 10,000 3001256 SPECIAL ASSESSMENT ASSIST 41,286 0 3001258 BRIDGE REPAIRS/MAINT. 6,009 3,502 85,000 0 3001266 TRAFFIC SIGNAL INTERCONNE 84,703 20,795 40,000 30,000 3001274 TRAFFIC CONTROLLER REPLAC 2,253 41,697 45,000 35,000 3001287 SOUTHWEST ARTERIAL 5,870,338 4,259,584 100,000 550,000 3001425 SIDEWALK PROGRAM CITY OWN 44,580 50,912 - 170,000 3001466 HARBOR AREA MAINTENANCE 0 3001549 STREET LIGHT REPLACEMENT 19,819 1,018 - 20,000 3001615 SIGNAL INTERSEC RECONSTRU 127,652 - 65,000 40,000 3001630 DECORATIVE CONCRETE MAINT 6,551 92,939 - 0 3001631 TRAFF SIG FIBER OPTIC NET 95,473 85,520 80,000 65,000 3001634 WHITE WATER CREEK BRIDGE 0 3001702 3RD ST OVERPASS -PAINT 120,000 3001816 TRAFFIC SIG VIDEO DET CON 74,749 52,000 50,000 3001916 LED RE -LAMP SCHEDULE - 29,000 0 3001922 SAFE ROUTES TO SCHOOL 0 3002021 N CASCADE RD RECONSTRUCT 2,164 19,445 0 3,343 122 2,214 30,000 30,000 0 0 0 0 0 0 1,600,000 -150- Capital Improvement Projects by Department/Division CIP Number Capital Improvement Project Title FY 21 FY 18 Actual FY 19 Actual FY 20 Adopted Recomm'd Budget Expense Expense Budget 3002142 STREET CONST-GENERAL 3002144 FIBER OPTIC CONDUIT-MISC 3002245 PAVEMENT MARKING 3002252 ST LIGHT/SIGNAL KNOCKDOWN 3002253 ITS TRAFFIC CONTROL EQUIP 3002256 PENN@RADFORD 1NTERESECT 3002324 UNI & ASBURY INTER IMPROV 3002336 N GRANDVIEW ESTATES ROAD 41,932 15,664 113,320 18,275 49,500 2,900 81,282 60,431 120,387 70,202 4,800 4,751 682,644 83,000 50,000 135,000 30,000 17,000 100,000 40,000 135,000 25,000 20,000 0 0 0 3002420 SRGE AND GRND IMPR SIGNAL 1,678 8,364 15,000 10,000 3002421 STREET CAMERA INSTALL 37,773 25,504 75,000 70,000 3002422 TRAFIC OPS CTR VIDEO SOFT 4,983 58,520 - 0 3002423 TRAFIC OPS CNTR EQUP TEST 758 116 0 3002484 LED STREETLIGHT RETROFIT 2,401 - 0 3002491 FIBER OPTICS TO AIRPORT 106,214 321 0 3002552 WASH ST RECON 8TH TO 9TH - 28,948 0 3002557 FLASH YELLOW LEFT TURN 1,148 0 3002558 REPLC LED SIGNS BEACONS 0 3002559 GRANDVIEW SIGNAL RECON 339,559 0 3002611 GRANDVIEW/DELHI ROUNDABOU 1,062 - 0 3002612 HEEB STREET RECON - 50,000 0 3002615 WAH NEIGH STREET LIGHTS 672 - 0 3002617 JFK RD COORD WACKER/ASB 3,774 0 3002618 WEST LOCUST COMM/CAMERAS 13,786 14,125 92,000 0 3002619 UNIV/ASBURY FIBER/CAMERA 2,199 0 3002620 FIBER/NETWORK MGMT PROG 253 275 50,450 0 3002634 SMARTER TRAVEL PROJECT 5,987 0 3002674 KERPER BLVD FIBER AND CAM 22,220 4,830 0 3002675 NW ARTERIAL TURN LANE IMP 43,354 203,722 0 3002676 CITY-WIDE SECURITY CAMERA 116,385 75,119 0 3002695 NW ARTERIAL LEFT TURN LN 9,160 - 0 3002717 POD IRRIGATION REPLACEMEN 5,101 - 0 3002724 GRNDVW/UNVRSTYROUNDABOUT 151,804 1,356,008 0 3002735 JFK DITCH IMPROVEMENTS 18,785 - 0 3002761 DERBY GRANGE RESURFACE 0 3002762 LANDFILL ACCESS ROAD 2,329 1,331 97,000 0 3002763 STREETS TRAFFIC CONTROL 100,000 3,216,250 3002796 CENTRAL AVE 1 TO 2 WAY 180,000 0 3002798 PAVEMENT PRESERVATION 32,984 0 3002799 INET FIBER BUILD OUT - 90,000 3002800 ASBURY RD SIGNALIZATION 120,000 0 3002801 FIBR REEL TRAILER/TOOLS 15,000 0 3002848 SW ARTERIAL ITS CORRIDOR - 850,000 3002849 PAVE REHAB CONCRETE ST 520,000 3002850 NW ARTERIAL LEFT ON JFK 180,000 3002851 PAVE PRES JOINT SEALING 50,000 3002852 BRICK PAVER MAINT 30,000 3002856 ASBURY & JFK SIGNAL RECON 120,000 3002857 BROADBAND ACC UNIV ACCESS 136,000 3401654 BEE BRANCH CREEK RESTORAT 2,772,324 628,057 0 3402608 GATE REPLC FLOOD MITIGATI 806 47,583 3,500,000 3402609 FLOOD CONTROL MAINT FACIL 130,325 133,895 0 3402690 HUD RESILIENCY 439,760 (24,727) - 0 3402769 HUD RESILIENCY ENGINEER - 2,758,357 3,523,143 1,311,008 -151- Capital Improvement Projects by Department/Division CIP Number Capital Improvement Project Title FY 21 FY 18 Actual FY 19 Actual FY 20 Adopted Recomm'd Budget Expense Expense Budget 3402774 BEE BRANCH TRAIL CONNECT 3501029 STONE RETAINING WALLS 3501053 RIVERFRONT LEASEHOLD IMPR 7,667 6,291 3501425 SIDEWALK PROGRAM CITY OWN 3501465 REHAB RR TRACK 3501466 HARBOR AREA MAINTENANCE 3501549 STREET LIGHT REPLACEMENT - 0 3501630 DECORATIVE CONCRETE MAINT 25,755 0 3501727 SIDEWALK FINANCIAL ASSIST 0 3501841 FEDERAL BUILDING RENOVTN 94,984 77,896 0 3502021 N CASCADE RD RECONSTRUCT 17,076 76,133 0 3502642 CHAVENELLE TRAIL 41,611 26 0 3502855 MUSEUM WETLAND RAILING 3601039 CORRIDOR STUDY ALTERNATES 4,450,000 0 3601053 RIVERFRONT LEASEHOLD IMPR 2,389 131,524 4,200 187,500 3601549 STREET LIGHT REPLACEMENT - 14,175 12,000 3601608 DWNTWN ST LIGHT REPLACMNT 18,678 2,600 - 0 3601841 FEDERAL BUILDING RENOVTN - 23,447 102,700 446,000 3602273 CHAVENELLE TRAIL 44,793 34,431 - 0 3602421 STREET CAMERA INSTALL 12,476 3602484 LED STREETLIGHT RETROFIT 0 3602487 POD PARKING LOT 0 3602494 DT SECURITY CAMERAS 120,939 14,308 0 3602551 CHAVANELLE RD REHAB 8,443 38,032 3,700,000 3602552 WASH ST RECON 8TH TO 9TH 14,465 269,288 0 3602554 11TH ST STAIRS RECON 21,235 - 0 3602612 HEEB STREET - 300,000 3602671 DOWNTOWN STREET LIGHTS 47,622 0 3602676 DOWNTOWN SECURITY CAMERAS 10,000 0 3602677 DOWNTOWN SECURITY CAMERAS - 0 3602760 HWY 52 PHASE 4 CENTRAL - 0 3602796 CENTRAL AVE 1 TO 2 WAY 20,000 0 3602853 POD RIVERFRONT DOCK EXP - 1,050,000 3602854 ABC SUPPLY BUILD DECON 417,000 7101067 SEWER CONN ASST-LOW/MOD 0 7101289 GENERAL SANITARY SEWER RE 200,000 7101293 SAN SEWER INTERNAL MAIN 3,108 341 34,822 13,275 7101294 I&I REDUCTION PROGRAM 17,574 820 - 0 7101297 LATERAL REPL ASST.LOW INC 9,349 0 7101309 SEWER LATERAL ASSISTANCE - 0 7101320 LATERALS-I&I REDUCTION 4,600 0 7101335 SAN SEWER MANHOLE REPLACE 196,779 12,122 50,000 0 7101350 SEWER EXTENSIONS NEW DEV. 15,046 7,044 600,000 7101637 SAN SEWER LINING PROGRAM 160,132 26,993 27,500 0 7101638 STREET PROG/RELATED SANIT 0 7101797 MONROE ST SAN SEWER EXT 0 7102013 H&W SANITARY SEWER PROJ 637 0 7102406 FOX BLACKHAWK SAN SEWER 0 7102413 RELOC 30" MAIN OPW GARAGE 35,293 337,025 0 7102450 $9.4 GREEN ALLEYS 468,851 40,274 0 7102546 TRACK LN SAN SEWER CLEAN 100,000 187,790 7102547 WASH ST SAN 7TH TO 9TH 662 0 12,938 25,000 0 0 0 0 0 25,000 20,000 -152- Capital Improvement Projects by Department/Division CIP Number Capital Improvement Project Title FY 21 FY 18 Actual FY 19 Actual FY 20 Adopted Recomm'd Budget Expense Expense Budget 7102571 AUBURN & CUSTER SAN SEWER 7102606 CEDAR/TERM ASSESSMENTS 7102607 CATFISH/GRANGER LIFT IMPR 7102612 HEEB STREET 82,210 143,635 153,000 243,000 20,000 316,400 750,000 0 160,000 7102663 KERPER SANITARY 189,327 1,705,670 0 7102669 SW ART/MENARD UTLTY RELOC 0 7102670 SW ART/HWY 20 UTLTY RELOC 0 7102720 30TH & JACKSON SAN SEWER 7,346 120,399 0 7102721 MARQUETTE SAN SEWER 23,526 252,375 0 7102728 COATES SANITARY SEWER 15,947 0 7102729 DERBY GRANGE ANNEXATION 517,296 0 7102754 TWIN RIDGE LIFT STABANDO 122,774 0 7102755 HARLAN EUCLID SANITARY 0 7102780 TIMBERHYRST SANITARY 13,808 0 7102791 ASSET MANAGEMENT 164,000 237,000 7102793 CCTV INSPECT/CLEAN/ASSESS 75,000 285,000 7102794 WOOD ST SANITARY 15,000 95,000 7102795 HEMPSTEAD SANITARY 30,000 7102812 CREEKBNK REPAIR STEGTJARK 90,029 0 7102844 CENTER PLACE ALLEY SEWER 410,000 7102846 FORCE MAIN STABILIZATION 100,000 7201008 STORM SEWER IMPR/EXTENSIO 6,490 70,000 60,000 7201066 GENERAL REPAIRS 25,054 60,966 100,000 50,000 7201081 CATCH BASIN/WESTSIDE STOR 53,000 53,000 7201085 KAUFMANN AVE STORM 0 7201086 NW ARTERIAL DETENSION BAS 11,361 0 7201123 WILBRECHT LANE STORM SERW 5,172 0 7201180 JACKSON STREET STORM SEWE - 0 7201354 DRAIN TILE PROGRAM 20,000 100,400 7201363 GUNITE ROCK STORM SEWER 0 7201365 MIDDLE ROAD CULVERT 81,739 0 7201379 SUNNYCREST/ROOSEVELT STRM - 21,000 0 7201654 BEE BRANCH CREEK RESTORAT 1,757,334 0 7201809 VILLA ST STORM SEWER PROJ 509 33,000 7201811 UNIVERSITY AV CULVERT EXT 25,000 0 7202238 CEDAR CROSS RD STORM 0 7202274 US-52 STORM IMPROVEMENTS 8,158 83,523 0 7202331 CATFISH CRK WATERSHED PRT 403,352 244,218 0 7202332 STORMWTR INFILT & INFLOW 0 14,798 100,000 50,000 7202547 WASH ST SAN 7TH TO 9TH 0 0 0 0 7202608 GATE REPLC FLOOD MITIGATI 0 0 0 1,634,418 7202609 FLOOD CONTROL MAINT FACIL 82,255 26,899 0 0 7202610 ADMIRAL SHEEHY FLOOD GATE 0 0 0 0 7202612 HEEB STREET 0 0 5,000 25,000 7202632 S GRANDVIEW (CANGENELLI) 4,172 0 0 0 7202667 AVOCA STORM IMPROVEMENTS 37,911 0 0 0 7202668 NORTHRIDGE STORM EXTENSIO 0 0 0 0 7202669 SW ART/MENARD UTLTY RELOC 0 0 0 0 7202670 SW ART/HWY 20 UTLTY RELOC 0 0 325,000 0 -153- Capital Improvement Projects by Department/Division CIP Number Capital Improvement Project Title FY 21 FY 18 Actual FY 19 Actual FY 20 Adopted Recomm'd Budget Expense Expense Budget 7202690 HUD RESILIENCY 0 0 0 7202722 WILBRICHT DETENTION BASIN 4,531 63 0 7202723 VAN BUREN STORM OUTLET 6,739 6,074 0 7202756 US 52 CENTRAL STORMWATER 0 0 0 7202757 ST ANNE DR STORM 0 0 0 7202758 HILLCREST ROSEMONT DET 0 15,369 0 7202759 MAUS PARK CULVERT 0 0 0 7202762 LANDFILL ACCESS ROAD 0 0 222,000 7202769 HUD RESILIENCY ENGINEER 0 628,735 9,899,795 7,839,922 7202813 PERV PAVE BB RR SPONSOR 0 0 0 0 7202847 CATHERINE ST STORM SEWER 0 0 0 53,000 ENGINEERIN OTAL 18,868,051 22,839,178 30,747,649 0 0 0 0 0 0 0 0 -154- PRGRM/ DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE PUBLIC WORKS SANITARY SEWER Business Type General Sanitary Sewer Extensions to New Developments $ 13,275 $ 33,866 $ 59,145 $ 174,473 $ 31,925 $ 312,684 162 Sanitary Sewer Extensions to Existing Developments $ 600,000 $ 1,200,000 $ $ $ $ 1,800,000 163 Twin Ridge Subdivision -Lagoon Abandonment $ $ 465,000 $ $ $ $ 465,000 164 Sanitary Sewer Extensions - Existing Development, Pre - annexation and Annexation Agreements $ $ 233,500 $ $ $ - $ 233,500 165 McFadden Farm Sanitary Sewer Extension $ - $ - $ 532,000 $ $ - $ 532,000 166 Sewer Utility Master Plan $ 237,000 $ 121,000 $ $ $ - $ 358,000 167 CCTV Inspection, Cleaning, and Assessment $ 285,000 $ 180,000 $ 180,000 $ 180,000 $ - $ 825,000 168 Reconstruction Southfork Interceptor Sewer $ $ $ 34,181 $ 533,819 $ $ 568,000 169 Knob Hill -Duggan Drive Sanitary Sewer Reconstruction $ $ $ 149,310 $ - $ $ 149,310 170 Brunswick Sanitary Sewer $ $ $ 9,400 $ 68,900 $ $ 78,300 171 Southgate Sanitary Sewer Reconstruction $ $ $ 13,300 $ 98,100 $ $ 111,400 172 Center Grove Sanitary Sewer Reconstruction $ $ $ 7,300 $ 60,000 $ $ 67,300 173 Wood Street Sanitary Sewer Reconstruction $ 95,000 $ $ $ $ $ 95,000 174 Auburn & Custer Sanitary Sewer Reconstruction $ 316,400 $ $ $ $ $ 316,400 175 Grove Terrace Sanitary Sewer Reconstruction $ $ 110,000 $ $ $ $ 110,000 176 Heeb Street Sanitary Sewer Reconstruction $ 160,000 $ $ $ $ $ 160,000 177 Hempstead Sanitary Sewer Reconstruction $ 30,000 $ 250,000 $ $ $ $ 280,000 178 Cooper Place and Maiden Lane Sanitary Sewer Reconstruction $ $ $ 30,000 $ 300,000 $ $ 330,000 179 Abbott & Cottage Sanitary Sewer Reconstruction $ $ $ 20,000 $ 200,000 $ $ 220,000 180 Harvard St Sanitary Sewer Reconstruction $ $ $ $ 18,000 $ 160,000 $ 178,000 181 Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $ 750,000 $ 1,416,000 $ 2,260,000 $ - $ - $ 4,426,000 182 Track Line Sanitary Cleaning and Lining $ 187,790 $ - $ $ - $ - $ 187,790 184 Force Main Stabilization $ 100,000 $ - $ $ - $7,692,308 $ 7,792,308 185 Sanitary Sewer Lining Program $ - $ 132,500 $ $ - $ 220,000 $ 352,500 186 Manhole Replacement/Rehab Program $ $ $ 50,000 $ - $ 40,000 $ 90,000 187 -155- PRGRM/ DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE Center Place Alley Sanitary Sewer Rehabilitation $ 410,000 $ - $ - $ - $ 410,000 188 Perry & Bradley Force Main and Lift Station Improvements $ - $ 35,000 $ 225,000 $ - $ - $ 260,000 189 Couler Valley Interceptor Inspection, Cleaning and Rehabilitation $ - $ - $ 85,000 $ - $ - $ 85,000 190 General Sanitary Sewer Replacement $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 200,000 $ 1,000,000 191 STORMWATER Business Type General Storm Sewer Projects Stormwater Infiltration & Inflow Elimination Program $ 50,000 $ 50,000 $ 90,000 $ 100,000 $ 100,000 $ 390,000 192 Storm Sewer General Replacements $ 50,000 $ 50,000 $ 50,000 $ 100,000 $ 204,255 $ 454,255 193 Storm Sewer Improvements/ Extensions $ 60,000 $ 60,000 $ 60,000 $ 64,946 $ 64,946 $ 309,892 194 Catch Basin Reconstruction $ 53,000 $ 53,000 $ 53,060 $ 54,122 $ 55,204 $ 268,386 195 Draintile Program $ 100,400 $ 90,810 $ 101,224 $ 100,000 $ 62,082 $ 454,516 196 Bee Branch Watershed Projects Bee Branch Creek RR Culverts $17,345,349 $ $ - $ - $ - $17,345,349 197 Bee Branch Creek Gate & Pump Replacement $ 5,134,418 $ 4,769,592 $ - $ - $ - $ 9,904,010 199 Flood Control Maintenance Facility $ $ $ - $ 220,000 $ - $ 220,000 200 Specific Storm Sewer Projects University Ave Storm Sewer $ $ $ 150,000 $ $ $ 150,000 201 Heeb Street Storm Sewer (Street Program) $ 25,000 $ - $ $ $ $ 25,000 202 Keokuk Storm Sewer Extension $ - $ 44,600 $ $ $ $ 44,600 203 Copper Field Storm Sewer Extension Project $ $ 34,700 $ $ $ $ 34,700 204 Key Way Drive Outfall Project $ $ 30,100 $ $ $ $ 30,100 205 Pennsylvania Culvert Replacement $ $ $ $ $ 25,000 $ 25,000 206 Windsor Street Storm Sewer Extension $ $ $ $ 80,500 $ $ 80,500 207 Seippel Road Culvert Replacement $ $ 8,000 $ 48,000 $ $ $ 56,000 208 Catherine Street Storm Sewer Improvements $ 53,000 $ $ $ $ $ 53,000 209 Villa Street Storm Sewer Replacement $ 33,000 $ $ $ $ $ 33,000 210 Northridge Dr Storm Sewer Extension $ $ $ $ $ 133,200 $ 133,200 211 STREETS Public Works Street Related Improvements Pavement Marking Project $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 135,000 $ 675,000 212 Street Construction General Repairs $ 100,000 $ 100,000 $ 110,000 $ 110,000 $ 100,000 $ 520,000 213 Pavement Preservation Program $ 48,000 $ - $ - $ - $ - $ 48,000 214 -156- PRGRM/ DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE East - West Corridor Capacity Improvements Chavenelle Rd Reconstruction Heeb Street Reconstruction Southwest Arterial Project Southwest Arterial ITS Corridor Development Westside Drive Street Lights 7th Street Extension to Pine Street North Cascade Road Reconstruction Cedar Cross Rd Reconstruction Seippel Road Reconstruction Pavement Rehabilitation - Concrete Street Repair, Mill and Asphalt Resurfacing $ 520,000 $ Northwest Arterial Eastbound Dedicated Left Turn lane onto John F Kennedy (JFK) Road $ 180,000 Pavement Preservation Joint Sealing $ 50,000 Rockdale Road Reconstruction $ Sidewalk Related Sidewalk Inspection Program - Assessable $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 234 Sidewalk Program - City -Owned Property $ 170,000 $ 100,000 $ 100,000 $ 50,000 $ 50,000 $ 470,000 235 ADA Curb Ramp Construction $ - $ 12,600 $ 12,600 $ 12,600 $ 12,600 $ 50,400 236 Sidewalk Program Related Curb and Catch Basin Replacements $ 25,000 $ 25,000 $ 30,000 $ 32,000 $ 35,000 $ 147,000 237 Decorative Concrete Maintenance Program $ $ Trails/General Maintenance Stone Retaining Walls Bridge Repairs/Maintenance Villa Street Retaining Wall Lowell Street Retaining Wall Brick Paver Maintenance Complete Streets Elements MISCELLANEOUS General Government Federal Building Renovation $ 446,000 $ 346,800 $ 286,000 $ 36,500 $ - $ 1,115,300 245 $ $ 3,700,000 300,000 550,000 850,000 $ 150,000 $ 4,600,000 $ $ $ 4,750,000 216 $ - $ - $ $ $ 3,700,000 218 $ $ $ $ $ 300,000 220 $ $ $ $ $ 550,000 221 $ 850,000 $ $ $ $ 1,700,000 223 $ $ 150,000 $ $ $ 150,000 224 $ $ $ 191,500 $ 650,000 $ 841,500 225 $ 1,497,200 $ $ $ - $ $ - $ $ 1,600,000 $ $ - $ $ 30,000 $ $ - $ 50,000 100,000 $ 100,000 $ - $ 141,500 $ - $ - $ Community and Economic Development Public Works Riverfront Dock Expansion $ 1,050,000 $ 1,050,000 $ Neighborhood Related Improvement $ Riverfront Leasehold Improvements $ 187,500 $ 55,000 $ 35,000 $ 40,000 $ 75,000 238 105,000 $ 100,000 $ - $ - $ 30,000 $ 12,000 $ - $ - $ 10,000 $ 10,000 $ 73,500 $ - $ $ $ 1,497,200 $ 400,000 $ 400,000 $ 280,000 $ 280,000 226 228 229 $ 520,000 230 $ 180,000 231 55,000 $ - $ 210,000 232 $ 200,000 $ 200,000 233 110,000 $ - $ 315,000 239 100,000 $ - $ 300,000 240 - $ - $ 1,600,000 241 - $ - $ 141,500 242 - $ 30,000 $ 90,000 243 12,000 $ 10,000 $ 34,000 244 - $ - $ 2,100,000 247 10,000 $ 10,000 $ 40,000 249 - $ - $ 261,000 250 -157- PRGRM/ DEPT PROJECT DESCRIPTION FY 2021 FY 2022 FY 2023 FY 2024 FY 2025 TOTAL PAGE ABC Supply Building Deconstruction $ 417,000 $ $ $ $ $ 417,000 251 Port of Dubuque - Security Cameras $ - $ 20,000 $ - $ 20,000 $ - $ 40,000 252 Harbor Area Maintenance $ 25,000 $ $ 30,000 $ $ 35,000 $ 90,000 253 Ice Harbor Road - Museum Wetland Railing $ 20,000 $ $ $ $ $ 20,000 254 Third Street Overpass Railing Painting $ 120,000 $ - $ - $ - $ $ 120,000 255 Speed Shields $ - $ 46,000 $ 46,000 $ 46,000 $ $ 138,000 256 TRAFFIC Public Works Street Light Replacement and New Installation $ 32,000 $ 128,200 $ 145,200 $ 180,000 $ 35,000 $ 520,400 257 Signalization Program $ 70,000 $ 70,000 $ 80,000 $ 70,000 $ 60,000 $ 350,000 258 Traffic Signal Mastarm Retrofit $ 65,000 $ 70,000 $ 75,000 $ 80,000 $ 65,000 $ 355,000 259 Traffic Signal Interconnect Conduit Replacement $ 30,000 $ 40,000 $ 70,000 $ 40,000 $ 40,000 $ 220,000 260 Traffic Signal Controller Replacement $ 35,000 $ 35,000 $ 45,000 $ 45,000 $ 35,000 $ 195,000 261 Street Lighting and Traffic Signal Knockdown/Insurance $ 25,000 $ 25,000 $ 30,000 $ 30,000 $ 25,000 $ 135,000 262 Street Camera Installation $ 82,476 $ 105,775 $ 89,798 $ 105,000 $ 15,000 $ 398,049 263 LED Re -lamp schedule $ $ 25,000 $ 30,000 $ 25,000 $ 20,000 $ 100,000 264 Traffic Signal Battery Backup Program $ 10,000 $ 15,000 $ 20,000 $ 20,000 $ 20,000 $ 85,000 265 Traffic Signal Intersection Reconstruction $ 40,000 $ 50,000 $ 75,000 $ 72,472 $ 65,000 $ 302,472 266 Surge and Grounding Improvements at Signals City - Wide $ 10,000 $ 15,000 $ 20,000 $ 20,000 $ 20,000 $ 85,000 267 STREETS Traffic Control Project $ 3,466,250 $ 75,000 $ 50,000 $ $ $ 3,591,250 268 Traffic Signal Fiber Optics $ 65,000 $ 65,000 $ 100,000 $ 100,000 $ $ 330,000 269 ITS Traffic Control Equipment $ 20,000 $ 20,000 $ 25,000 $ 34,000 $ 25,000 $ 124,000 270 Traffic Signal Vehicle Detection Conversion $ 50,000 $ 50,000 $ 60,000 $ 64,000 $ 40,000 $ 264,000 271 Grandview Street Light Replacement $ 35,000 $ - $ 50,000 $ 100,000 $ $ 185,000 272 INET Replacement Build Out $ 90,000 $ 90,000 $ 150,000 $ 65,000 $ $ 395,000 273 Emergency Preemption Expansion and Upgrades $ 15,000 $ 15,000 $ 15,000 $ 20,000 $ 20,000 $ 85,000 274 Asbury Rd Signalization Reconstruction $ 120,000 $ $ $ $ $ 120,000 275 Fiber Optic Conduit - Miscellaneous $ 40,000 $ 40,000 $ 50,000 $ 50,000 $ 40,000 $ 220,000 276 Fiber Infrastructure Management System $ - $ 100,000 $ 10,000 $ 10,000 $ 10,000 $ 130,000 277 Broadband Acceleration and Universal Access $ 136,000 $ 130,000 $ 125,000 $ 120,000 $ $ 511,000 278 TOTAL 41,278,858 15,569,243 11,563,518 4,788,932 11,541,520 84,742,071 -158- FISCAL YEAR 2021 BUDGET PRESENTATION ENGINEERING DEPARTMENT .41 Photo: Millwork District Complete Streets FY 21 Budget Request Changes Due to COVID-19 Pandemic • The following presentation represents Engineering's FY21 budget requests prior to the COVID-19 pandemic. • In light of the pandemic, the City Manager will present an amended FY21 Budget Recommendation on April 23, 2020: This recommendation will include no property tax increase for the average homeowner and no increase in the stormwater, sanitary sewer, water, and refuse fees. The amended recommendation will impact the following budget request and may reduce or delay funding for some projects Presentation Outline 1.Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5.Traffic 6. Miscellaneous Gus Psihoyos Presentation Outline 1. Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5. Traffic 6. Miscellaneous Deron Muehring Steve Sampson -Brown Presentation Outline 1. Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5.Traffic 6. Miscellaneous Deron Muehring Presentation Outline 1. Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5.Traffic 6. Miscellaneous Bob Schiesl Jon Dienst Presentation Outline 1. Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5.Traffic 6. Miscellaneous Dave Ness Presentation Outline 1. Department Overview 2.Sanitary Sewer Collection System 3.Stormwater Management 4. Streets 5.Traffic 6.Miscellaneous Bob Schiesl Steve Sampson -Brown Engineering Department MISSION STATEMENT To promote public safety for City of Dubuque residents and businesses by providing engineering services by competent staff related to the planning, development, construction, and maintenance of the City's public infrastructure systems. Engineerina Department Leadership City Engineer Assistant Engineer Secretary Confidential Account Clerk Right -of -Way Management Streets (30.71 Full -Time Eauivalents) Project Manager Confidential Account Clerk Traffic Engineering Organization (30.71 Full -Time Equivalents) Right -of -Way Management Streets Engineering Assistant II Engineering Technician Interns (1.5) Immo Civil Engineer 11 Civil Engineer I Engineering Technician (6) Surveyor Survey Crew Chief Survey Technician 1 Traffic Engineering Civil Engineer II Engineering Technician (2) 1&I Inspector PT (1.48) Utility Locator Engineering Assistant II Confidential Account Clerk Civil Engineer II Traffic Engineer (2) Utility Locator City Council Priorities Touched by the Engineering Department • • • Policy Agenda Top Priorities: 3 of 6 priorities • Policy Agenda High Priorities: 1 of 6 priorities • Management Agenda Top Priorities: 3 of 8 priorities • Management Agenda High Priorities: 3 of 6 priorities City Council Goal Areas Touched by the Engineering Department • Robust Local Economy: • Vibrant Community: • Livable Neighborhoods and Housing: • High Performance Government: • Sustainable Environment: • Partnership for a Better Dubuque: • Diverse Arts, Culture, Parks and Recreation: • Connected Community: 3 of 10 areas 4 of 21 areas 2 of 5 areas 4 of 21 areas 10 of 24 areas 1 of 7 areas 3 of 13 areas 14 of 20 areas PRIOR YEAR HIGHLIGHTS • Completion of Southwest Arterial Interchange at US 61 / 151, Opened to Traffic • 4-Lane Paving began on the Southwest Arterial • Bee Branch Railroad Culvert Project under the CP Rail Yard began (Expected to be complete in 2021) • Completion of Kerper Blvd. Sanitary Sewer Forcemain PRIOR YEAR HIGHLIGHTS (Continued) ■■ • Completion of HUD Resiliency Projects on 17th Street (Elm to Heeb) and 22nd Street/Kaufmann Avenue (Elm to Main) • Marquette Place Sanitary Sewer and Water main Project Completion FUTURE INITIATIVES • Completion of the Southwest Arterial Project - July 2020. • Completion of the Bee Branch Railroad Culverts Project • Finish the Storm Sewer Improvements on 17th/W. Locust and Kaufmann Avenue • Reconstruction of North Cascade Road • Reconstruction of Chavenelle Road and completion of Chavenelle Trail FUTURE INITIATIVES (Continued) • Complete Preliminary Design and Environmental Phase for the Advancement of the East-West Corridor Capacity Improvements • Complete the improvements related to the STREETS Project • Improve the Right of Way permitting process for all customers FY2021 RECOMMENDED IMPROVEMENT REQUESTS 1. Upgrade Engineering Technician (GE-31) to Environmental Engineer (GE-38) Recurring I $19,731 - Stormwater Utility $46,736 - Sanitary Sewer Funds 2. Camera Systems Technician (GE-286) Recurring I $76,749 Net Property Tax Cost: 0.17% 3. Funding to Maintain and Rehabilitate Ditches in the Public Right of Way Recurring I $10,000 Net Property Tax Cost: 0.21 % Stormwater Fee Increase 4. Iowa Stormwater Education Partnership Recurring I $5,250 Net Property Tax Cost: 0.11 % Stormwater Fee Increase 5. Automatic Vehicle Monitoring Non -Recurring I $8,500 Recurring I $2,040 FY2021 RECOMMENDED IMPROVEMENT REQUESTS 6. Assistance for Low to Moderate Income Individuals for Clearing Sidewalks Recurring I $5,000 Net Property Tax Cost: 0.02% Increase 7. Fire Extinguisher in all vehicles Non -Recurring I $1,020 Recurring I $170 8.Fiber Infrastructure Management Software Non -Recurring I $30,240 Recurring 1 $5,600 Net Property Tax Cost: 0.14% Engineering Department FY2021 REQUESTED PROPERTY TAX SUPPORT $949,238 Net Property Tax Support tau $9.62 Average homeowner's* property tax cost for City Engineering (*Avg. home value of $146,567) Engineering Department FY2021 REVENUE SOURCES REVENUE SOURCES $109,716.00 All $951,438.00 702,317.00 $251,566.00 • ADMIN OVERHEAD RECHARGE SANITARY SEWER FEES • PROPERTY TAX • LEASE REIMBURSEMENT $110,614.00 $23,539.00 $399,221.00 $2,775,619.00 1 • STORMWATER FEES • ROAD USE TAX OPERATING REVENUE • UTILITY CHARGES - PARKING & WATER IN DEP TMENT SANITARY SEWER COLLECTION SYSTEM FISCAL YEAR 2021 BUDGET PRESENTATION CONSENT DECREE COMPLIANCE PROGRAM OUTCOME: Comply with the 2011 Consent Decree among the Iowa Department of Natural Resources and the US Environmental Protection Agency. The goal of the consent decree is to ensure that the City's sanitary sewer collection system complies with the Federal Clean Water Act by eliminating all Sanitary Sewer Overflows. CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? 1. Clogged sewer pipes Fats, Oils, & Grease CONSENT DECREE COMPLIANCE PROGRAM ■ ■ What causes sanitary sewer overflows (SSOs)? Food Establishment Public Sanitary Sewer System CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? Food Establishment Public Sanitary Sewer System CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? Food Establishment Public Sanitary Sewer System CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? Storm Sewer System Food Establishment Public Sanitary Sewer System CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? Storm Sewer System • SI O a o p Q y o A O° o p e l(l{' O o Food Establishment Public Sanitary Sewer System CONSENT DECREE COMPLIANCE PROGRAM What causes sanitary sewer overflows (SSOs)? 2. Infiltration & Inflow (I&I) IL . '_ INFILTRATION - INFLOW CONSENT DECREE COMPLIANCE PROGRAM 5 "Sewersheds" FY12 thru FY16 Source Investigations - Sewer inspections - Flow metering - Smoke testing - Home inspections FY13 thru FY28 Corrective Action Plan - Public System - Private Systems CONSENT DECREE COMPLIANCE PROGRAM PRIOR YEAR HIGHLIGHTS • Marquette Sanitary Sewer Reconstruction Project • Harlan & Euclid Sanitary Sewer Reconstruction Project CONSENT DECREE COMPLIANCE PROGRAM FY 21 CAPITAL IMPROVEMENT PROJECTS Wood Street Sanitary Sewer Reconstruction Auburn & Custer Sanitary Sewer Reconstruction FY 21 - roject Cost Total Project Cost $95,000 $316,400 $105,000 $316,400 CONSENT DECREE COMPLIANCE PROGRAM FY 21 - FY 25 CAPITAL IMPROVEMENT PROJECTS Project Cost Grove Terrace Sanitary Sewer Reconstruction $110,000 22 Cooper Place & Maiden Lane Sewer Reconstruction $330,000 23 & 24 Harvard Street Sanitary Sewer Reconstruction $178,000 24 & 25 PRIOR YEAR HIGHLIGHTS Kerper Boulevard Sanitary Sewer Improvements REVOLVING FUND Gravity Main — — — — Lift Station Force Main FUTURE INITIATIVES Sewer Utility Asset Management Plan As we work to provide a system that meets the needs of the community, things we must consider... 1. Condition of the sanitary sewer collection system • Excessive I&I leads to Sanitary Sewer Overflows (SSOs) and increased treatment costs at the W&RRC • Pipe failure can result in sinkholes and lost service • Related to increased maintenance costs FUTURE INITIATIVES Sewer Utility Asset Management Plan The City has Closed Circuit Television (CCTV) records and condition assessments of 60% of the gravity sewer system. The Sanitary Sewer CCTV Inspection, Cleaning, & Assessment Project provides for the systematic CCTV inspection, cleaning, and condition assessment of the remaining 40% within a 10-year period. 2020 2021 2022 2023 2024 2025 $75,000 $285,000 $180,000 $180,000 $180,000 $180,000 FUTURE INITIATIVES Sewer Utility Asset Management Plan As we work to provide a system that meets the needs of the community, things we must consider... 2. Capacity of the sanitary sewer collection system • Insufficient capacity can also lead to SSOs • Insufficient capacity can result in higher maintenance costs • Insufficient capacity can stunt the healthy growth of the customer base FUTURE INITIATIVES Sewer Utility Asset Management Plan The Sewer Utility Asset Management Plan Project will provide: • A collection system computer model that the City can use to assess the capacity of the system so that the impact of proposed changes and improvements can be fully understood; • Maintenance recommendations; and • Recommended replacement and improvement schedules. 2020 2021 2022 164,000 $237,000 $121,000 FUTURE INITIATIVES Sewer Utility Asset Management Plan Likelihood of Failure RISK of Failure Rehabilitation Options ■ Prioritized CIP Projects Consequence of Failure FUTURE INITIATIVES Sewer Utility Asset Management Plan Likelihood of Failure Capacity Improvements RISK of Failure Rehabilitation Options ■ Prioritized CIP Projects Consequence of Failure FUTURE INITIATIVES Sewer Utility Asset Management Plan Likelihood of Failure Capacity Improvements RISK of Failure Rehabilitation Options ■ Prioritized CIP 1 Projects Consequence of Failure Accommodate Growth of Community FY 2021 CIP PROJECTS ■r Project Sanitary Sewer Extensions to New Developments Sanitary Sewer Extensions to Existing Developments FY 21 Project Cost Total Project Cost Sewer Utility Master Plan CCTV Inspection, Cleaning, and Assessment Wood Street Sanitary Sewer Reconstruction Auburn & Custer Sanitary Sewer Reconstruction Heeb Street Sanitary Sewer Reconstruction $13,275 $600,000 $237,000 $285,000 $95,000 $312,684 $1,800,000 $358,000 $825,000 $95,000 $316,400 $316,400 $160,000 $160,000 Hempstead Sanitary Sewer Reconstruction Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $30,000 $280,000 $750,000 $4,426,000 Track Line Sanitary Cleaning and Lining $187,790 $187,790 Force Main Stabilization $100,000 $7,792,308 Center Place Alley Sanitary Sewer Rehabilitation General Sanitary Sewer Replacement $410,000 $410,000 $200,000 $1,000,000 FY 2021 CIP PROJECTS ■r Project Sanitary Sewer Extensions to New Developments Sanitary Sewer Extensions to Existing Developments FY 21 Project Cost Total Project Cost Sewer Utility Master Plan CCTV Inspection, Cleaning, and Assessment Wood Street Sanitary Sewer Reconstruction Auburn & Custer Sanitary Sewer Reconstruction Heeb Street Sanitary Sewer Reconstruction $13,275 $600,000 $237,000 $285,000 $95,000 $312,684 $1,800,000 $358,000 $825,000 $95,000 $316,400 $316,400 $160,000 $160,000 Hempstead Sanitary Sewer Reconstruction Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $30,000 $280,000 $750,000 $4,426,000 Track Line Sanitary Cleaning and Lining $187,790 $187,790 Force Main Stabilization $100,000 $7,792,308 Center Place Alley Sanitary Sewer Rehabilitation $410,000 $410,000 General Sanitary Sewer Replacement $200,000 $1,000,000 CURRENT INITIATIVES 42-inch Force Main Assessment and Internal Pipe Inspection FY 2021 CIP PROJECTS • • 42-inch Force Main Stabilization CONTINUING AUTHORITIES PROGRAM • �.� Section 14— Emergency Stream Bank & Shoreline Protection U.S. 41iY CORPS OF ENGINEERS sa FY 2021 CIP PROJECTS 42-inch Force Main Stabilization • COHTINUIHGAUTHI Section 14— Emergency Stream Bank & S U.S. ARIQIY CORPS OF ENGINEERS FY 2021 CIP PROJECTS • 42-inch Force Main Stabilization j _ . COHTINUIHCAUTHI Section 14— Emergency Stream Bank & S U.S. ARI YY CORPS OF ENGINEERS 101 FY2021 RECOMMENDED IMPROVEMENT REQUESTS 1. Upgrade Engineering Technician (GE-31) to Civil Engineer (GE-38) AND... Increase Funding for 28E Agreement with Dubuque County and the Dubuque Soil & Water Conservation District Recurring I $19,731 - Stormwater Utility $46,736 - Sanitary Sewer Funds Civil Engineer Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Civil Engineer NPDES MS4 Permit Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement ng. Tech Vacant LEI NPDES MS4 Permit NPDES MS4 Permit Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement 1 NPDES MS4 Permit NPDES MS4 Permit Sanitary Asset Management Consent Decree Coordination Sanitary CIP Projects Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement 1 i_ Civil Engineer NPDES MS4 Permit Sanitary Asset Management Consent Decree Coordination Sanitary CIP Projects Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement i_ Civil Engineer NPDES MS4 Permit Sanitary Asset Management Consent Decree Coordination Sanitary CIP Projects Dubuque Soil & Water Conservation District (DSWCD) Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement NPDES MS4 Permit u_ Civil Engineer NPDES MS4 Permit Sanitary Asset Management Consent Decree Coordination Sanitary CIP Projects NPDES MS4 Permit Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement NPDES MS4 Permit u_ Civil Engineer NPDES MS4 Permit Sanitary Asset Management Consent Decree Coordination Sanitary CIP Projects NPDES MS4 Permit Nutrient Reduction Coordination Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Stormwater Admin Stormwater Projects Sanitary Admin Sanitary Projects <$74,300> <$13,100> Civil Engineer $41,500 $15,600 $5,300 $41,500 Net Change <$32,800> $2,500 $5,300 $41,500 Totals <$87,400> $103,900 *Dubuque Soil & Water Conservation District $16,500 Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Stormwater Admin Stormwater Projects Sanitary Admin Sanitary Projects <$74,300> <$13,100> Civil Engineer $41,500 $15,600 $5,300 $41,500 $50,000 Net Change $17,200 $2,500 $5,300 $41,500 Totals <$87,400> $103,900 $50,000 *Dubuque Soil & Water Conservation District $66,500 Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Sanitary Asset Management Consent Decree Coordination WI Nutrient Reduction Coordination Sanitary CIP Projects Net Change $66,500 Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Sanitary Asset Management Consent Decree Coordination Nutrient Reduction Coordination Sanitary CIP Projects Net Change $66,500 Upgrade Engineering Technician to Civil Engineer & Expanding 28e Agreement Nutrient Reduction Goals 75% reduction in Phosphorus 66% reduction in Nitrogen Accomplished by: • $10.8 million in improvements at the W&RRC OR • A combination of watershed practices and improvements at the W&RRC Catfish Creek Watershed Partnership (28e Agreement) Recognizing that watershed boundaries do not coincide with jurisdictional boundaries, the City has partnered with Dubuque County and the Dubuque Soil & Water Conservation District (District) through a 28e Agreement. Through the 28e Agreement, the City has helped fund an Urban Conservationist to work address flooding and nutrient reduction concerns. Catfish Creek Watershed Partnership (28e Agreement) Accomplishments to Date: 1. Creation of the Catfish Creek Watershed Management Authority; 2. Creation/ adoption of the Catfish Creek Watershed Management Plan; Catfish Creek Watershed Partnership (28e Agreement) Accomplishments to Date: 1. Creation of the Catfish Creek Watershed Management Authority; 2. Creation/ adoption of the Catfish Creek Watershed Management Plan; 3. Secured $1.4 million in SRF sponsorship funding for watershed improvements; 4. Secured $337,000 in USDA funding to develop a farm -scale model for the entire county and start engaging with farmers regarding conversation practices. Catfish Creek Watershed Partnership (28e Agreement) Accomplishments to Date: 1. Creation of the Catfish Creek Watershed Management Authority; 2. Creation/ adoption of the Catfish Creek Watershed Management Plan; 3. Secured $1.4 million in SRF sponsorship funding for watershed improvements; 4. Secured $337,000 in USDA funding to develop a farm -scale model for the entire county and start engaging with farmers regarding conversation practices. Farm -scale Model: Identify most cost-effective projects, saving taxpayer's and farmer's dollars. Agricultural Conservation Planning Framework (ACPF) Feasible conservation practices • Finland a., - rsi.en�,r wdr.rl'§6l C -wee Zve1�1 ACPF Pme le. Type - Ai. nerd Yp.l sn 01, -&w,w-aiQai _w,C r, �wR✓! � ..� ! Sewn NO9uCgM[.1171 -av�bw H1 - E&m Swnn.d Oxma.. W, gyp. n Y.a.en! MP1a, - a«. le•e,.., {a0i, - %_, _ Sodas. Carre.. 041 Farm -scale Model: Identify most cost-effective projects, saving taxpayer's and farmer's dollars. Agricultural Conservation Planning Framework (ACPF) Feasible conservation practices PTMapp - "Best" practices to meet local water quality goals Throated ACPF Preen. Locations 0 0.5 1 2 Miles Plan Region Outlet - 6ioleaolot (47) - Centaur Buller Strip (149) ▪ Popresshns (9) - Crl9wl Zone (I) - Deep Rooted Vegslallon la) - Muni Species Buffer (1) Stream Pena Stealeadon (DI ▪ ara,nage Management (25) - s1l9stemmed Grasser (a) - Gress Waaterway(44) Saturated Buller (4) ▪ Nolrenl Removal Wetlands (29) - Water and Sediment Control Darin (44) Catfish Creek Watershed Partnership (28e Agreement) Accomplishments to Date: 1. Creation of the Catfish Creek Watershed Management Authority; 2. Creation/ adoption of the Catfish Creek Watershed Management Plan; 3. Secured $1.4 million in SRF sponsorship funding for watershed improvements; 4. Secured $337,000 in USDA funding to develop a farm -scale model for the entire county and start engaging with farmers regarding conversation practices. 5. Execution of an MOU with the Iowa Department of Natural Resources regarding the W&RRC nutrient reduction strategy Catfish Creek Watershed Partnership (28e Agreement) The Next Step: Expand the agreement in order to... 1. Facilitate the implementation of watershed improvements throughout Dubuque County; 2. Facilitate the collaboration between all stakeholders (i.e. City, County, USDA NRCS, IDALS, and farmers); 3. Achieve targeted landowner engagement; 4. Identification and application for grants to offset the cost of watershed improvements; AND 5. Administration of the Nutrient Reduction Exchange, Nutrient Tracking Tool, and the State's RIBITS. Catfish Creek Watershed Partnership (28e Agreement) The Next Step: Expand the agreement in order to... 1. Facilitate the implementation of watershed improvements throughout Dubuque County; 2. Facilitate the collaboration between all stakeholders (i.e. City, County, USDA NRCS, IDALS, and farmers); 3. Achieve targeted landowner engagement; 4. Identification and application for grants to offset the cost of watershed improvements; AND 5. Administration of the Nutrient Reduction Exchange, Nutrient Tracking Tool, and the State's online water quality trading tool (RIBITS). STORMWATER MANAGEMENT SYSTEM FISCAL YEAR 2021 BUDGET PRESENTATION DUBUQUE'S MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) k Since 2003, the City has been subject to a National Discharge Elimination System (NPDES) MS4 Permit as required by the federal Clean Water Act. - The Engineering Department oversees the NPDES MS4 Permit compliance program, the goal of which is to prevent stormwater from collecting and transporting urban pollutants and delivering them into waters of the United States. Petroleum byproducts in the street Sediment in the creek FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) CONSTRUCTION SITE RUNOFF CONTROLS Construction Site Inspections (January 1, 2019 to January 1, 2020) Inspections: 167 (63 active sites) Compliant: 97% Non -Compliant: 3% FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) MS4 PERMIT COMPLIANCE INSPECTION According to the Iowa Department of Natural Resources, the consistency the City holds from year to year is impressive. They do not have any recommendations for improving the City's compliance program. FEDERAL CLEAN WATER ACT COMPLIANCE PROGRAM (NPDES MS4 PERMIT) POST -CONSTRUCTION RUNOFF CONTROLS WATER QUALITY & QUANTITY COMPONENTS Development Plans Reviewed: 24 ALTA VISTA ALTERNATIVE LEARNING CENTER ADDITION/RENOVATION 1090 ALTA VISTA STREET DUBUQUE, IOW'A CRAIXNG PUN at INITIAL STORM WATER Pg1UTION PREVENTION PLAN SWIM POINTE OVIEKIOVL :3 s.+vve =ter_• :: 1W-4117- c o: DUBUQUE'S MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) In Iowa, every property owner is responsible for managing stormwater, accepting runoff from upstream properties and discharging it to downstream properties. — Engineering Department helps design, construct, and maintain minor and major public drainage facilities to manage stormwater on public property (i.e. street right-of-way). Hillcrest-Rosemont Detention Basin Flood -Prone Area rr PRIOR YEAR HIGHLIGHTS ■■ Hillcrest-Rosemont Detention Basin Ponding Area Embankment • J - PRIOR YEAR HIGHLIGHTS • '.O I r '19iillaest Rag 1. .s. Hillcrest-Rosemont Detention Basin PRIOR YES.. HIGHLIGHTS CURRENT INITIATIVES Wilbricht Lane Detention Basin CURRENT INITIATIVES Wilbricht Lane Detention Basin CURRENT INITIATIVES Wilbricht Lane Detention Basin BENEFITS: Homes on Glendale Ct. (Problem Area 1) Homes on Marmora Ave. (Problem Area 2) Homes on McPoland Ave. (Problem Area 3) PENNSYLVANIA AVE PROBLEM AREA 2 PROBLEM AREA 3 MINOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS FY 21 CAPITAL IMPROVEMENT PROJECTS Project roject Cost Total Project Cost Stormwater Infiltration & Inflow Elimination Program $ $ $ Storm Sewer General Replacements Storm Sewer Improvements/Extensions Catch Basin Reconstruction Draintile Program Heeb Street Storm Sewer (Street Program) Catherine Street Storm Sewer Improvements Villa Street Storm Sewer Replacement $ $ $ $ $ 13,275 $ 600,000 $ 237,000 $ 285,000 $ 95,000 $ 25,000 $ 53,000 $ 33,000 $ 390,000 454,255 309,892 268,386 454,516 25,000 53,000 33,000 MINOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS DRAIN TILE PROGRAM Many homes in Dubuque utilize sump pumps and drain tiles to prevent groundwater from damaging the basement. That water CANNOT go to the sanitary sewer. It is generally directed into the street which serves as part of the public stormwater drainage system. MINOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS DRAIN TILE PROGRAM While designed to carry water, in some instances the constant flow can result in hazardous, slick street surfaces. MINOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS DRAIN TILE PROGRAM While designed to carry water, in some instances the constant flow can result in hazardous, slick street surfaces. MINOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS DRAIN TILE PROGRAM While designed to carry water, in some instances the constant flow can result in hazardous, slick street surfaces. Increased annual funding from $20,000 to $100,000 each year in the 5-year plan DUBUQUE'S MUNICIPAL SEPARATE STORM SEWER SYSTEM (MS4) MAJOR STORMWATER MANAGEMENT SYSTEMS CITIZEN IMPACT: While most homeowners can install gutters and downspouts and install landscaping that forces water to flow away from their house, sometimes they are powerless to protect their home from flooding. Infrastructure Improvement Carter Road Detention Basin West 32nd Street Detention Basin Historic Millwork District Complete Streets Lower Bee Branch Creek Restoration Upper Bee Branch Creek Restoration Bee Branch Creek Railroad Culverts 22nd Street/Kaufmann Storm Sewer Capacity Improvements 17th Street/W. Locust Storm Sewer Capacity Improvements Flood Mitigation Gate & Pump Replacement Flood Mitigation Maintenance Facility North End Storm Sewer Capacity Improvements Water Plant Flood Protection Impervious Surface Reduction (Green Alleys) e Bra,, e1164110 watershed *Additional phases to follow FLOOD MITIGATION PROJECT Schedule Complete (2003) Complete (2009) Complete (2012) Complete (2011) Complete — (2017) Est. Completion Est. Completion Est. Completion Est. Completion Est. Completion Est. Completion Est. Completion Est. Completion — 2021 — 2021 x — 2021 X — 2022 — 2028 — 2029 — 2031 — 2040 PRIOR ACCOMPLISHMENTS 17th Street Storm Sewer Improvements Phase I: Completed in 2018 Phase II: Completed in 2019 c r- 4S rr • r • C • 9 .ON • 1. e crC 1.; _tjapidtbo: Vctfiffet rttitIl • ,of (le • r 'If, CURRENT INITIATIVES 17th Street Storm Sewer Improvements Phase I: Completed in 2018 Phase II: Completed in 2019 Phase III: Under Design (Completion in 2020) CURRENT INITIATIVES 17th Street Storm Sewer Improvements Phase I: Completed in 2018 Phase II: Completed in 2019 Phase III: Under Design (Completion in 2020) Future Phases: Schedule Depends on Funding 11 • • G ark; r r • �r �" y ;r:',� '' . $ ' Y t I ,_1 _41-T?t ti• t�^iill r • ti c '� '►(10 watershed PRIOR ACCOMPLISHMENTS 22nd St./Kaufmann Ave. Storm Sewer Improvements Phase 1: Completed in 2018 4ee Brape6 watershed FL000 MITIGATION PROJECT „Ifs CZ)Q. HH a 1 CURRENT INITIATIVES 22nd St./Kaufmann Ave. Storm Sewer Im • rovements Phase I: Completed in 2018 Phase II: Under Construction (Completion in early 2020) CURRENT INITIATIVES 22nd St./Kaufmann Ave. Storm Sewer Improvements Phase 1: Completed in 2018 Phase 11: Under Construction (Completion in early 2020) Phase 111: Under Design (Completion by early 2021) FUTURE INITIATIVES 22nd St./Kaufmann Ave. Storm Sewer Improvements Phase I: Completed in 2018 Phase II: Under Construction (Completion in early 2020) Phase III: Under Design (Completion by early 2021) Future Phases: Schedule Depends on Funding FLOOD MITIGATION PROJECT CURRENT INITIATIVES BEE BRANCH FLOOD MITIGATION MAINTENANCE FACILITY WEST BLUM SITE - EPA CLEANUP GRANT fee Bra,, lie 4 watershed FLOOD MITIGATION PROJECT $600,000 EPA Brownfield Cleanup Grant Funding CURRENT INITIATIVES BEE BRANCH FLOOD MITIGATION MAINTENANCE FACILITY WEST BLUM SITE - EPA CLEANUP GRANT fee Bra,, lie 4 watershed FLOOD MITIGATION PROJECT PRIOR YEAR ACCOMPLISHMENTS BEE BRANCH FLOOD MITIGATION MAINTENANCE FACIII_ITY EAST BLUM SITE - EPA CLEANUP GRANT Federal Grant = $92,300 City Cost = $126,900 IDNR NFA Certificate Issued CURRENT INITIATIVES BEE BRANCH FLOOD MITIGATION MAINTENANCE FACILITY WEST BLUM SITE - EPA CLEANUP GRANT fee Bra,, diNite 9 watershed FLOOD MITIGATION PROJECT CURRENT INITIATIVES BEE BRANCH FLOOD MITIGATION MAINTENANCE FACT WEST BLUM SITE - EPA CLEANUP GRANT fee Bra,, Me 4 watershed FLOOD MITIGATION PROJECT $400,000 EPA Brownfield Cleanup Grant Funding MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS FY 21 CAPITAL IMPROVEMENT PROJECTS FY 21 Project Cost Total Project Cost* Bee Branch Creek Railroad Culverts $ 17,345,349 $ 17,345,349 Bee Branch Creek Gate & Pump Replacement $ 5,134,418 $ 9,904,010 *Does not include previous expenses MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project v watershed FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project ee Bra") <t° liefte4 watershed F LOO D MITIGATION PAOJ ECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project • ee Brfa, v watershed FL00D MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Pro'ect FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project iee Bra, v watershed FLOOD MITIGATION PROJECT Bee Branch Creek Railroad Culverts Project Progress... Box Culverts fee Bra00 watershed FLOOD MITIGATION PROJECT Bee Branch Creek Railroad Culverts Project Progress... Launch Pit fee Bra40 v watershed FLOOD MITIGATION PROJECT Bee Branch Creek Railroad Culverts Project Progress... Steel Pipe On Site FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project - Ready for Trail fee Brape.. v watershed FL00D MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project with Trail... LAND &WATER CONSERVATION le- FUND le ee Bra, watershed FLOOD MITIGATION PAOJ ECT 4 , • si• .101.1 Iv: , , , /16- . •,..+41' iki . ifri : ,r44„1 4ite 0i, Vl -,.., 4 i!„. 111111 , . . - t y, /I 01 . , . •• if / V Of r .... H. V • a ...Ill . . ...* ) . ORMIIIIIIMPEI gitWOrlawAIIIIIII, iv r v ,•,,riftvr mr: WIIMUIIIMINSF.: MP niiiiiiiiiiiiimoi, rt. , ..;•.1,2nallff,...--.2,-.A4puttg .....: .rti . 1.,11. I fillI,,tT. It -ma ' ma -- Traveling south from Garfield Avenue MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project with Trail... FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project watershed FLOOD MITIGATION PROJECT 500-Year Flood -3 feet below damage elevation MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Creek Railroad Culverts Project SOURCE AMOUNT SRF Loan2 $16,300,000 HUD CDBG National Disaster Resiliency Grant $12,876,000 State Flood Mitigation Program Sales Tax Increment $1,850,900 Stormwater Utility Fee Revenue $364,800 Land & Water Conservation Fund Grant $175,000 TOTAL $31,566,700 iee Bra, :r watershed FLOOD MITIGATION PROJECT Rounded 2Repaid using State Flood Mitigation Program Sales Tax Increment MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project ley !k.'_"5-1T,' fee Br84e6 v watershed FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project fee Bra40 v watershed FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project fee Brake v watershed FL00D MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project fee BrapeMe 4 v watershed FLOOD MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project fee Bra40 watershed FL00D MITIGATION PROJECT MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project 31_111.: 1-0 7311-17141 MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project Increase Resiliency by: - Handling the floodwaters from the Bee Branch Creek which provides 500-year protection; - Doubling the pumping capacity from-200,000 gallons per minute to-400,000; - Providing flexible gate operation to drain the basin under extreme flooding conditions; - Providing easy access to remove debris from the trash racks; and - Providing backup generators to ensure operations during storm events. MAJOR STORMWATER MANAGEMENT DRAINAGE SYSTEM IMPROVEMENTS Bee Branch Gate & Pump Replacement Project SOURCE AMOUNT State Flood Mitigation Program Sales Tax Increment $13,721,600 EDA Disaster Recovery Grant $2,500,000 Stormwater Utility Fee Revenue $869,400 TOTAL $17, 091, 000 Rounded v watershed FL000 MITIGATION PROJECT Funded Flood Mitigation Improvements Carter Road Detention Basin West 32nd Street Detention Basin Lower Bee Branch Creek Restoration Historic Millwork District Complete Streets Flood Mitigation Gate & Pump Replacement Upper Bee Branch Creek Restoration 22nd Street/Kaufmann Storm Sewer Capacity Improvements Bee Branch Creek Railroad Culverts 17th Street/W. Locust Storm Sewer Capacity Improvements North End Storm Sewer Capacity Improvements Flood Mitigation Maintenance Facility Water Plant Flood Protection Impervious Surface Reduction (Green Alleys) Bee Branch Healthy Homes *Estimated FLOOD MITIGATION PROJECT Total Cost: Total Grant Funding: Total City Share: Unfunded Improvements 22nd Street/Kaufmann Storm Sewer Capacity Improvements (N. Main to Kane) 17th Street/W. Locust Storm Sewer Capacity Improvements (Bee Branch to Elm) 17th Street/W. Locust Storm Sewer Capacity Improvements (Heeb to Rosedale) Cost $1,076,315 $4,158,589 $21,274,700 $7,977,311 $17,091,000* $60,995,000* $8,771,000* $31,654,000* $7,368,300* $1,400,000* $5,550,000* $4,400,000* $57,420,000* $8,427,665* $237,564,000* $163,015,016 $74,548,981 $17,770,000* $4,492,600* $23,090,000* FY2021 RECOMMENDED IMPROVEMENT REQUESTS 1. Upgrade Engineering Technician (GE-31) to Civil Engineer (GE-38) Increase Funding for 28E Agreement with Dubuque County and the Dubuque County Soil & Water Conservation District Recurring I $19,731 - Stormwater Utility $46,736 - Sanitary Sewer Funds 2. Funding to Maintain and Rehabilitate Ditches in the Public Right of Way Recurring I $10,000 3. Iowa Stormwater Education Partnership Recurring I $5,250 FY2021 RECOMMENDED IMPROVEMENT REQUESTS 3. Iowa Stormwater Education Partnership (ISWEP) Recurring I $5,250 — The Iowa Stormwater Education Partnership (or ISWEP) was formed in 2004 in response to NPDES Municipal Separate Storm Sewer System (MS4) permit requirements. — The majority of MS4 cities in Iowa are currently members of ISWEP. — Even though Dubuque has a robust stormwater and watershed program, citizens would benefit from further enhanced programs. Membership will also allow for the City to better share and collaborate with other communities across the state who deal with similar opportunities and challenges as Dubuque. STORMWATER MANAGEMENT UTILITY FEE RATES FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 Adopted 2012 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 $ 9.00 Adopted 2014* $ 6.81 $ 7.27 $ 7.76 $ 8.29 $ 8.85 $ 9.00 *Established March 5, 2014 with the passing of Ordinance 16-14 following the award of $98.5 million in state sales tax increment funding. FY 21 RATE INCREASE *Average Household = $&85/Month • 6.76% Proposed Rate Increase over FY 20 (lit $0.56 Monthly Bill Impact for Average Household* mi FY 21 RATE COMPARISON (Proposed) Rank City Rate 10 Des Moines 9 Dubuque 8 Cedar Rapids 7 West Des Moines 6 Ankeny $ 14.68 $ 8.85 $ 6.91 $ 6.05 $ 5.50 4 Iowa City 5 Ames 3 Waterloo 2 Davenport 1 Sioux City $ 5.00 $ 4.95 $ 4.25 $ 2.88 $ 2.80 Average w/o Dubuque $ 5.89 STORMWATER UTILITY FEE - SUBSIDY Since the establishment of the City's Stormwater Management Utility in 2003, the budget has included a general fund subsidy for property tax exempt organizations, low -to -moderate income residents, and residential farms. FY 21 Subsidy Property Tax Exempt Customers (-120) $400,609 Low -to -Moderate Income Customers (-380) Residential Farm Customers (-20) $34,326 $12,155 Fiscal Year Total $447,090 STORMWATER RFORMANCE MEASURES Outcome: Design and oversee construction of street/public ROW drainage systems to mitigate flooding and make the street available to the public during a rain event % of Storm Sewer construction occurring in conjunction with street reconstruction 95 95 80 Target FY 2018 85 FY 2019 FY 2020 MAJOR STREET CONSTRUCTION FISCAL YEAR 2021 BUDGET PRESENTATION PRIOR YEAR HIGHLIGHTS • • !1st Mil 1 MigNAMW • Completion of 22nd Street/Kaufmann Avenue Reconstruction from White St. to Main St. - Phase of HUD Resiliency Projects • Completion of 17th Street Reconstruction from Elm St. to Heeb St. - Phase of HUD Resiliency Projects PRIOR YEAR HIGHLIGHTS (Continued) • Completion of Northwest Arterial and Pennsylvania Avenue Right Turn Lane Project. • Central Avenue Pavement Resurfacing Project - 9th Street to 21 st Street Work Began: 2019 Complete: July 2020 FUTURE INITIATIVES • Reconstruction of Jackson Street from 11 th to 12th • Reconstruction of Chavanelle Road from Radford Road to the Northwest Arterial (IA 32) • Begin preliminary design and environmental clearance for the East-West Corridor Capacity Improvements • Extension of the Eastbound Northwest Arterial dedicated left turn lane onto JFK Road Streets r Y t i CAPITAL IMPROVEMENT PROJECTS Pavement Marking Project Street Construction General Repairs Pavement Preservation Program Chavenelle Rd Reconstruction Heeb Street Reconstruction Southwest Arterial Project Southwest Arterial ITS Corridor Development Pavement Rehabilitation - Concrete Street Repair, Mill and Asphalt Resurfacing Pavement Preservation Joint Sealing FY21 Co $ 135,000 $ 100,000 Total Project Cost $ 675,000 $ 520,000 $ 48,000 $ 48,000 $ 3,700,000 $ 3,700,000 $ 300,000 $ 300,000 $ 550,000 $ 550,000 $ 850,000 $ 1,700,000 Northwest Arterial Eastbound Dedicated Left Turn lane onto John F Kennedy (JFK) Road $ 520,000 $ 520,000 $ 50,000 $ 210,000 $ 180,000 $ 180,000 Sidewalks, Trails + Retaining Walls r Y t i CAPITAL IMPROVEMENT PROJECTS Sidewalk Inspection Program - Assessable Sidewalk Program - City -Owned Property Sidewalk Program Related Curb and Catch Basin Replacements Villa Street Retaining Wall Brick Paver Maintenance Federal Building Renovation FY21 Co $ 30,000 $ 170,000 Total Project Cost $ 150,000 $ 470,000 $ 25,000 $ 147,000 $ 1,600,000 $ 1,600,000 $ 30,000 $ 90,000 $ 446,000 $ 1,115,300 CHAVANELLE ROAD RECONSTRUCTION • $3.7 Million Dollar Reconstruction Project New Pavement, Curb and Gutter, Intakes, Sidewalk i j pO CT G BEGIN PROJECT CHAVEPIRIE ID 7 l DID PROJECT NW Arterial Eastbound Left Turn Lane Extension onto John F Kennedy Road • $105,000 Iowa DOT Traffic Safety Grant • Extending the existing eastbound Northwest Arterial dedicated left turn lane onto JFK Road from 125-foot to 400-foot length storage capacity CONSTRLICTE❑ RIGHT -TURN LANE f2D1 ) \\ PROPOSED PAVEMENT -TURN LANE EXTENSION.. FY21 BUDGET $ 180,000 • Staff have developed a sidewalk inspection app using ESRI products available • Chavenelle Road Trail Construction begins this spring Total Cost of $1,150,000 • Current construction year ADA ramps proposed is 180 STREETS PERFORMANCE MEASURER Outcome: Provide safe walking pathways throughout the City, including pedestrian access ramps % of property notices resolved within allotted time for un-shoveled sidewalks 100 75 50 25 0 80 57 Target FY 2018 • % 94 FY2019 80 FY 2020 RIGHT OF WAY ■■ • Online Permitting Interface ROW Permit Application Type of Use:* O Sidewalk / Driveway / Water Service / Sewer Service O Communication Cable Coaxial I Copper O Communication Cable Fiber Optic O Gas or Electric O Other (Please describe) Click the location/address of the project on the map* • GIS Asset Management • Curb Lines • Sidewalks & Curb Ramps • Street Signs • Pavement Markings • Pavement • Retaining Walls • Street Lighting • Electrical & Fiber • Storm Sewer • Sanitary Sewer • Drain Tile • Irrigation • Impervious Areas RIGHT OF WAY ■ ■ • Worked with GIS Staff to develop online permitting interface • Iowa One Call ticket volume is increasing substantially 10000 - 8000 - 6000 - 4000 - 2000 - 0 5581 Iowa One CaII Ticket Volume 50% Increase 5754 5824 6075 7172 7648 8341 12/31/10 12/31/11 12/31/12 12/31/15 12/31 / 17 12/31/18 12/31/19 One Calls US52 / SOUTHWEST ARTERIAL The #1 Surface Transportation Project in the Dubuque Area "1 US52 / SOUTHWEST ARTERIAL History & Timeline 1987 - Cedar Cross Arterial Alignment 1996 - Policy makers and Iowa DOT determined an arterial farther to west would better serve community needs • 1999 - Initial corridor alignment Environmental Assessment completed - Iowa DOT concluded SW Arterial should connect US20 to US61/151 further west of Seippel and west of FDR Park • 2002 - Iowa DOT stopped work on the project • May 2002 - the City executed an Agreement with the Iowa DOT for the City to take over SW Arterial Masterpiece on the Mississippi Ca DOT SMARTER I SIMPLER I CUSTOMER DRIVEN ,UE� ARFAC7104111OFCMEV i GreaterDubuque US52 / SOUTHWEST ARTERIAL History & Timeline ' Environmental NEPA Clearance - Started 1999 ' Preliminary Engineering Design ' Final Engineering Design ' Property Acquisition ' Utility Relocation ' Construction Masterpiece on the Mississippi Completed 2004 ▪ Started 2005 Completed 2008 ▪ Started 2009 Completed 2018 ▪ Started 2009 Completed 2019 ▪ Started 2015 Completed 2019 ▪ Started 2010 Completed July 2020 OEM SMARTER I SIMPLER I CUSTOMER DRIVEN DUZQUE C� ,(11„MBIX ( GreaterDubuque US52 / SOUTHWEST ARTERIAL Milestone Achievement City Responsible to Complete 41 ■ Final Engineering Design ■ Property Acquisition ■ Utility Relocations ■ North Cascade Rd Reconstruction ■ English Mill Rd Reconstruction ■ Military Road Reconstruction Memorandum of Understanding Signing Ceremony August 9, 2013 Transfer of Jurisdiction Agreement Signed November 17, 2016 US52 / SOUTHWEST ARTERIAL Property Acquisition 56 PROPERTIES PURCHASED 93 TOTAL ACQUISITIONS FINAL COST: $18.2 MILLION LAST PAYMENT ISSUED JULY 2019 SOLETHWEST ARTERIAL = moo a City of Duhogoo, Iowa ACQUIS(IIQN STATUS US52 / SOUTHWEST ARTERIAL Final Costs Project Final Engineering Design Property Acquisition Utility Relocations North Cascade Rd Reconstruction English Mill Rd Reconstruction Military Road Reconstruction Bridge Post Color Concrete & Railing TOTALS: 2013 Cost Estimate FINAL COST $ 10,804,400 $ 13,770,270 $ 12,800,000 $ 18,166,426 $ 2,200,000 $ 2,926,576 $ 3,868,581 $ 3,725,601 $ 3,852,200 $ 3,789,927 $ 6,380,000 $ 5,218,236 $ 533,905 $ 39,905,181 $ 48,130,942 US52 / SOUTHWEST ARTERIAL US20 Interchange US52 / SOUTHWEST ARTERIAL Middle Interchange rr UNDER CONSTRUCTION NORTH CASCADE ENGLISH MILL US52 / SOUTHWEST ARTERIAL Catfish Creek US52 / SOUTHWEST ARTERIAL 1 US61 - 151 Interchange US52 / SOUTHWEST ARTERIAL ■ US61 - 151 Interchange 0 • • LIGHTING AT DUSK A_• 1111-0 US52 / SOUTHWEST ARTERIAL Funding Summary State Funding (2016 - 2019) • 4-Lane Highway US 20 to US 61/151 $ 115 Million City - Fed SAFETEA-LU Funds $ 32.8 Million City - Fed Re -Purpose Funds $ 2.6 Million City - State Primary Rd Funds $ 2.7 Million City Funding $ 6.6 Million Dubuque County Funding $ 3.98 Million TOTAL FUNDING $ 163 Million US52 / SOUTHWEST ARTERIAL ITS Corridor Development • Approved Partnership Funding Agreement with Iowa DOT Iowa DOT / State of Iowa City Funding FY21 / FY22 Total Project Cost $ 1,500,000 • Fiber Optic Network • Cameras • Sensors • Other Technology Masterpiece on the Mississippi our DOT SIMPLER !CUSTOMER DRIVEN EAST - WEST CORRIDOR CAPACITY IMPROVEMENTS Accomplishments • August 2019 City received FHWA final closure acceptance for defederalization of funds • SWAP Funding Agreement with Iowa DOT in December 2019 rapes #,a1_ _ ) �td'111 _ . , gib•---- . • Preliminary Engineering & Environmental Clearance Consultant Selection is currently underway EAST - WEST CORRIDOR CAPACITY IMPROVEMENTS Accomplishments In an effort to advance this Council Top Priority, the City has already completed several capacity and safety improvements: Project Year Cost Property Acquisition 2016 $ 853,305 Grandview - Delhi Roundabout 2016 $ 827,000 Loras - Grandview Traffic Signals 2017 $ 370,300 University - Grandview Roundabout 2018 $ 1,200,000 Total Improvements To -Date $ 3,250,300 East/West Corridor Capacity Improvements Property Acquisition Completed: 2016 University, Lams, Asbury, Pennsylvania Overlap Section Proposed Roundabouts Preliminary Design' Environmental Study: 2020 174. %. 4Y i GrandviewILoras Traffic Signal Improvements Completed: 2017 Grandview/University Roundabout Completed: 2018 Grandview/Delhi/Grace Roundabout Completed: 2018 EAST - WEST CORRIDOR CAPACITY IMPROVEMENTS Project Development PENNSYLVANIA Eelhonosd Crosswalks EAST - WEST CORRIDOR CAPACITY IMPROVEMENTS • • Development Schedule 2021 2022 2023 2024 Preliminary Design Environmental Phas $1.0 Million Final Design $1.0 Million Property Acquisition $4 Million UNIVERSITY OVERLAP SECTION Construction $5 Million US52 / CENTRAL AVENUE RESURFACING 9TH to 21st Street • Final Phase of Joint Partnership Project between the City and the Iowa DOT - Transfer State of Good Repair • Asphalt Resurfacing of Driving Lanes and Parking Areas • Installation of ADA Pedestrian Access Curb Ramps (30) • Water Main & Storm Sewer Improvements Underground Utility Conflicts Access Curb Ramps CONSTRUCTION $1.72 Million NORTH CASCADE ROAD RECONSTRUCTION • Phase 1 - Catfish Creek Bridge to Edval Lane • Safety Improvements Realignment of Existing Curves • 35-Foot Urban Complete Street, 5-Foot Shoulder and Bike Lane • Water Main Extension • Begin Construction: May 2020 • Completion: November 2020 Project Cost: $1,920,000 NORTH SI:]E 1T S WIDE BIKE 1T DRIVE 1ANE LANE 3S CEN IELHL1rJL ]_1lJ FI$IDE wrDE BIKE LANE CONSTRUCTION SUMMER / FALL 2020 Proposed Edge of Road cITY,OF DueUQUE COPPORATEUMIT TFISH REEK PAVEMENT PRESERVATION Concrete Street Repair, Mill & Asphalt Resurface • Significant Concrete Slab and Pavement Joint Deterioration • Major Rehabilitation to Extend the Service Life and Reduce Annual Maintenance Cost Concrete Joint Deterioration North Grandview Pavement Preservation FY21 BUDGET $ 520,000 VILLA STREET RETAINING WALL • 30-Foot Tall Limestone Wall • Regular Survey Monitoring for Movement • Showing Signs of Distress • Pro Active Reconstruction FY21 BUDGET $ 1,600,000 r�k�� _. ".+5i_ .. 'P i � 'P' . .. .._ .�. �.'f;- � .. ,.. ij•..; �c ;•'j.�,:.. ,, 19,.�r_..r• -. a•�,.�.� TRAFFIC OPERATIONS FISCAL YEAR 2021 BUDGET PRESENTATION Traffic Operations Center Breakdown of Duties • Video Management System 40% • Fiber Network and Broadband Expansion 38% • Signal Operations 17% • Traffic Studies and Warrants 3% • Street Lighting 2% Project Management is proportional to percentages PRIOR YEAR HIGHLIGHTS • • • Installation of fiber optics and cameras on the Julien Dubuque Bridge. • Installation/reconstruction of major fiber backbone runs along major corridors and the downtown. • Major video management upgrades including new servers and interconnects between government entities. • JFK at Hillcrest - unplanned repairs FUTURE INITIATIVES • • • STREETS PROGRAM Southwest Arterial Fiber and Camera Project Coordinating Fiber to the Home (FTTH) Large Public/Private Joint Communications Build FIBER HAS MANY USES • Feeds many other types of Communications • Smart Transportation • Monitoring City Assets • City Surveillance • Economic Development Driver Ultra -Broadband IP and M2M platform for Smart City kalS10- gill vv. M Maim oi 9000 Air!: rt, Iry Access Rooter. & MktOwave • LIMIT 4. SWAT 114.1•I5rOt.TIl1PM tDutAT1OR / • •wain. � I NrA. rT MlAItIKA•t U•yt•110. Mrtlrt M2M/IOTySWIM• Ot.1lO rr•tx. MAW -MS 1••4A•41/110- yyA.T aO•a PUNK `PLATFORM' • 11AlOerPUNKKMCIS S ON RAM MOW...tuuatD Rry • MI 1w01.1N..Kt .110•10t. rrtri0•,1 {G/WWI Service Router �III111 Access Router Oada Center intarCOOnaet —111111 .� 11IIIII w" ?,IIIIII Romer Optical Transport Ixlnherv0, Access Node • f FIBER OPTICS 101 Cost breakdown of fiber optic communications installation: • Raw Duct $0.50 to $1.75 / ft • $8-20 a foot per 1.25" duct to install • Fiber cable raw cost: • 24 SM $0.50 /ft • 72 SM $0.70 /ft • 144 SM $1.00 /ft ($0.70/strand-ft) • 432 SM $3.00 /ft • Cost to install fiber cable • $0.50 to $1.00 /ft to jet in • $15/splice R EXPANSION Timeline of fiber deployments in the City of Dubuque Late 1990's - Installed fiber paths between buildings. Early 2000's started connecting traffic signals 2005 Started installing fiber with other infrastructure projects such as: • Road Reconstruction • Sidewalks 2010 Started requiring fiber as part of subdivisions. 2012 Initiative to include fiber with the design of all public improvement projects By 2016 there was approximately 35 miles of fiber duct installed by the City. '‘\\\ ..., k1.. NON aa«....a M. M�M [owmln! ADSS Long Span Dual jack.: NAN --4 hem. FmM4 2016 The City of Dubuque started a City broadband group and worked with GDDC to promote broadband expansion. This group meets twice a month. R EXPANSION Goal of this group: Accelerate broadband via public/private collaborations Strategy: Reduce costs & time for investment, move Dubuque ahead of the line. Action: Process streamlining, revision of regulations, establishing "Master" agreements and templates. Innovations: Infrastructure sharing, capacity collaborations, "living lab" technologies. This broadband expansion has increased competition which will bring the cost down and promote economic growth. * Outcome: Moved Broadband from a community and business Negative to a positive Duct Multiplier Technologies 1.0" Standard Fiber Jetting w/Microduct 1.5" w/Micro 7-Way Microduct Electric w/Micro FIBER EXPANSION Right of Way (ROW) Preservation Space is limited • Sidewalks & Curb Ramps r • Street Signs • Pavement • Retaining Walls • Street Lighting • Electrical & Fiber • Storm Sewer • Sanitary Sewer • Drain Tile • Irrigation • Impervious Areas FIBER EXPANSION SINCE 2014 Rapid growth of fiber duct. This is the expensive part of building a fiber network (typically $15 to $40 a foot) Big savings when partnering but major time investment from City Staff. Actual usable duct is multiplied Many cities interested in replicating 100 80 60 40 20 0 t 2014 2015 2016 2917 2018 2019 2020 Forecast Miles of Duct FIBER EXPANSION AND PARTNERSHIPS • Fiber Conduit Installed Prior to 2015 FIBER EXPANSION AND PARTNERSHIPS • City Conduit Including Joint Collaboration ^Zc,Sfumpf Island !a 4sland Dubuque, IA ©;buque to - East Dubuque FIBER EXPANSION AND PARTNERSHIPS PUBLIC / PRIVATE PARTNERSHIPS This workflow has drawn in additional providers including: Centu ryLi n kc comek?c INTERNET SERVICES iMaquoketa Valley Electric Cooperative Q7 t••�i. link F18ERINTERNET FIBER INTERNET Med l acom . Unite. PRIVATE NETWORKS ICN BROADBAND STRONG STRONG FLEXIBLE FAST TECHNOLOGIES, INC. Future Initiative SW Arterial Intelligent Transportation System Improvement Project consists of the following improvements Fiber Optic Communications (approximately 7 miles) connecting US 20 to US 151 Communication cabinets and cameras at key intersections to achieve coverage of SW Arterial. Estimated Cost: $1,469,000. Future Initiative Public/Private Joint Communications Build Project consists of the following improvements: • Fiber Optic Communications (approximately 10 miles) connecting Old Highway at Seippel Road to the Wisconsin Bridge. • Multiple partners to bring the cost down. • ROW preservation • Adds coverage and redundancy for providers Signal Operations ■■ Operations and Maintenance of the following systems: • Communications network between 115 signals • Central management software • Battery backup systems • Emergency Vehicle Pre-Emption (EVP) system • Vehicle Detection Systems • Intelligent Transportation Systems (ITS) improvements • Road Side Units (RSU's) Signal Operations Regular maintenance related to signal operations include: • Maintenance and replacement of communications systems • Central Management Software updates (TACTICS/CMS) • Signal knockdowns and reprogramming of equipment • Emergency Vehicle Pre-Emption (EVP) programming and Maintenance • Intersection Detection Maintenance • Travel time sensors and software • Intelligent Transportation Systems (ITS) improvements • Flashing beacons for speed control in school zones • Equipment purchasing for replacement schedules • Battery replacement and testing • Traffic safety audits • LED fixture replacements when they fail (go dark) VIDEO MANAGEMENT SYSTEM 1:4c, All city cameras are on one platform (Milestone) including County and School District. City owns /operates 1205 cameras in 250 locations 30 days recording retention. w `pie __./ day VMS Central Monitor » Recorded Data Live Streaming NETWORK -- • VMS Client VMS Client VIDEO MANAGEMENT SYSTEM Use Case: Traffic Operations Center • Remote viewing and traffic adjustments • Accident investigations and safety studies • Historic patterns • Malfunctions and equipment status • Manual vehicle and pedestrian counts Sharing streams with developers and other agencies Plan to automate many of these processes with analytics https://www.aicitychallenge.org City of Dubuque Video Management System unlike others. VIDEO MANAGEMENT SYSTEM Goal is efficient use of system by maximizing coverage with minimal equipment This accounts for more that 2000 cameras countywide. Used by: •Engineering / Construction Inspection •Police/Sheriff Department •Fire •Public Works •Parking •Animal Control •Special Events * Outcome - Each department is more efficient at their job PART I CRIMES (CY 2012 - 2019) Performance Measures CY12 CY13 CY14* CY15 CY16 CY17 CY18 CY19 Avg. CY19% Over/Under CY18 CY19% Over/Under Average CY19% Over/Under Peak Year No. of Crimes Against Persons 186 208 220 265 243 203 190 190 213 0.0% -10.9% -28.30% Murder 2 0 0 5 1 2 1 0 1 -100.0% -100.0% -100.0% Sexual Assault 43 38 61 80 98 90 75 91 72 21.3% 26.4% -7 1 % Robbery 21 32 20 27 26 16 29 14 23 -51.7% -39.5% -56.3% Aggravated Assault 120 138 139 153 118 95 85 85 117 0.0% -27.1% -44.4% No. of Crimes Against Property 1,992 1,791 1,662 1,953 1,875 1,667 1,543 1,319 1,725 -14.5% -23.5% -33.8% Burglary 583 431 416 548 420 331 299 205 404 -31.4% -49.3% -64.8% Burglary to Motor Vehicle 298 231 168 106 144 157 145 88 167 -39.3% -47.3% -70.5% Theft 1,080 1,103 1,035 1,245 1,235 1,116 1,036 945 1,099 -8.8% -14.0% -24.1% Theft of Motor Vehicle 31 26 43 54 76 63 63 81 55 28.6% 48.3% 0.0% Total 2,178 1,999 1,882 2,218 2,118 1,870 1,733 1,509 1,938 -12.9% -22.2% -32.0% = High Year 3 0 0 V I y . . , 29 8 23 1 16 8 10 6 14 4 15 7 14 5 184 8% (21)% (51)% 10 11 10 12 12 11 10 113 70z ran°i r1710I CRIMES CLEARANCE RATES ■ ■ CRIMES CLEARANCE RATES "Part 1" Crimes Against Persons Murder, sexual assault, robbery, aggravated assault 100 80 60 40 20 0 National Clearance Rate 46% Dubuque Police Department Clearance Rate 92% *In criminal justice, clearance rate is calculated by dividing the number of crimes that are "cleared" (a charge being laid) by the total number of crimes recorded. Clearance rates are used by various groups as a measure of crimes solved by the police. STREETS PROGRAM • Smart Traffic Routing with Efficient and Effective Traffic Signals (STREETS) • Goal is to develop a smart, next -generation, traffic management and control system MICROSIMULATION PROCESSES EL 4 TRAVEL TIML SYSTEM REAL-TIME HIGH SPEED DATA COLLECTION 3 - PARTY DATA TRAFI. c MANA;.FVF Y' CrIC Al MS, ASC I, SPM OECIS ON SUPPORT SYSTEM DMS TRAVELER tNFORMATION DATA ��wv•a •� I ANtL STREETS PROGRAM STREETS will dynamically react to congestion detected or predicted by the Micro -simulation model, and proactively change signal timing based on predicted traffic flow data while disseminating congestion and alternate route information for motorists. * This program will require dedicated quality time from key City of Dubuque staff who know the system well to be a successful • ro'ect. Trigger Field Data Performance Measures • Traffic Count • Travel Time • Speed Data • Traffic Flow • O-D • Traffic Pattern • Signal Phasing & Timing • Incidents • Camera analysis • System Performance Process Decision Action Demand Model / Microsimulation Model Decision Support System • Route Recommendation • Timing Recommendation ATIS • DI S • Apps • 511 ATMS/ASCT Adaptative Signal Control ATMS Enhancements STREETS PROGRAM BUDGET IMPACT Estimated Cost Hardware and software components $2,693,000 Plan development/engineering/contingency $593,250 City/DMATS/consultant review and deployment $405,000 Total Estimated Cost Current Budget FHWAAID GRANT ICAAP SWAP FUNDS STATE FUNDS DMATS STBG SWAP FUNDS TSIP CITY FUNDS Total Budget $3,691,250 $998,000 $818,250 $300,000 $700,000 $100, 000 $575,000 $3,491,250 LED, 1250 City Owned LED Conversion (out of 2484 Total) ■■ HPS • LED HPS, 1234 LED Light Conversion - City City Owned LED Conversion (out of 2484 Total) HPS LED ■■ LED Light Conversion - Alliant FY2021 RECOMMENDED IMPROVEMENT REQUESTS 1. Camera Systems Technician (GE-28B) Recurring I $76,749 Net Property Tax Cost: 0.17% • Staffing in Traffic Engineering has remained nearly constant in the last 20 years. • Technologies, equipment and programs that improve our lives continue to grow and become more complex- these all require constant care and maintenance • 75% of our time is managing systems. • 2-5% of cameras are down daily. • Camera, switch, fiber and networking outages are most common. FY2021 RECOMMENDED IMPROVEMENT REQUESTS 1. Path Solutions software package $30,240 Tax Funds Non -Recurring $5,600 Tax Funds Recurring Path Solutions software manages critical networks and equipment. The goal is to resolve issues quickly and reduce the City's dependency on outside vendors for this type of help. This software would be installed on the City's IT network along with the Traffic Signal and Camera network with the goal of higher network and city surveillance reliability with less money being spent on contract vendors. Traffic Operations FY 21 CAPITAL IMPROVEMENT PROJECTS Traffic Signal Projects Street Light + Camera Projects Fiber + Broadband Projects STREETS Project $490,000 $245,676 $331,000 $3,466,250 Total Project Costs $2,320,472 $1,103,449 $1,456,000 $3,591,250 Traffic Operations FY 21 CAPITAL IMPROVEMENT PROJECTS Traffic Signal Projects Signalization Program Traffic Mastarm Retrofit Traffic Signal Interconnect Conduit Replacement Traffic Signal Controller Replacement Project Street and Traffic Knockdown Fund Traffic Signal Battery Backup Program Traffic Signal Intersection Reconstruction Surge and Grounding Improvements Traffic Signal Vehicle Detection Conversion ITS Traffic Control Equipment Asbury Road at JFK Signalization Reconstruction Emergency Preemption Expansion and Upgrades $70,000 $65,000 $30,000 $35,000 $25,000 $10,000 $40,000 $10,000 $50,000 $20,000 $120,000 $15,000 Traffic Operations FY 21 CAPITAL IMPROVEMENT PROJECTS Street Light + Cameras Projects Street Light Replacement and New Installation Grandview Street Light Replacement Street Cameras Installation $128,200 $35,000 $82,476 Traffic Operations FY 21 CAPITAL IMPROVEMENT PROJECTS Fiber and Broadband Projects Traffic Signal Fiber Optics Fiber Optic Conduit - Misc INET Replacement Build Out Broadband Acceleration and Universal Access $65,000 $40,000 $90,000 $136,000 TRAFFIC PERFORMANCE MEASURE! Outcome: Continue growth of traffic operation cameras, security cameras, and fiber/conduit 25 0 of signalized intersections with Fiber Communications 60 17 1 FY 2018 74 FY 2019 il % Installed 80 100 FY 2020 Target I wo 1 N DEP MENT MISCELLANEOUS IMPROVEMENTS FISCAL YEAR 2021 BUDGET PRESENTATION PRIOR YEAR HIGHLIGHTS • • Final Cost: $234,000 • Historic Federal Building Roof Replacement Project PRIOR YEAR HIGHLIGHTS • • • Lot Size = 5.00 Acres • Final Construction Cost: $219,500 • Bowling and Beyond Site Deconstruction o PRIOR YEAR HIGHLIGHTS • • • Bowling and Beyond Site • Redevelopment Ready FUTURE INITIATIVES • CHAPLAIN SCHMITT VETERANS MEMORIAL • FEDERAL BUILDING RENOVATION • ABC SUPPY BUILDING DECONSTRUCTION • U.S. ENVIRONMENTAL PROTECTION AGENCY - MULTI - PURPOSE GRANT • PORT OF DUBUQUE - RIVERFRONT DOCK EXPANSION CHAPLAIN SCHMITT MEMORIAL IMPROVEMENTS • Project will include plaza expansion, elevated boardwalk, Skyward sculpture, and enhancements to the edge of the pond. • Scheduled Completion: May 2021 • Construction Cost: $2,560,000 (100% DRA Funded) PROPOSED DESIGN VETERANS MEMORIAL PARK Dubuque, IA FEDERAL BUILDING RENOVATION • Project will be completed over a 5 year period starting in 2020 • FY 2021 will include penthouse roof replacement, loading dock structural repair, and refurbishing the main lobby (paint, woodwork, lighting) RIVERFRONT LEASEHOLD IMPROVEMENTS • FY10 Revenue = $204,000 RIVERFRONT LEASEHOLD IMPROVEMENTS • FY10 Revenue = $204,000 • FY21 Revenue = $2,765,000 RIVERFRONT LEASEHOLD IMPROVEMENTS • FY10 Revenue = $204,000 • FY21 Revenue = $2,765,000 • 38 Active Lease Agreements RIVERFRONT LEASEHOLD IMPROVEMENTS • FY10 Revenue = $204,000 • FY21 Revenue = $2,765,000 • 38 Active Lease Agreements • 20 Broadband Master Service Agreements RIVERFRONT LEASEHOLD IMPROVEMENTS Gavilon Purina Drive FY21 Revenue $210,400 RIVERFRONT LEASEHOLD IMPROVEMENTS ■ ■ Gavilon 7th Street FY21 Revenue $475,000 ABC Supply Building Deconstruction ■ ■ Lot Size = 1.00 Acres Estimated Cost = $417,000 EPA - Multipurpose Grant $800,000 grant funds $40,000 local match Community Involvement 5Phase l&5Phase II Assessments CITY OF DUBUQUE, IA 44, 4r N E t f 1711nr nn.a>..«rt fl'*snhlDees '}Ilrlgr,r hHrtws..1 4 ® Minns lranteM Snt; Crl lards End MriLlborholdl.dart Waskiytloi NreflLarhr id lnundlrl II Spot; Part - Cl1lI. tlSt l Cmmsrrat NORTH Cr,dit CIY t' CWkldw 66 EPA - Multipurpose Grant $800,000 grant funds $40,000 local match Cleanup/Reuse Planning Remediation: Comiskey Park $187,000 Sinclair Oil $220,500 Dodd's Terminal $220,500 CITY OF DUBUQUE, IA 64* 111861612 4rellS/..:.l .d W.. Mi eat tou.,..a w�.« I Cvrsnr on.aTM'Lpr+snklMn'}IIIIg5,r hHrtwir.1 4 ® weans lr0.IT* a See; Crl lards End lrireborholdl.dart Waskiytloi NIerILarhr id lnundlrl 11 Spot; Part - Cl1lI. tlSt l Cemnrr¢t NORTH Credit CIY I' DUladw 66 EPA - Multipurpose Grant Comiskey Park $187,00 EPA - Multipurpose Grant Dodd's Terminal $220,500 EPA - Multipurpose Grant . I Sinclair Oil $220,500 r PORT OF DUBUQUE - RIVERFRONT DOCK EXPANSION Tourism Growth Support forecasted increase in River Boat traffic on the Mississippi River PORT OF DUBUQUE - RIVERFRONT DOCK EXPANSION Project Development • City partnership with Viking • 50% Cost Share • Begin river cruises 2020 • Economic Tourism Impact inuu•u' usu......•....... Funding FY 2021 FY 2022 City $ 550,000 $ 550,000 Viking USA $ 500,000 $ 500,000 Total Funding $ 1,050,000 $ 1,050,000 THANK YOU www.cityofdubuque.org/Engineering