The URL can be used to link to this page

Engineering Department FY19 Budget Presentation Copyrighted February 26, 2018 City of Dubuque Public Hearings # 4. ITEM TITLE: Engineering Department FY2019 Budget Presentation SUMMARY: SUGGESTED DISPOSITION: ATTACHMENTS: Description Type FY19 Engineering Department Budget Supporting Documentation Recommendation Engineering 129- This page intentionally left blank. -130- ENGINEERING DEPARTMENT FY 2017 FY 2018 FY 2019 % Change From Budget Highlights Actual Budget Requested FY 2018 Budget Expenses Employee Expense 3,196,677 2,911,988 2,971,268 2.0 % Supplies and Services 1,326,307 1,680,075 1,386,616 (17.5)% Machinery and Equipment 413,212 445,350 509,967 14.5 % Less Recharges to Service Funds (2,024,822) (2,048,069) (1,869,563) (8.7)% Administrative Overhead Charges 499,607 470,674 469,385 (0.3)% Total Expenses 3,410,981 3,460,018 4,992,673 44.3 % Resources Operating Revenue - General 2,260,216 2,191,740 2,388,050 9.0 % Administrative OH Recharges 320,250 426,265 411,666 (3.4)% Road Use Tax Funds 302,583 398,033 437,855 10.0 % Utility Charges - Stormwater 1,881,378 1,765,305 3,037,664 72.1 % Utility Charges - Sanitary 172,455 198,838 235,794 18.6 % Total Resources 4,936,882 4,980,181 6,511,029 30.7 % Debt Service Stormwater debt abated with Stormwater User Fees 3,972,356 2,374,416 1,997,081 (15.9)% Stormwater debt abated with Sales Tax Increment 1,560,984 2,067,597 2,562,211 23.9 % Street Projects Debt abated with Sales Tax Fund (30%)/RUT 260,766 250,573 251,912 0.5 % America's River Debt Abated with TIF &General 928,379 918,617 887,927 (3.3)% Total Debt Service 6,722,485 5,611,203 5,699,131 1.6 % Property Tax Support (1,525,901) (1,520,163) (1,518,356) 1,807 Percent lncrease/(Decrease) (0.1)% Personnel -Authorized FTE 34.62 29.29 30.23 -131- STORMWATER UTILITY FY 2017 FY 2018 FY 2019 % Change From Budget Highlights Actual Budget Requested FY 2018 Budget Expenses Employee Expense 547,653 783,090 762,803 (2.6)% Supplies and Services 905,716 1,037,034 729,032 (29.7)% Payment to Construction Fund % Less Recharges to Service Funds (111,165) (630,038) (586,867) (6.9)% Machinery and Equipment 61,079 675 51,650 7,551.9 % Administrative Overhead Recharge 499,607 470,674 1,994,385 323.7 % Park Stormwater Maintenance Charges 94,047 156,233 145,928 (6.6)% Public Information Office (21,512) 103,870 86,661 (16.6)% Public Works Stormwater Maintenance Charges 272,744 268,577 241,698 (10.0)% Debt Service 5,533,340 4,442,013 4,559,292 2.6 % Total Expenses 7,781,509 6,632,128 7,984,582 20.4 % Resources Operating Revenue 6,569,909 4,810,414 5,426,723 12.8 % Sales Tax Increment 1,560,984 2,067,597 2,562,211 23.9 % Total Resources 8,130,893 6,878,011 7,988,934 16.2 % Net Operating Surplus (Deficit) 349,384 245,883 4,352 (241,531) Personnel -Authorized FTE 11.75 7.35 5.85 Stormwater User Fee Rate Increase 6.69% 6.74% 6.75% Stormwater User Fee(per SFU) $ 6.81 $ 7.27 $ 7.76 Revenue 1% Rate Increase Generates $ 42,006 Improvement Package Summary Stormwater Fund 1 of 2 This decision package would provide for the addition of a 30 hour/week Infiltration and Inflow Inspector (GE-26) would be responsible for performing administrative and technical work in identifying potential illegal discharges into the sanitary sewer system. This employee would work to identify potential illegal discharges into the city sanitary sewer system. They would communicate with and educate property owners regarding potential illegal discharges into the city sanitary sewer system. This work would include processing I&I inspection and flow monitoring data; maintaining the I&I Program's permanent and temporary SCADA meters and rainfall gages, drafting and issuing I&I inspection reports to property owners; conducting flow monitoring activities and coordinating pipe condition assessment video inspections with the City's Public Works Department and private contractors; conducting dye and smoke testing studies to discover sources of I&I; performing construction observation of I&I elimination capital improvement projects, maintaining and updating sanitary sewer infrastructure records in the City's GIS system: and also gathering and tabulating statistical data in connection with engineering activities related to Consent Decree reporting requirements. Related Cost: $34,491 Stormwater User Fee Recurring- 6 Years Recommend -Yes Stormwater User Fee Impact 0.82% Activity: Stormwater -132- 2 of 2 This decision package provides additional funds for engineering consulting services, Storm Sewer System Hydrological and Hydraulic Model using EPA based XPSWMM model. This improvement package provides for the expansion of the current XP-SWMM computer model of the City's storm sewer system that was created with the development of the Drainage Basin Master Plan and Bee Branch Watershed Flood Mitigation Project. XPSWMM allows for holistic modeling: Hydrology, Hydraulics and Water Quality. Experts know that a change to one element in a system may affect the performance of the entire system. XPSWMM allows for the evaluation and interaction of all system elements - channels, pipes, streets, control structures, ponds, weirs, pumps, catchments, groundwater table, overland floodplains, rain gardens, infiltration trenches and more in a single model. XPSWMM is widely used and accepted; it is EPA tested and FEMA approved. Countless regulatory organizations around the country are familiar with XPSWMM and prefer modeling performed with its powerful tools. It is a fully dynamic hydraulic and hydrologic modeling software that can calculate upstream to downstream flow down streets, through storm sewers, through detention ponds, through roadside ditches illustrating what truly happens to at various points in the stormwater system, sewer system, and floodplain areas when waters flow, development/ redevelopment occurs, or when catastrophic events hit. The City's current XPSWMM model is limited to the Bee Branch Creek/storm sewer with input from tributary systems such as up Kaufmann Avenue and W. Locust Street. Expansion of the model to all drainage systems in the city will allow for identifying poor performing elements throughout the City that exhibit poor drainage characteristics and contribute to flooding under various circumstances. Expanding the system will inform decisions as to the appropriateness of proposed changes to the drainage system to ensure newly constructed facilities provide for the expected level of flood protection and do not bring about new drainage problems that lead to downstream property damage. Expanding the model would facilitate the engineering design of new systems done through the development or redevelopment of private property as the capacity of downstream facilities will be better understood in the early stages of development. Expanding the model will help illustrate the impacts watershed improvements have on the Bee Branch Creek both in terms of flood control water quality. Related Cost: $35,000 Stormwater User Fee Recurring- 6 Years Recommend -Yes Stormwater User Fee Impact 0.83% Activity: Stormwater Sanitary Fund 1 of 1 This decision package would provide for the addition of a full-time water resource engineer (GE-38). The primary role of this position would be to lead the City's management of its sanitary sewer gravity collection system. Work on the collection system includes overseeing a Consent Decree with the United States Department of Justice and Environmental Protection Agency, inflow and infiltration (I&I) source identification and subsequent development of elimination strategies, semi-annual reporting to the EPA on I&I reduction efforts, capital repair project management and other general management responsibilities for the City's 281 miles of gravity sanitary sewer. This position would also perform primary oversight and engineering technical review duties of proposed sanitary sewer and stormwater systems as part of the City's Development Review Team, which is responsible for reviewing all new development site plans. The Water Resources Engineer collaborates with the Budget Director, Water & Resources Recovery Center Manager, Public Works Director and City Engineer to lead the management of the City's sanitary sewer utility capital and operations and maintenance budgets along with providing technical assistance to the City's Water & Resource Recovery Center (wastewater plant) as it relates to force main and lift station performance assessment, future maintenance needs and capital improvements. -133- Related Cost: $104,333 Sanitary User Fees Recurring Recommend - No Sanitary User Fee Impact 1.02% Activity: Sanitary General Fund 1 of 5 This decision package would provide for the addition of a full-time camera systems technician (GE-28) 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. Related Cost: $ 67,031 Tax Funds Recurring Recommend - No Related Cost: $ 6,500 Tax Funds Non- Recurring Total Cost: $ 73,531 Property Tax Impact: $ 0.0294 0.28% Activity: Project Engineering 2 of 5 This decision package would provide for the addition of non-recurring engineering intern position (NA-34) for 520 hours annually (0.25 FTE). The Army Corp of Engineers as a matter of maintaining a federally accredited levee, requires the City to document all fixed objects or "encroachments" located within the regulated areas of the floodwall. The Engineering, Legal and Public Works Departments started this effort in the summer of 2013. Remaining work includes getting signed encroachment permits for three sites north of 16th Street and getting encroachment permits signed for all building sites south of 16th Street. Currently the Engineering Department does not have available staff resources or budget to complete this assignment anytime in the near future. This improvement request will fund one intern for 12 months to -134- complete all of the outstanding encroachment permit documents so that they can be submitted to the Army Corp of Engineers. Related Cost: $ 9,761 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.0039 0.04% Activity: Project Engineering 3 of 5 The Traffic Operation Center (TOC) was constructed in 2006 and is used on a daily basis for the control and operation of the city's traffic signal operations and camera systems. The TOC is also used daily for meetings and webinars by city staff, consulting engineers and vendors of intelligent traffic systems. When the TOC was originally furnished in 2006, its usefulness as a meeting room was unknown and therefore lower cost furniture and carpeting were specified to keep the construction project within budget. Over the last 12 years the carpet in some places has become significantly worn, stained and is now fraying in several places. The eight chairs around the central meeting table have become heavily worn and leave fabric particles on the floor after every use. This improvement covers the cost of new commercial carpet and chairs for the TOC meeting space. Related Cost: $ 8,500 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.0034 0.03% Activity: Traffic Operations 4 of 5 This improvement package would provide the funding for engineering department storage area improvements. The Engineering Department is allocated approximately 1,200 square feet of storage space in the basement of City Hall. The area is used by the Engineering Department for Capital Improvement Project record keeping and equipment storage for general fund, stormwater and sanitary sewer projects. The area is very dusty and has high humidity levels which are not good for long term storage of documents. This improvement would fund an initial renovation phase of this space by allowing rough finished gypsum walls and additional lighting to be installed along with repairs to the floor. Related Cost: $ 6,800 Tax Funds Non-Recurring Recommend -Yes Property Tax Impact: $ 0.0027 0.03% Activity: Engineering Administration 5 of 5 This decision package is designed to further that goal by ensuring equitable access to and participation in City services and programs for residents with Limited English Proficiency or with hearing, speech, or vision impairments. City of Dubuque American Communities Survey data for 2011-15 estimates that the following population that speaks English less than "very well": a) Spanish speakers = 0.4% (195 people); b)Asian/Pacific Islander languages = 0.8% (460 people); Other Indo-European Languages = 0.5% (274 people). The Dubuque Community School District's 2015 report indicates that over the past 15 years the district's English Language Learner student population has more than tripled, going from 77 students in 2000 to 165 students in 2010 to 265 students in 2015. Fulton, Sageville, and Marshall have experienced more than a 300% increase in ESL students; Bryant, Carver and Table Mound have increased by more than 100%. 74% of ESL students in the DCSD in 2015 were Latinx (53 students) or Marshallese (126 students). The third largest group is Chinese (13 students). With respect to hearing and vision difficulties, the American Community Survey American Communities Survey data for 2011-15 estimates that there are approximately 2,224 people with a hearing impairment and approximately 1,268 with a vision impairment. Estimates were obtained through contacts with the following regional services: -135- https://bostico.com/translator/cedar_rapids.html https://iowainternationalcenter.org/what-we-do/interpretation/ http://www.translationsunlimited.com/ At a cost of 14 cents per word, a standard tri-fold brochure can be translated into one other language for approximately $100. Based on our experience with community members from various language groups mentioned, we propose an ongoing budgeted amount of$500 per year to translate brochures and fliers into the top three language groups with whom we have regular contact, adjusting as circumstances change. We will focus on our most critical brochure and fliers describing department services and/or programs. Using the standards for Iowa court interpretation and our past experience paying interpreters, interpretation costs average $40 per hour for sign and language interpreters. We have estimated interpretation costs of$1,500 per year based on our experience with interpretation requests to date for our department's services. Related Cost: $ 2,000 Tax Funds Recurring Recommend -Yes Property Tax Impact: $ 0.0008 0.01% Activity: Engineering Administration Significant Line Items Employee Expense 1. FY 2019 employee expense reflects a 1.5% wage package increase. 2. The Iowa Public Employee Retirement System (IPERS) City contribution increased from 8.93% in FY 2018 to 9.44% in FY 2019. This resulted in an increase of City (PERS expense of$10,670 in Engineering. The employee contribution increased from 5.95% in FY 2018 to 6.29% in FY 2019. 3. The City portion of health insurance expense is decreased from $1,325 in FY 2018 to $1,193 in FY 2019 per month per contract which results in an annual cost savings of -$38,141 or-10.00%. 4. Overtime is unchanged from $59,500 in FY 2018 to $59,500 in FY 2019. FY 2017 actual was $61,938. 5. Sick leave payout expense decreased from $7,540 in FY 2018 to $819 in FY 2019. 6. During FY 2016, the City Council approved a limited term Engineering Technician position to assist with construction inspections on the Bee Branch Project. This position expired July 2017. The employee expense related to this position is eliminated in full in FY 2019 eliminating -0.06 FTE at a savings of$4,900. 7. A Traffic Engineering Assistant position is tentatively unfrozen effective March 1, 2019 at a cost of $29,788 in FY 2019 ($91,302 in FY 2020). Supplies & Services 8. Consultant Services decreased from$460,397 in FY 2018 to $117,500 in FY 2019. Stormwater Maintenance increased from $26,397 in FY 2018 to $47,000 in FY 2019. NPDES consultant services decreased from $230,000 in FY 2018 to $30,000 in FY 2019. Stormwater I&I Prevention decreased from $200,000 in FY 2018 to $10,000 in FY 2019. Stormwater ditch remediation decreased from $40,000 in FY 2018 to $25,000 in FY 2019. Storm Sewer Inspection and Cleaning decreased from $25,000 in FY 2018 to $6,500 in FY 2019. All of these activities are mainly completed by employees, reducing the need for consultant services. -136- 9. Inspection Reimbursement increased from $48,000 in FY 2018 to $72,000 in FY 2019 based on the completion of three subdivisions that require reimbursement of inspection fees paid that weren't used, per contract. Completion of the following subdivisions is anticipated in FY 2019: English Ridge, Katrina Circle, Rustic Point, South Pointe, and Timer-Hyrst Estates. 10. Pay to Other Agency increased from $104,332 in FY 2018 to $110,675 in FY 2019. This line item represents the contract with East Central Iowa Association for transportation planning which increased $11,000 (from $9,000 in FY 2018 to $20,000 FY 2019), the refund of the Dubuque Historical Society lease ($44,799), and the Catfish Creek Watershed Partnership payment ($44,532). 11. Grant expense increased from$351,681 in FY 2018 to $385,047 in FY 2019. This line item is the stormwater enterprise fund subsidies for low income households ($17,461), residential farms ($9,173), and property tax-exempt properties ($320,047), as well as streambank rehabilitation grants ($5,000). The increase represents the planned increase in the Stormwater User Fee in FY 2019. There are 119 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 20 customers that receive the residential farm subsidy and there are 387 customers that receive the low income subsidy. 12. Sales Tax increased from$130,991 in FY 2018 to $134,391 in FY 2019 based on increased stormwater rates in FY 2019. This expense is directly offset by sales tax revenue. 13. Software License decreased from$127,926 in FY 2018 to $119,514 in FY 2019 based on expenditures that have been delayed for the TACTICS software, Milestone expenses for additional cameras, and a change to bi-annual payment for sequel database management. FY 2017 actual was $56,902. 14. Property Tax increased from $88,120 in FY 2018 to $98,500 in FY 2019. FY 2017 actual was $82,186. This line item represents the property taxes paid on property that the City leases to other entities and is offset by lease revenue. 15. Education and Training increased from$42,360 in FY 2018 to $45,881 in FY 2019. $1,200 was added for the Traffic Engineer in FY 2019. 16. Machinery and Equipment Maintenance decreased from$47,573 in FY 2018 to $40,835 in FY 2019 based on a three-year average expense. FY 2017 actual was $24,142. Machinery& Equipment 17. Equipment replacement items at the maintenance level include ($509,967): Enaineerina Administration Chairs/Desks $ 1,000 Label Maker $ 200 Smart Phone $ 750 Project Engineering General Fund Digital Cameras (1) $ 200 ASTM Manuals $ 1,000 Desks/Chairs $ 1,000 Slump Cones (4) $ 1,600 -137- Topcon GPS Rover $ 5,500 Auto Levels $ 300 Motorola Radius Radios $ 1,000 2010 Ford F-150 (Survey Crew) $ 38,000 Radio for Truck $ 4,500 Security Cameras $ 4,300 Smart Phone (8) $ 3,000 Cell Phone (2) $ 120 Traffic Engineering Road Use Tax Fund Zoom Camera $ 800 PTZ Cameras (5) $ 16,000 Waterproof Camera $ 400 Milestone Video Server (1) $ 30,000 Virtual Servers (1) $ 8,000 Firewall $ 10,000 Archive Video Servers (2) $ 24,000 Hardened Intersection Switches $ 39,000 EMC Server $ 25,000 Axis Server (10) - Replaced w/Cameras $ 6,500 Tactics Laptop $ 3,000 Matrix Switch $ 10,000 Pre-Emption Equipment $ 5,000 Cell Phone (1) $ 60 Milestone CPU (2) $ 6,000 ITER IS Cameras (2) $ 9,600 Axis Cameras (35) $ 48,000 Batteries (50) $ 12,000 Battery Back-Up Systems (4) $ 25,000 LCD Monitors 70" $ 5,000 Wireless Secure Access Field Equipment $ 10,512 Traffic Counters (3) $ 4,500 Smart Phone (1) $ 375 Project Engineering Sanitary Sewer Fund Truck Radio Units (2) $ 4,500 Weather Station $ 650 Gas Air Meter (4) $ 400 General Sanitary Sewer Repairs/Maintenance $ 75,000 Field Equipment $ 500 Smart Phone $ 750 Project Engineering Stormwater Fund Rain Gauges $ 900 Smart Phone (2) $ 750 General Stormwater Repairs/Maintenance $ 25,000 Recommended Improvement Packages $ 40,300 Total Equipment $ 509,967 -138- Debt Service 18. Debt Service payments for FY2019 are as follows ($5,699,131): Final Call Amount Debt Series Source Purpose Payment Date $ 23,787 2009A G.O. Sales Tax 30% Fiber Optic & Street Light 2029 2025 $ 191,850 2009A G.O. Stormwater Fees Stormwater Improvements 2029 $ 878,458 2009C G.O. GDTIF/General America's River Project 2021 2025 $ 438 2010A G.O. Sales Tax 30% Street Improvements 2030 2025 $ 55,550 2006 SRF Stormwater Fees North Catfish Creek 2030 $ 126,548 2009 SRF Stormwater Fees West 32nd Detention Basin 2030 $ 73,591 2011 A G.O. Sales Tax 30% Southwest Arterial 2031 2018 $ 163,534 2011A G.O. Stormwater Fees Stormwater Improvements 2031 2018 $ 131,532 2012B G.O. Stormwater Fees Stormwater Improvements 2031 2020 $ 9,469 2012D G.O. Sales Tax 30% FEMA Flood Buyout 2027 2019 $ 29,900 2012D G.O. Stormwater Fees Stormwater Improvements 2033 2019 $ 82,384 2012E G.O. Sales Tax 30% Southwest Arterial 2032 2018 $ 9,049 2012E G.O. Stormwater Fees Stormwater Improvements 2032 2018 $ 413,377 2010 SRF Stormwater Fees Lower Bee Branch 2032 $ 323,100 2014A G.O. Sales Tax Increment Bee Branch Watershed 2029 2024 $ 53,150 2014B G.O. Sales Tax 30% Street Improvements 2034 2021 $ 63,200 2014 SRF Sales Tax 30% Lower Bee Branch 2034 $ 1,476,461 2015B SRF Sales Tax Increment Upper Bee Branch 2035 $ 762,650 2015A Revenue Sales Tax Increment Bee Branch Watershed 2029 2026 $ 730,200 2016B G.O. Sales Tax 20% Stormwater Refunding 2036 2024 $ 18,562 2016C G.O. Stormwater Fees Federal Building Roof 2037 2024 $ 82,341 2018 SRF Stormwater Fees Bee Branch Watershed 2038 $ 5,699,131 Total Engineering Debt Service Revenue 19. Riverfront Leases increased from $1,855,361 in FY 2018 to $2,025,658 in FY 2019 based on the projected revenue which is as follows: Lease FY18 Budget FY19 Budget Artco Fleeting Service $ 1,200 $ 1,200 Colleen Bradley Lindstrom $ 3,600 $ 3,600 Dubuque Historical Society $ 44,799 $ 45,695 Dubuque Marina $ 31,084 $ 31,033 Dubuque River Rides $ 12,500 $ - Dubuque Terminals - South Port Inland $ 13,900 $ 13,900 Dubuque Terminals Dove Harbor $ 120,501 $ 119,500 Dubuque Yacht Basin $ 24,549 $ 24,392 Flint Hill Resources $ 663,000 $ 670,000 Freebird II, LLC - Lease 2 $ 6,792 $ 6,792 Freebird III, LLC $ 107,100 $ 58,000 -139- Lease FY18 Budget FY19 Budget Hawkeye Truck &Trailer $ 20,160 $ 20,563 Hodge Company $ 6,548 $ 2,183 Hodge Transit VVarehouse Co $ 12,000 $ 236,700 Klauer Manufacturing $ 100 $ 100 Riverboat Twighlight $ - $ 6,000 Gavilon - Land By City Salt Pile $ 259,312 $ 259,000 Gavilon Dove Harbor $ 528,216 $ 527,000 Total $ 1,855,361 $ 2,025,658 20. Wharfage Fees on Leased Property increased from$105,000 in FY 2018 to $117,000 in FY 2019 and is dependent on how much business is being conducted at the Wharf. Lease FY18 Budget FY19 Budget Freebird II, LLC - Lease 2 $ 20,000 $ 19,500 Gavilon Dove Harbor $ 55,000 $ 65,000 Gavilon - Salt Site $ 12,000 $ 12,500 Flint Hill Resources $ 18,000 $ 20,000 Total $ 105,000 $ 117,000 21. Non-Riverfront Lease decreased from $194,612 in FY 2018 to $171,751 in FY 2019. Lease FY18 Budget FY19 Budget ABC Building $ 47,271 $ 47,271 Dubuque Rescue Mission $ 1 $ 1 HHH Enterprises $ 2,052 $ 2,052 Hartig Drug $ 1,763 $ 1,808 16th St. Detention Basin - Rainbo Oil $ 121,925 $ 120,619 Mobile One & Horizon Small Cell $ 21,600 $ - Total $ 194,612 $ 171,751 22. Stormwater Penalties decreased from$26,000 in FY 2018 to $25,719 in FY 2019 based on FY 2015 actual of$24,936 plus 1%. 23. The FY 2019 Stormwater User Fee is increased from $7.27 per SFU to $7.76 per SFU, a 6.75% 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. -140- c \ \ co a � / - \ � LU _ § \2 e — ® % / I �| _ I CL _ _ � 10 / / 0 1.11 CU CD _ 03 co { \ ( zFto_c - - - \ f \ CU e f = /\ \ j2 0 Ea % Q ° ¢ al 2 ) j ) I I I I I | C ƒ | . = — ! cr $ — c CU w - >) Q ± _ { - 2 [ \ - ! { e / - ! 3 ] f7, ttO $ «U I47 J - \ / LLI a)e ® e e \ U, } | | | | | \ k _ f § un / \ [ \) /} \ ƒ} I I I This page intentionally left blank. -142- 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. Engineering I I - I I Administration Right-of-Way Stormwater Sanitary Sewer Traffic and Special Management Management Collection Engineering Projects and Streets SUCCESS IS ABOUT PLANNING, PARTNERSHIPS AND PEOPLE LEADING TO OUTCOMES PEOPLE PLANNING Engineering continues in its Engineering coordinates its project emphasis on public information planning with multiple City Departments. meetings concerning projects that In addition the department is involved in have a significant impact on the Dubuque Metropolitan Area property owners. These meetings Transportation Sa provide an opportunity for East Central Intergovernmentaltudyndworks Agencywiththe meaningful exchange between the in planning projects. This ensures a City and property owners on the regional view is considered in project project scope and its impact. development. 47144. 111 gi PARTNERSHIPS 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 Corrrnission. Neighborhood Groups. Tri-State Trail Vision and many other entities when planning and constructing projects -143- ENGINEERING DEPARTMENT Resources $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $0 O,Perati:n0 Re�en Pdm\�\strati�ve Recharges Road use tiax Stocmwater Sa6t.a'N Sewer FY 2017 FY 2018 FY 2019 The Engineering Department is supported by 30.23 full-time equivalent employees, which accounts for 57.75% of the department expense as seen below. Overall, the department's expenses are expected to increase by 37.95% in FY 2019 compared to FY 2018. $3,196,677 Employee Expense $2,911,988 $2,971,268 $1,326,307 Supplies and Services $1,680,075 $1,386,616 $413,212 Machinery and Equipment $445,350 $509,967 $— Construction Fund $— $1,525,000 $499,607 Administrative Overhead Charges $470,674 $469,385 $0 $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 $3,000,000 $3,500,000 FY 2017 FY 2018 U FY 2019 -144- ENGINEERING DEPARTMENT Activity: Right-of-way Management and Streets Right-of-Way Overview Right-of-way (ROVV) is land which is owned by the City to provide a defined area for essential facilities and services for all such as transportation, communication, water, sewer, power in order to provide, sustain, enhance and develop a progressive, safe community. Typically, the width of public ROW is 50, 60, or 64 feet, although other widths may occur. Right-of-Way Management involves monitoring the public right-of-way for approved, and prohibited, activities and placements; excavations for utilities, sidewalks and driveways - inspections, installations, appeals, repairs of new and replacements; dumpsters, sidewalk cafes, retaining walls, snow clearing, easements, accessibility and licenses of encroachment. This activity also includes the maintenance of records of above activities for compliance of right-of-way access and amenities. Utility Locate Service Overview The Engineering Department provides locates for City-owned utilities as part of the Iowa One Call locate service. These utilities include water main, sanitary sewer, storm sewer, electric and fiber optics. The goal of the Iowa One Call locate service is to minimize the risk of damaging any type of underground facilities. The City responds to approximately 7,000 locate requests per year. In order to accurately respond to One Call requests, the Engineering Department uses surveying and GIS equipment to map the locations of existing and newly constructed infrastructure Streets Overview Street activity involves planning, inspection and reconstruction and major maintenance for streets and alleys. The City maintains a pavement management system which contains a ranking and condition which helps to identify the Capital Improvement Projects for next 5 year period. The projects are designed to accomplish goals of sustainability, mobility, affordability, constructibility and long lasting results as well as be in compliance with the latest standards and specifications, federal, state and local regulations. Assessable projects for reconstructions are prepared by this Activity. This activity is highly called upon during emergency events and crises.Agency involvement may include Iowa Department of Transportation (IDOT), State Historical Preservation Office (SH PO) and various railroads. Right-of-way and Streets Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $2,830,718 $2,327,109 $2,275,199 Resources $2,263,894 $1,514,659 $1,412,258 -145- ENGINEERING DEPARTMENT Right-of-way and Streets Position Summary FY 2019 City Engineer 0.25 City Engineer-Service Fund 0.25 Assistant City Engineer 0.25 Assistant City Engineer-Svc Fd 0.75 Project Manager 0.40 Project Manager- Service Fund 0.10 Civil Engineer II 0.95 Civil Engineer II -Service Fund 1.55 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.90 Engineering Assistant II 1.00 Engineering Assistant II -Service Fd 0.50 Surveyor 0.80 Surveyor-Service Fund 0.20 Engineering Aide 0.50 Engineering Aide-Service Fund 1.00 Traffic Engineer 0.60 Traffic Engineer- Service Fund 0.40 Confidential Account Clerk 0.25 Confidential Account Clerk- PT 0.35 Secretary-Admin 0.25 Secretary-Admin Internal Svc 0.25 Utility Locator 0.00 Total FT Equivalent Employees 16.3 Highlights of the Past Year Southwest Arterial • English Mill Road reconstruction (657) project was substantially completed in June 2017. Current cost is approximately $3.9 Million. • Military Road reconstruction (664) project is currently under construction and is approximately 50% complete. Cost projection $5.2 Million. • US20 / Seippel interchange WB Ramp D bridge was substantially completed in August 2017. Current cost is approximately $853,000. • US20 / Seippel interchange WB Ramp D paving was substantially completed in October 2017. Current cost is approximately $850,000. -146- ENGINEERING DEPARTMENT • Menards Frontage Road (37) project is currently under construction and is approximately 30-40% complete.Work will continue during the 2018 season. Cost projection $8.8 Million. • US20 / Seippel interchange grading (38) project is currently under construction and is approximately 90% complete. Cost projection $6.4 Million. • West grading (25)project, from English Mill to Catfish Creek is currently under construction and is approximately 80% complete. Cost projection $8.8 Million. • East grading (36) project, from Catfish Creek to US61-151 is currently under construction and is approximately 70% complete. Cost projection $6.7 Million. • US 20 Interchange, Eastbound Ramp C Bridge (237) bids in December 2017. • US 20 Mainline Dual Bridges Over Catfish Creek (211) bids in December 2017. • Southwest Arterial Overpass Bridge Over US Highway 20 (42) bids in December 2017. • US61-151 Elmwood Drive Bridge Over Granger Creek (41) bids in December 2017. Notable Project Accomplishments • Construction of the Grandview-Delhi-Grace Roundabout • Deck rehabilitation of 3 bridges. This included Cedar Cross Road, Old Mill Road and Fremont Avenue bridges. • Reconstruction of 22 alleys into Green Alleys. • Chavenelle Road and NW Arterial intersection left turn lane improvements. • Completion of the NW Arterial Hike/Bike Trail Phase 5 from Holliday Drive to Chavenelle Drive, including sidewalk work to open the other end of the bridge at Bergfeld Pond Recreation Area. • Provided construction inspection services on private subdivision developments, including; South Pointe; Rustic Point; Timber-Hyrst; and English Ridge. • Reconstruction of 17th Street from Pine Street to Washington Street is currently under construction (HUD Resiliency Project) Future Initiatives • Continue with construction and the completion of the Southwest Arterial in December2019 • Resurfacing of US 52 / Central Avenue Phase 4, between 9th and 21st streets • Initiate final engineering and property acquisition phase for the University Avenue overlap area as part of the East-West Corridor improvements. • Design and construction of Kauffmann Avenue from Central Avenue to Kane Street (HUD Resiliency Project) • Design and construction of 17th Street from Elm Street to West Locust Street (HUD Resiliency Project) • Design and construction of W. Locust Street from 17th Street to Foye Street (HUD Resiliency Project) • Design rehabilitation improvements for Chavenelle Road from NW Arterial to Radford Road. -147- ENGINEERING DEPARTMENT Performance Measures Right-of-Way Management -Activity Statement Manage the public right of way so that it is safe and accessible for all users. Streets -Activity Statement Construct and maintain streets in a fiscally responsible way to also provides for safe and efficient transportation for all users. ` Goal: Connected Community Outcome #1: Provide safe walking pathways throughout the City, including pedestrian access ramps Citizen Impact: «. Staff react to complaints concerning sidewalks and ramps. ' Staff also proactively inspect pedestrian corridors to ensure }''' people of all abilities have access. By making sure pedestrian facilities meet current standards, it minimizes the chance of people tripping and making travel easier for people with disabilities. ©idl'I'2014 II:29 Sidewalk not shoveled Did you know? In 2017 the City of Dubuque sent out 434 notices to properties due to either defective sidewalks or failure to shovel the sidewalk. Many Dubuque residents have mobility issues. Pedestrian access ramps that are constructed correctly, improve the accessibility of these limited mobility individuals. When the City resurfaces or reconstructs streets, the access ramps are evaluated and upgraded to meet current American with Disability Act requirements. • ® r. • 0-P0/2013 03 25 y11• 11r00792QdJ011 19:2E .. Cracked and heaving sidewalk-TripHazard New Enhanced Sidewalk on Asbury Road -148- ENGINEERING DEPARTMENT Goal: Great Place to Live Outcome #2: Manage the work in right of way permits. Citizen Impact: ' A . Y, r f If work in the right of way is not managed, the City may not have information on the type of pavement repair that may have occurred, if the utility is buried at the correct depth, j �° �. 'Li . does the contractor have proper insurance, etc. The City4.07,: - manages all right of way excavations by issuing permits to ,L work in the right of way. The permits are tracked in a central database that allows multiple departments to see what work may have occurred and who performed the work. This ensures every department has the same information. mergency TTa er main repair in e win er Did you know? The City holds monthly coordination meetings with all utilities to help coordinate all utility work that may occur in the right of way. This coordination effort helps with minimizing the amount of excavations that may occur in a given area and reduces the inconvenience to the public. There were 235 excavation permits and 219 driveway/sidewalk permits issued in 2017. The Engineering Department adopted a new excavation policy so that damage to City streets and other infrastructure is minimized. The Engineering Department responds to approximately 7,000 Iowa One Call locate requests per year to locate City-owned utilities which include water main, sanitary sewer, storm sewer, electric and fiber optics. A;)Goal: Connected Community Wil. Outcome #3: Provide complete, safe and efficient street systems Citizen Impact: By constructing streets that utilize perpetual pavements, we create a strong transportation network that minimizes the inconvenience to the traveling public and reduces long terms costs. The current average condition rating for all streets in Dubuque is 78 on a scale of 100. The objective is to increase the street rating each year. `� 4 r Did you know? - - - The City of Dubuque has over 300 centerline miles of streets. All of these streets were scanned in the fall of 2013 and again in the fall of 2015. The Engineering =� Department entered all of this data into a pavement management system so the street degradation can be .%%144%4 ' measured and future maintenance can be planned based on the objective data. Pavement Scanning Van-Measures Smoothness and cracking -149- ENGINEERING DEPARTMENT J V _ --- 'lr" / _._ - N Installation of Geogrid over joints New Asphalt Interlayer Installed.Reduces Cracking Did you know? iIl IIS,BBBEBCO, JO The City has a Complete Streets Policy that I was adopted in 2011. As part of that policy, all street reconstruction projects must attempt to 1 " y.._ make the street as complete as possible. This i includes accommodations for vehicles, Ill transit, bicycles and pedestrians. Recent projects following the policy include the Historic Millwork District Complete Streets Project, the 9th and 11th Street One-way to =� _ Two-way Conversion Project and the Elm _T r Street Reconstruction Project (9 to 12thrr--rf Streets). The City also has a pavement 't 7 7/i ;- ,_ -I ' -1- ; ,--'--. ' marking fund that can be used toward bike Bike Lanes on Jackson Street lanes and shared bicycle area markings called "sharrows". Additionally, there is a fund F; , for enhanced cross-walks to help in school areas and other high traffic pedestrian zones. Did you know? The City is actively trying to expand the amount of hike/bike trails available to citizens. "a To date the City has constructed 9.97 miles of trails since 1999. Bike Sharrows on 10th Street -150- ENGINEERING DEPARTMENT Activity: Stormwater Management Overview 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. Projects range from the construction of new detention basins and the extension of storm sewer systems to the rehabilitation of existing storm sewer systems. Programs range from ditch, storm sewer, and detention basin maintenance to limiting pollutants associated with stormwater runoff. Major projects include the twelve phases of the Bee Branch Watershed Flood Mitigation Project (Carter Road Detention Basin, W. 32nd Street Detention Basin, Bee Branch Creek Restoration, Green Alley/Impervious Pavement Reduction, etc.), storm sewer redesign and construction in conjunction with street reconstruction projects, and the replacement/extension of storm sewer systems to address specific drainage issues. Stormwater Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $5,557,847 $4,226,889 $5,293,341 Resources $5,557,847 $4,226,889 $5,293,341 Stormwater Position Summary FY 2019 Civil Engineer II 0.15 Civil Engineer II -Service Fund 1.25 City Engineer 0.10 City Engineer-Service Fund 0.10 Engineering Technician 0.95 Engineering Technician- Service Fd 1.70 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.48 Confidential Account Clerk-Service Fd 0.75 Total FT Equivalent Employees 8.48 -151- ENGINEERING DEPARTMENT Highlights of the Past Year • Entered into a funding agreement with the Iowa Economic Development Authority (IEDA) establishing that the City will receive $23.1 million in HUD National Disaster Resiliency Competition grant funding for Phase 7, Phase 8, and Phase 12 of the Bee Branch Watershed Flood Mitigation Project; • Completed construction of the Lower Bee Branch Creek Restoration Project (Phase 4 of the Bee Branch Watershed Flood Mitigation Project) floating island and basin overlook improvements; • Completed construction of upper Bee Branch Creek Restoration Project (Phase 7 of the Bee Branch Watershed Flood Mitigation Project) from the railroad tracks south of Garfield Ave. to Comiskey Park north of 24th Street; • Entered the final design stage of the Bee Branch Creek Railroad Culverts Project (Phase 7 of the Bee Branch Watershed Flood Mitigation Project). This segment of the Bee Branch Creek Restoration Project involves the installation of culverts through the Canadian Pacific at 506 Garfield Avenue. • Initiated the design phase of the 22nd St/Kaufmann Ave Storm Sewer Improvements (Phase 8 of the Bee Branch Watershed Flood Mitigation Project) that will result in up- sizing the storm sewer, relocation of utilities, and complete street reconstruction from Elm Street to Kane Street; • Initiated environmental cleanup activities on the property to house the Bee Branch Flood Mitigation Maintenance Facility (Phase 9 of the Bee Branch Watershed Flood Mitigation Project); • Initiated the design phase of the 17th St.NV.Locust St. Storm Sewer Improvements (Phase 12 of the Bee Branch Watershed Flood Mitigation Project) that will result in up- sizing the storm sewer, relocation of utilities, and complete street reconstruction along 17th Street from the Bee Branch Creek to W. Locust Street and continuing up W. Locust towards Kirkwood Street as funding allows; and • Started construction of the first segment of the 17th St.NV.Locust St. Storm Sewer Improvements (Phase 12 of the Bee Branch Watershed Flood Mitigation Project) along 17th Street from Pine Street to Washington Street. Future Initiatives • Engineering design of the Bee Branch Flood Control Pumping Station Gates and Primary Electrical Service Replacement Project (Phase 5 of the Bee Branch Watershed Flood Mitigation Project); • Construction of the Bee Branch Railroad Culverts Project (Phase 7 of the Bee Branch Watershed Flood Mitigation Project); • Construction of the 22nd St/Kaufmann Ave Storm Sewer Improvements Project (Phase 8 of the Bee Branch Watershed Flood Mitigation Project); and • Construction of the 17th StNV. Locust St Storm Sewer Improvements Project (Phase 12 of the Bee Branch Watershed Flood Mitigation Project). -152- ENGINEERING DEPARTMENT Performance Measures Stormwater Management -Activity Statement Provide a storm and surface water system that protects the health and safety of citizens, controls damage from storms, and protects the environment. Goal: Great Place to Live Outcome #1: Engineer, construct, and maintain facilities to mitigate the effects of flooding The Engineering Department continues to analyze Ir.�r „��.. , various segments of the public drainage systems in order to identify improvements that will mitigate the effects of flooding. When deficiencies are identified, improvements throughout the entire watershed are d`" considered. Some drainage issues involve hundreds $, of properties, both public and private. In order to address these issues, the entire watershed must be considered and sometimes major drainage i ,- LI improvements are appropriate. ._ .4 Basement flooding high water mark on water heaters Citizen Impact: ,. -r-.' While most homeowners can install gutters and _ downspouts and install landscaping that forces water = - to flow away from their house, sometimes they can " T be powerless to protect their home from flooding - flooding that inundates water heaters, furnaces, and - electrical boxes, and can cause fires. Street flooding on 22nd Street Did you know? Flood disasters have repeatedly impacted residents and businesses (over 1 ,370 properties) in the Bee Branch watershed. Between 1999 and 2011 , six Presidential Disasters have issued due to the damage estimated at $70 million caused by the flooding. Major Project Bee Branch Creek Restoration Project ' _ -, ,,x The Bee Branch Creek Restoration involves ,li, - - , xP ., -_ . replacing almost a mile of storm sewer with a iiF , •'4=' creek and floodplain through an area where the w� -- '`' -$:, = Bee Branch/Couler Creek once flowed a 100 ` , years ago. This "day-lighting" of the buried - .-'''creek allows stormwater to safely move through 'the area without flooding adjacent properties. _ During heavy rains, stormwater rises out of the %, - -creek and fill the green space instead of r j - = I flooding streets and homes. The project r represents two phases of the Bee Branch Bee Branch Creek between 22nd and 24th Streets Watershed Flood Mitigation Project that when complete will prevent an estimated $582 million in damages over the coming century. -153- ENGINEERING DEPARTMENT 1 �Goal: Connected Community Outcome #2: Design and oversee construction of street/public right-of-way drainage systems to mitigate flooding and make the street available to the public during a rain event. Drainage systems are designed to strike a balance between initial capital costs, maintenance costs, and public protection with consideration given to public safety, environmental protection, and need for maintenance. Storm sewers are evaluated and typically reconstructed in conjunction with a street reconstruction project. Storm sewer improvements are also evaluated throughout the City as issues arise. These improvements are prioritized with funding programmed into the five- year Capital Improvement Program budget. Citizen Impact: Street drainage systems allow general traffic and emergency vehicles to safely utilize the street to travel through the community. Did you know? Streets themselves function as part of the overall stormwater drainage system. Curb and gutter sections collect stormwater and direct it to storm sewer intakes which allow the runoff to enter into the underground storm sewer pipes. CD( Goal: Sustainable Environment /11(14 Outcome #3: Maintain or improve the quality of stormwater runoff in accordance with the federal Clean Water Act. After it rains, the streets look cleaner -- and that's a problem. Stormwater rushing over paved surfaces picks up everything from oil to pesticides to sediment and then flows, either directly or via a storm sewer, into the Bee Branch, Catfish Creek, and Mississippi River. The pollutants in stormwater can lead directly to fish kills and unsafe conditions for citizens. oiiiiiiiti e ii , .if ' • • ' . * .' AI .4',.' , 1., .- *-; Silt fence failure allowing sediment to leave a construction site Sediment deposition clogging a storm sewer inlet Did you know? According to the U. S. Environmental Protection Agency, stormwater runoff is the #1 source of surface water pollution. -154- ENGINEERING DEPARTMENT Outcome#4: Help mitigate the potential for pollution and flooding due to the development of private property. The City of Dubuque has ordinances and associated policies in place to mitigate increased runoff typically associated with land development or land use changes. Development and redevelopment plans are reviewed and construction sites are inspected to ensure compliance with applicable ordinances and policies. Activity: Sanitary Sewer Collection Overview The City of Dubuque's Sanitary Sewer Collection system serves just less than 30 square miles of contiguous property with approximately 300 miles of piping and over 7,000 manholes. With roughly 21 ,000 private connections from homes and businesses, the public 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. Collection system improvements are managed by the City's Engineering Department under the City Engineer. Operations and maintenance of the collection system are managed by the W&RRC and the Public Works Departments. Funding for operations, maintenance, and improvement projects is generated via revenues collected during monthly billings of private and public users. The funds are collected and maintained in an Enterprise Fund and are only available for work directly associated with the sanitary sewer collection system. Sanitary Sewer Collection Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $211,925 $464,176 $517,349 Resources $211,925 $464,176 $517,349 Sanitary Sewer Collection Position Summary FY 2019 City Engineer 0.10 City Engineer-Service Fund 0.20 Civil Engineer II 0.10 Project Manager 0.10 Project Manager-Service Fund 0.15 Engineering Technician 0.05 Engineering Technician -Service Fund 1.50 Survey Party Chief-Service Fund 0.30 Survey Technician - Service Fund 0.30 Secretary 0.25 Secretary-Service Fund 0.25 Confidential Account Clerk 0.25 Confidential Account Clerk- Svc Fund 0.15 Utility Locator 0.25 Total FT Equivalent Employees 3.95 -155- ENGINEERING DEPARTMENT Highlight of the Past Year • Maintained compliance with the 2011 Consent Decree among the City of Dubuque, the U.S. Department of Justice, the U.S. Environmental Protection Agency, and the State of Iowa. The stated purpose of the Consent Decree is for the City of Dubuque to take all necessary measures to achieve full compliance with the federal Clean Water Act, Iowa water Pollution Control Laws, and the City's NPDES Permit. The City's goal is to eliminate all sanitary sewer overflows. • Completed the rehabilitation of over 6,200 lineal feet of sanitary sewer along with 55 manholes in accordance with the Consent Decree. This work further reduces instances of extraneous, non-stormwater from inflowing or infiltrating into the sanitary sewer collection system. Future Initiatives • Continued use of the sanitary sewer SCADA system to monitor for increased flows to the system and ward off potential overflows. • Continue successful inflow and infiltration reduction measures including sewer pipe rehabilitation and replacement; manhole rehabilitation and replacement; and source detection through inspection and flow metering. • Construction of the Kerper Boulevard Sanitary Sewer Project. • Construction of the sanitary sewer extension to serve the Derby Grange Road area. • Reconstruction of the Marquette Place sanitary sewer system. Performance Measures Sanitary Sewer Collection -Activity Statement Define and implement capital improvements to improve the City's existing sanitary sewer collection infrastructure and provide direction and standards for future expansion and connections to the system. @C Goal: Sustainable Environment Outcome#1: Reduce inflow and infiltration (181) into the sanitary sewer collection system and work to eliminate the source or secure the sanitary sewer from the source The City continues to develop and further refine a sophisticated computer model of the sanitary sewer system to help assess the necessary capacity of various sewer elements. Sewers found to have insufficient capacity are then scheduled for replacement, and if possible, done as part of a street reconstruction project. Over the years, the City has also developed an Inflow and Infiltration (I&I) Program to help eliminate storm water inflow and groundwater infiltration into the City's sanitary sewer collector system. In addition to replacing segments of the sewer system where l&I is evident, the City also rehabilitates these sewers and manholes through a process that requires no excavation. Instead, a liner is placed inside the existing pipe, resulting in what amounts to a brand-new pipe. -156- ENGINEERING DEPARTMENT Outcome #2: Reduce incidents of Fats, Oils and Grease related SSO's through education, inspection, corrective action and enforcement Fats, Oils, and Grease (FOG) Program Implementing a fats, oils, and grease program is an '- 1 important part of the City's compliance with its Sanitary Sewer Capacity, Management, Operation and Maintenance Program (CMOM). The City's CMOM program was developed as part of a required submission under the terms of the Consent Decree entered into by the City, the State of Iowa, and the United States in 2011 . The primary objective of a FOG Program is to reduce incidents of FOG related SSO's through, education, inspection, corrective action, and enforcement. Oils and grease in a sanitary sewer lift station r Did you Know? ' When warm Fats, Oils, or Grease are poured down a drain it may appear that it would not clog a sewer, but when it cools it becomes a solid, coating the sewer pipe, and restricting 1 4-r -vri the flow of wastewater. This can lead to a sanitary sewer 6.1 -1,,overflow and sewer back-ups into homes and businesses. A Build up of grease in sanitary sewer pipe Outcome #3: Prepare for future expansion and sanitary sewer service needs v..4., r As the City grows through the development it,_;. �._�. , 6 of agricultural property or through �i`�'?�II .�a�.e„�, annexation, steps are taken to extend iotay�■�_�:� Now- sanitary sewer and water main to service r-!I ij' K 1.111 _:glia,rr ' those areas. The recent expansion of I { 1t to�;��,` (] k sanitary sewer south toward the airport Vel, i __ 7 - —, �■'wk . provides the City with the foundational part Mau 1 1/A424� • infrastructure needed for future utility �. n:a ai•"i • ill ��,„,,Novg.:, extensions to serve the Granger Creek Sewershed consisting of over 5,700 acres. 01 ;,+ ,,,, More recently, the City has undertaken the F•"��• it' •� ii �._., task of extending sanitary sewer to provide r�� J lime OM ":ilii_ :I, Tr service to developments off of Derby _ lf.-:' Grange Road. Map showing the area served by the extension of sanitary sewer to the Dubuque Regional Airport -157- ENGINEERING DEPARTMENT Activity: Traffic Engineering Overview 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. Agency involvement with IDOT, FHWA, State Bureau of Transportation Safety. Projects included Northwest Arterial Conduit/Fiber Project, Fiber along University Avenue, Grandview-Delhi-Grace Roundabout Project as well as, fiber maintenance and extensions, traffic cameras, traffic counts, and pavement markings. Traffic Engineering Funding Summary FY 2017 Actual FY 2018 Budget FY 2019 Requested Expenditures $19,039 $22,796 $71,782 Resources $2,550 $5,456 $8,117 Traffic Engineering Position Summary FY 2019 Confidential Account Clerk 0.25 Utility Locator 0.25 Traffic Engineering Assistant 0.87 Traffic Engineering Assistant-Svc Fd 0.13 Total FT Equivalent Employees 1.50 Highlights of the Past Year • During the 2017 year more than 10.5 miles of fiber duct was installed due in part to joint private/public agreements between the city and data providers. • Fiber conduit was installed along Chavenelle Road from NW Arterial to West of Radford Road (5,290 feet) and another 9,350 feet was installed connected Chavenelle Road to Sieppel Road (including ECIA and south to the business park. This will ultimately tie into US 20 and the SW Arterial. • Installation of fiber duct along Kerper Boulevard from 11th at Elm to Kerper at Hawthorne Street (11 ,650 feet - currently under contract). • Installation of 1 ,650 feet of fiber duct along Roosevelt Extension. • Rebuilt 5,600 feet of fiber conduit and 10,000 feet of fiber along US 20 from Wacker to Grandview Avenue. • Established a 5,280-foot run of fiber along Cedar Cross Road. From US 20 south to Cedar Cross Ct. • Constructed 900 feet of fiber and duct along Grandview Ave • Worked on acquisition of 25,000 feet of fiber conduit through the city from downtown to the west end. • Reconstructed traffic signals at Windsor and 22nd and at Windsor and Rhomberg Ave. • Grandview at Loras Traffic Signalization Reconstruction Project • Completion of Hwy 20 corridor microwave vehicle detection conversion. -158- ENGINEERING DEPARTMENT Future Initiatives • Continue work on safety grants • Reconstruction of traffic signals at Asbury and Carter and Asbury at Chaney along with a fiber inner-connect and ITS improvements. • Reconstruction of fiber optic route along US 20 from Devon Drive to Wacker Drive (near completion) • Installation of fiber and electrical duct along GrandviewAvenue from US 151 to Grandview at Delhi (under design) • Fiber maintenance and extensions • Traffic Camera maintenance and additions • Continued work on Dubuque's STREETS traffic management program. • Update Pavement Markings • Continued efforts to improve Dubuque's communications infrastructure through private/public partnerships to enhance bandwidth and redundancy and to promote economic growth. Performance Measures Traffic Engineering -Activity Statement Overseeing planning for the movement of pedestrian and vehicular traffic to ensure the City's transportation infrastructure is in a state of good repair for the purposes of public safety and the efficient movement of people, goods and services. Goal: Financially Responsible, High Performance Organization Outcome #1: Reduce energy and maintenance costs as well as increase safety by replacing existing street lights with LED lighting. This objective helps vehicles, bikes and pedestrians safely navigate the corridor by providing lighting that is evenly distributed. LED lighting is also more efficient and don't require the same maintenance as High Pressure Sodium Lights. The energy costs are reduced by 50% by using LED lights which last 15 years versus 5 to 6 years for high pressure sodium. High Pressure Sodium Lighting LED Lighting Did you Know?The City of Dubuque owns 2,188 street lights of which: • 1,379 are high pressure sodium • 7 are incandescent • 146 are metal halide • 656 are LED -159- ENGINEERING DEPARTMENT AQGoal: Improved Connectivity Wil. Outcome #2: Provide a road network that ensures a high level of safety for vehicles, cyclists, and pedestrians. Over the past couple of years the City of Dubuque has been installing microwave detection at intersections and continues to update several intersections each year. This system provides multiple benefits since it doesn't have to be replaced during roadway repairs and can detect vehicles and bikes. Did you know? Currently 32 intersections have microwave detection installed at them. Over the next year, the City of Dubuque is planning on installing them at 5 additional intersections. In the future microwave detection will be installed at the rate of 3 to 4 intersections a year. Microwave detection improves the efficiency of the intersection. It allows the intersection to be very reactive at night when the volume of traffic is down since it can detect vehicles that are 140 feet away which will minimize the time spent at these traffic signals. Outcome #3: Update traffic signalization infrastructure to Intelligent Transportation Systems (ITS) by providing improved levels of service and quicker response to signal and traffic control conditions and issues by connecting them to the Traffic Operations Center. 1111"115::- , •Intersection with microwave traffic detectors uninhibited by Closeup of a microwave traffic detector extreme weather conditions The system is interconnected by using fiber that connects to each intersection or key location and is connected into a switch to communicate to the equipment in the field. This allows the City of Dubuque make changes to the timings, detection or devices from the Traffic Operations Center. In case of unforeseen road closures in can be difficult to reach the intersections effected to make the necessary changes but could be made from the Traffic Operations Center and then sent to the equipment and can use cameras to monitor the situation. Citizen Impact: This updated infrastructure has allowed the Traffic Engineering staff the ability to react faster to changing traffic conditions. Currently there are six different traffic management plans for the US 20 corridor to move traffic. With the coordinated traffic control in this corridor delays have been reduced so -160- ENGINEERING DEPARTMENT traffic may only stop at one intersection during peak traffic. This is in contrast to previous years where vehicles would be delayed at multiple intersections. Outcome #4: Maintain and Seek new grants for Traffic Signal / Intersection Improvements. The City of Dubuque traffic engineering department has successfully received many grants in the last 14 years to assist with roadway improvements. In the last few years the engineering department has received grants for the following that will be constructed beginning in the Spring of 2018 through the Fall of 2018; • Grandview Ave at University Ave intersection improvements (roundabout proposed) • NWArterial at Pennsylvania westbound right turn lane improvement (planned for summer of 2018) • NWArterial at JFK eastbound right turn lane improvement. (planned for spring of 2018) Recently Constructed projects include • Grandview Ave at Loras Blvd signal reconstruction (completed fall of 2017) • Grandview Ave at Delhi Roundabout project (constructed in Summer of 2016) Citizen Impact: This improved infrastructure will allow citizens to get through these intersections quicker and more safely. These grants often times pay for a majority of the project at minimal cost to the tax payer. These improvements also help cut vehicle emissions which is better for the environment and health of the city. Outcome #5: Continued growth of traffic operation cameras and security cameras. The City of Dubuque now has over 1 ,009 security cameras with over 500 of these on the public streets. These cameras record events for 30 days and are commonly used for the following; • Observe traffic signal operations and allow engineers in the Traffic Operations Center to make changes to the signals remotely and view if the changes have the desired effect on traffic. • Used during accidents to determine what happed before/during/after the accident along with assignment of fault. • Used for investigations of criminal behavior. Citizen Impact: These cameras help improve the traffic signal timings and operations which help keep the signals and other transportation systems at optimal efficiency which minimizes daily commute times. They are also relied upon by police during accident investigations and many citizens request video evidence of their accident to assist them with their claim. These security cameras also keep the citizens safer by assisting law enforcement. Did you know? The Traffic department for the City of Dubuque currently has over 57 miles of conduit installed and 30.7 miles of fiber. This fiber is also used for other City entities including police and fire, sanitary sewer flow metering, and wireless water meter program. This fiber is also the critical communications pathway for the over 1 ,000 cameras located throughout the city. -161- This page intentionally left blank. -162- Recommended Operating Revenue Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY19 Recomm'd Fund Account Account Title Revenue Revenue Budget Budget 100 42170 MISC-LICENSES 3,358 1,989 2,500 1,700 100 42225 DUMPSTER PERMITS 5,555 6,115 6,000 7,000 100 42240 EXCAVATION PERMITS 16,709 21,802 12,000 14,000 620 42260 PERMIT, MISC 2,737 5,653 5,000 5,000 100 42305 SIDEWALK PERMIT 8,825 7,587 6,000 5,000 100 42315 SUBDIV. INSPECTION FEE 3% 3,768 40,421 3,768 40,421 42-LICENSES AND PERMITS 40,952 83,567 35,268 73,121 400 43110 INVESTMENT EARNINGS 0 4,356 0 0 620 43110 INVESTMENT EARNINGS 11,885 5,019 10,000 5,019 100 43230 LEASE, PROPERTY 137,629 138,301 194,612 171,751 100 43231 LEASE, RIVERFRONT 1,934,857 1,872,530 1,855,361 2,025,658 100 43233 SIDEWALK CAFE LEASES 400 800 400 1,000 100 43320 LEASE,WHARFAGE 115,649 150,345 105,000 117,000 100 43325 LEASE,OTHER 120 120 120 120 43-USE OF MONEY AND PROPERTY 2,200,540 2,171,471 2,165,493 2,320,548 400 44100 BAB SUBSIDY NON GRANT 1,765 1,274 1,765 0 620 44100 BAB SUBSIDY NON GRANT 14,563 14,106 14,563 14,106 44-INTERGOVERMENTAL 16,328 15,380 16,328 14,106 620 51215 PENALTIES 25,690 24,936 26,000 25,719 610 51245 SEWER CONNECTION CHARGES 0 71,960 0 0 620 51805 STORMWATER USER FEE 3,672,066 3,934,804 4,242,243 4,837,441 620 51820 STORMWATER HALF RATE 30,659 30,085 34,936 35,000 51 -CHARGES FOR SERVICES 3,728,415 4,061,785 4,303,179 4,898,160 100 53102 PRIVATE PARTICIPANT 0 89 0 0 100 53403 IA DISTRICT COURT FINES 45 180 45 50 800 53530 SPECIALIZED SERVICES 2,124,187 2,387,281 1,778,094 1,716,829 100 53605 MISCELLANEOUS REVENUE 792 653 792 0 100 53610 INSURANCE CLAIMS 16,675 0 0 0 100 53615 DAMAGE CLAIMS 343 4,218 5,142 4,350 100 53620 REIMBURSEMENTS-GENERAL 530 0 530 0 610 53620 REIMBURSEMENTS-GENERAL 0 9,613 0 0 620 53630 SALES TAX COLLECTION 125,767 134,749 130,991 134,391 53-MISCELLANEOUS 2,268,339 2,536,783 1,915,594 1,855,620 100 54105 LAND SALES 49,249 8,067 0 0 100 54107 VEHICLE SALES 0 7,000 0 0 400 54210 GO BOND PROCEEDS 0 3,527,719 0 0 620 54210 GO BOND PROCEEDS 6,270,000 2,012,204 0 0 400 54220 BOND DISCOUNT 0 113,630 0 0 620 54220 BOND DISCOUNT 354,303 64,814 0 0 54-OTHER FINANCING SOURCES 6,673,552 5,733,434 0 0 400 59100 FR GENERAL 560,675 552,573 566,747 544,127 620 59102 FR DRA DISTRIBUTION 0 0 0 251,141 400 59240 FR DOWNTOWN TIF 361,255 361,632 351,870 343,800 400 59250 FR ROAD USE TAX 7,466 7,208 21,267 23,787 620 59255 FR SPECIAL ASSESSMENT 0 94 0 0 400 59300 FR STREET CONSTRUCTION 217,110 220,290 210,097 209,125 400 59340 FR SALES TAX INCREMENT 1,056,091 1,560,984 2,067,597 2,562,211 400 59350 FR SALES TAX CONSTRUCTION 16,297 35,601 19,209 19,000 620 59350 FR SALES TAX CONSTRUCTION 0 333,830 346,681 118,906 100 59610 FR WPC OPERATING 105,996 242,877 330,040 291,095 100 59620 FR STORMWATER OPERATING 73,981 77,373 76,041 68,174 100 59640 FR WATER UTILITY 0 0 20,184 52,397 59-TRANSFER IN AND INTERNAL 2,398,871 3,392,462 4,009,733 4,483,763 55-ENGINEERING TOTAL 17,326,997 17,994,882 12,445,595 13,645,318 -163- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 61010 FULL-TIME EMPLOYEES 391,136 610,152 540,464 596,978 610 61010 FULL-TIME EMPLOYEES 20,313 70,578 61,764 75,619 620 61010 FULL-TIME EMPLOYEES 26,954 270,202 146,818 123,531 640 61010 FULL-TIME EMPLOYEES 0 740 0 14,054 800 61010 FULL-TIME EMPLOYEES 1,575,835 1,259,743 1,145,350 1,135,869 100 61020 PART-TIME EMPLOYEES 225 2,886 13,195 13,395 610 61020 PART-TIME EMPLOYEES 49 467 0 0 620 61020 PART-TIME EMPLOYEES 0 0 35,749 73,974 800 61020 PART-TIME EMPLOYEES 90,604 54,157 33,922 34,445 100 61030 SEASONAL EMPLOYEES 3,701 16,876 8,211 16,672 610 61030 SEASONAL EMPLOYEES 0 188 0 0 620 61030 SEASONAL EMPLOYEES 33 8,945 0 0 800 61030 SEASONAL EMPLOYEES 45,882 82,238 32,844 33,344 100 61050 OVERTIME PAY 9,707 5,923 5,250 5,250 610 61050 OVERTIME PAY 118 872 0 0 620 61050 OVERTIME PAY 45 6,031 0 0 800 61050 OVERTIME PAY 80,842 49,112 54,250 54,250 100 61091 SICK LEAVE PAYOFF 13,417 13,417 7,540 819 100 61092 VACATION PAYOFF 4,255 226 0 0 100 61310 (PERS 35,759 52,430 50,642 59,691 610 61310 (PERS 1,843 6,439 5,514 7,139 620 61310 (PERS 2,411 21,821 16,302 18,647 640 61310 (PERS 0 66 0 1,327 800 61310 (PERS 157,032 131,252 113,085 118,748 100 61320 SOCIAL SECURITY 30,930 44,096 43,961 48,434 610 61320 SOCIAL SECURITY 1,514 5,063 4,725 5,786 620 61320 SOCIAL SECURITY 1,953 18,283 13,965 15,110 640 61320 SOCIAL SECURITY 0 52 0 1,075 800 61320 SOCIAL SECURITY 130,526 108,831 96,877 96,231 100 61410 HEALTH INSURANCE 107,070 (115,864) 111,698 108,972 610 61410 HEALTH INSURANCE 16,137 20,039 16,536 15,742 620 61410 HEALTH INSURANCE 17,026 86,332 35,616 25,758 640 61410 HEALTH INSURANCE 0 0 0 3,578 800 61410 HEALTH INSURANCE 335,893 281,105 235,023 206,682 100 61415 WORKMENS'COMPENSATION 21,768 17,488 17,175 14,337 610 61415 WORKMENS'COMPENSATION 3,107 2,916 2,597 2,110 620 61415 WORKMENS'COMPENSATION 2,918 3,061 8,402 5,451 800 61415 WORKMENS'COMPENSATION 57,651 56,288 50,212 35,879 100 61416 LIFE INSURANCE 302 392 1,084 450 610 61416 LIFE INSURANCE 18 73 125 65 620 61416 LIFE INSURANCE 21 200 294 140 640 61416 LIFE INSURANCE 0 0 0 12 800 61416 LIFE INSURANCE 1,286 1,112 2,298 1,204 800 61417 UNEMPLOYMENT INSURANCE 0 435 0 0 100 61640 SAFETY EQUIPMENT 230 647 250 250 100 61660 EMPLOYEE PHYSICALS 367 664 250 250 620 61660 EMPLOYEE PHYSICALS 122 116 0 0 800 61660 EMPLOYEE PHYSICALS 1,054 586 0 0 -164- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 61 -WAGES AND BENEFITS 3,190,054 3,196,676 2,911,988 2,971,268 100 62010 OFFICE SUPPLIES 6,689 6,464 6,823 6,496 620 62010 OFFICE SUPPLIES 0 410 0 0 100 62030 POSTAGEAND SHIPPING 116 2,126 116 177 620 62030 POSTAGEAND SHIPPING 0 75 0 0 800 62030 POSTAGEAND SHIPPING 1,618 (52) 1,618 0 100 62034 REPAIR PARTS/SUPPLIES 0 35 0 0 620 62034 REPAIR PARTS/SUPPLIES 0 85 0 0 100 62050 OFFICE EQUIPMENT MAINT 783 0 1,300 800 100 62061 DP EQUIP. MAINT CONTRACTS 24,878 25,472 27,982 27,562 100 62090 PRINTING&BINDING 118 135 200 135 610 62090 PRINTING&BINDING 0 18 30 18 100 62110 COPYING/REPRODUCTION 5,545 5,527 5,545 5,527 610 62110 COPYING/REPRODUCTION 5 14 50 14 620 62110 COPYING/REPRODUCTION 0 244 0 0 800 62110 COPYING/REPRODUCTION 452 177 452 177 100 62130 LEGAL NOTICES&ADS 394 571 402 402 610 62130 LEGAL NOTICES&ADS 2,613 2,726 2,665 2,726 100 62170 SUBSCRIPTIONS-BOOKS-MAPS 1,491 3,069 3,975 3,676 250 62170 SUBSCRIPTIONS-BOOKS-MAPS 316 485 700 700 610 62170 SUBSCRIPTIONS-BOOKS-MAPS 0 0 325 210 620 62170 SUBSCRIPTIONS-BOOKS-MAPS 0 0 120 120 100 62190 DUES&MEMBERSHIPS 2,027 3,286 3,805 4,052 250 62190 DUES&MEMBERSHIPS 347 490 975 975 610 62190 DUES&MEMBERSHIPS 136 153 230 0 620 62190 DUES&MEMBERSHIPS 240 240 620 635 100 62204 REFUNDS 250 0 255 0 620 62204 REFUNDS 1,197 2,494 1,221 2,494 100 62206 PROPERTY INSURANCE 6,370 5,509 5,550 431 250 62206 PROPERTY INSURANCE 0 0 0 12,514 100 62208 GENERAL LIABILITY INSURAN 9,585 21,043 10,416 17,772 250 62208 GENERAL LIABILITY INSURAN 0 625 0 532 610 62208 GENERAL LIABILITY INSURAN 2,434 2,520 2,646 4,062 800 62208 GENERAL LIABILITY INSURAN 11,194 (163) 12,163 0 620 62210 SALES TAX 126,419 134,391 130,991 134,391 100 62211 PROPERTY TAX 99,486 82,186 88,120 98,500 100 62212 TECH/OTHER EQUIP INSURANC 0 0 0 750 100 62230 COURT COSTS&RECORD FEES 1,282 717 1,280 675 100 62310 TRAVEL-CONFERENCES 6,001 11,948 16,250 16,385 250 62310 TRAVEL-CONFERENCES 3,654 5,756 4,940 4,945 610 62310 TRAVEL-CONFERENCES 5,196 3,216 965 1,680 620 62310 TRAVEL-CONFERENCES 1,018 13,542 5,315 5,585 100 62320 TRAVEL-CITY BUSINESS 60 735 660 625 610 62320 TRAVEL-CITY BUSINESS 0 189 0 0 620 62320 TRAVEL-CITY BUSINESS 1 1 120 120 100 62340 MILEAGE/LOCAL TRANSP 43 551 629 553 610 62340 MILEAGE/LOCAL TRANSP 0 3 0 0 620 62340 MILEAGE/LOCAL TRANSP 3 44 50 0 -165- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 62360 EDUCATION&TRAINING 3,918 5,181 29,755 32,906 250 62360 EDUCATION&TRAINING 1,764 276 4,700 5,900 610 62360 EDUCATION&TRAINING 189 63 2,710 2,210 620 62360 EDUCATION&TRAINING 90 2,885 5,195 4,865 100 62411 UTILITY EXP-ELECTRICITY 0 2,284 0 1,485 620 62411 UTILITY EXP-ELECTRICITY 0 519 15,000 30,000 100 62415 UTILITY EXPENSE STORMWATR 2,295 2,440 9,307 2,778 620 62419 UTILITY EXP-ELEC ST LTNG 1,524 1,549 1,555 1,549 100 62421 TELEPHONE 13,343 12,392 13,627 11,784 250 62421 TELEPHONE 1,199 1,477 1,610 1,540 610 62421 TELEPHONE 1,874 2,139 2,560 1,540 620 62421 TELEPHONE 377 2,753 2,080 1,980 100 62424 RADIO/PAGER FEE 1,880 1,928 1,936 2,136 100 62431 PROPERTY MAINTENANCE 0 326 0 650 620 62431 PROPERTY MAINTENANCE 0 4,224 0 0 100 62436 RENTAL OF SPACE 9,564 9,648 16,620 14,608 620 62436 RENTAL OF SPACE 0 80 0 480 100 62511 FUEL, MOTOR VEHICLE 11,028 8,678 11,028 8,852 620 62511 FUEL, MOTOR VEHICLE 0 3,670 0 0 100 62521 MOTOR VEHICLE MAINT. 12,854 9,923 13,112 9,750 620 62521 MOTOR VEHICLE MAINT. 0 10,729 0 0 100 62522 VEHICLE MAINT.,ACCIDENT 2,400 0 0 0 100 62528 MOTOR VEH. MAINT. OUTSOUR 2,727 1,307 2,781 407 100 62611 MACH/EQUIP MAINTENANCE 1,443 773 500 1,000 250 62611 MACH/EQUIP MAINTENANCE 39,470 23,369 47,073 27,335 610 62611 MACH/EQUIP MAINTENANCE 0 0 0 12,500 100 62614 EQUIP MAINT CONTRACT 0 0 800 0 100 62663 SOFTWARE LICENSE EXP 17,325 22,410 20,516 25,402 250 62663 SOFTWARE LICENSE EXP 17,907 23,519 98,730 79,904 610 62663 SOFTWARE LICENSE EXP 9,193 3,383 5,170 9,385 620 62663 SOFTWARE LICENSE EXP 1,045 7,590 3,510 4,823 100 62664 LICENSE/PERMIT FEES 650 687 1,300 687 100 62667 INTERNET SERVICES 1,660 1,947 3,120 1,946 250 62667 INTERNET SERVICES 999 1,438 8,470 4,763 610 62667 INTERNET SERVICES 1,317 1,761 1,440 480 620 62667 INTERNET SERVICES 795 1,381 1,440 1,080 100 62671 MISC. OPERATING SUPPLIES 592 0 0 0 100 62683 FIELD OPERATIONS SUPPLIES 555 3,508 2,000 3,508 620 62683 FIELD OPERATIONS SUPPLIES 0 320 0 0 100 62696 OUTSIDE COLLECTOR EXPENSE 109 24 111 20 620 62696 OUTSIDE COLLECTOR EXPENSE 3,925 3,359 4,003 3,359 100 62712 CONSULTING ENGINEERS 0 10,366 0 0 620 62712 CONSULTING ENGINEERS 0 125,169 0 0 100 62713 LEGAL SERVICES 5,790 0 4,000 500 400 62713 LEGAL SERVICES 0 7,368 0 0 610 62713 LEGAL SERVICES 0 0 4,000 500 620 62713 LEGAL SERVICES 4,841 4,202 4,000 500 100 62716 CONSULTANT SERVICES 0 0 0 5,000 -166- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 250 62716 CONSULTANT SERVICES 0 225 0 0 620 62716 CONSULTANT SERVICES 25,879 31,619 460,397 112,500 400 62721 FINANCIAL CONSULTANT 0 6,368 0 0 620 62721 FINANCIAL CONSULTANT 10,643 3,632 0 0 100 62726 AUDIT SERVICES 3,000 3,200 4,000 3,200 620 62726 AUDIT SERVICES 1,300 7,800 2,500 2,750 100 62731 MISCELLANEOUS SERVICES 11,703 2,608 0 0 400 62731 MISCELLANEOUS SERVICES 0 16,914 0 0 620 62731 MISCELLANEOUS SERVICES 56,585 9,648 0 0 100 62732 TEMP HELPCONTRACT SERV. 3,880 0 3,957 0 620 62734 SPEAKERS/PROGRAMS 0 450 0 0 100 62746 ONE CALL OPERATION 298 0 0 0 610 62746 ONE CALL OPERATION 1,939 2,208 1,966 2,208 620 62746 ONE CALL OPERATION 1,856 2,208 1,893 2,208 100 62756 EMPLOYEE RECOGNITION 0 0 500 500 100 62757 INSPECTION REIMBURSEMENT 0 15,437 48,000 72,000 100 62761 PAY TO OTHER AGENCY 9,000 10,000 59,799 66,143 620 62761 PAY TO OTHER AGENCY 0 44,532 44,533 44,532 610 62765 GRANTS 0 0 0 10,000 620 62765 GRANTS 0 335,830 351,681 375,047 620 62767 ENVIRON.TESTING/MON. 0 77 0 0 620 62781 LAWN CARE SERVICES 0 8,060 0 0 100 62811 ENG. DIVISION SERVICES 0 19,499 17,000 21,000 620 62811 ENG. DIVISION SERVICES 0 141,889 0 0 62-SUPPLIES AND SERVICES 622,686 1,326,306 1,679,489 1,386,616 620 62724 BOND PAYING AGENT FEE 574 0 586 0 627-CONTRACTUAL SERVICES 574 0 586 0 100 63311 ADMIN.OVERHEAD 0 (9,338) 0 0 63-ADMIN/OVERHEAD/STORES GAR 0 (9,338) 0 0 100 71110 MISC. OFFICE EQUIPMENT 0 1,630 0 0 250 71110 MISC. OFFICE EQUIPMENT 74 0 0 0 620 71110 MISC. OFFICE EQUIPMENT 134 0 0 0 100 71112 TYPEWRITERS 0 0 400 200 250 71112 TYPEWRITERS 0 0 200 0 610 71112 TYPEWRITERS 0 0 200 0 100 71118 PROJECTOR/CAMERA 240 429 1,000 200 250 71118 PROJECTOR/CAMERA 17,690 28,645 20,000 17,200 610 71118 PROJECTOR/CAMERA 198 0 0 0 620 71118 PROJECTOR/CAMERA 0 0 200 0 100 71120 PERIPHERALS,COMPUTER 6,550 0 0 0 250 71120 PERIPHERALS,COMPUTER 2,076 9,670 7,500 10,512 610 71120 PERIPHERALS,COMPUTER 880 0 0 0 620 71120 PERIPHERALS,COMPUTER 99 0 0 0 100 71123 SOFTWARE 11,525 0 0 0 250 71123 SOFTWARE 40 0 0 10,000 100 71124 MICRO-COMPUTER 180 0 0 0 250 71125 SERVERS 34,557 114,420 102,000 151,500 250 71127 UPS SYSTEM 0 0 3,000 0 -167- Recommended Operating Expenditure Budget - Department Total 55 - ENGINEERING FY16 Actual FY17 Actual FY18 Adopted FY 19 Recomm'd Fund Account Account Title Expense Expense Budget Budget 100 71211 DESKS/CHAIRS 2,390 1,615 1,000 6,250 100 71223 CARPET 0 0 0 4,250 100 71225 SHELVING 0 2 0 0 610 71225 SHELVING 0 225 0 0 100 71310 AUTO/JEEP REPLACEMENT 48,941 41,604 25,000 38,000 610 71310 AUTO/JEEP REPLACEMENT 13,502 0 0 0 250 71410 SHOP EQUIPMENT 0 0 500 0 100 71411 TRAFFIC CONTROL EQUIPMENT 6,520 1,571 65,930 4,300 250 71411 TRAFFIC CONTROL EQUIPMENT 76,686 91,615 92,100 104,100 100 71412 SURVEY EQUIPMENT 5,970 599 26,520 6,800 100 71413 LABORATORY EQUIPMENT 1,008 8,000 1,000 1,000 610 72113 OTHER SAFETY EQUIPMENT 433 3,275 2,400 900 100 72410 PAGER/RADIO EQUIPMENT 108 0 7,500 4,500 610 72410 PAGER/RADIO EQUIPMENT 0 0 0 4,500 250 72414 TELEVISION 0 0 5,000 5,000 620 72414 TELEVISION 0 548 0 0 610 72415 ELECTRONIC DATA COLLECTOR 0 0 600 650 100 72418 TELEPHONE RELATED 667 4,280 1,070 3,870 250 72418 TELEPHONE RELATED 0 572 535 435 610 72418 TELEPHONE RELATED 0 841 120 750 620 72418 TELEPHONE RELATED 268 1,179 475 750 610 72510 FLOW TEST EQUIPMENT 14,218 0 9,500 0 620 72510 FLOW TEST EQUIPMENT 0 0 0 900 100 72515 TEST EQUIPMENT, OTHER 0 52 1,600 1,600 71 -EQUIPMENT 244,954 310,772 375,350 378,167 100 73210 CONST CONTRACT-BLDG 0 0 0 6,800 620 73210 CONST CONTRACT-BLDG 0 112 0 0 610 73211 CONST.CONTR-NOT BLDG 0 43,085 70,000 75,000 620 73211 CONST.CONTR-NOT BLDG 0 59,240 0 50,000 73-CIP EXPENDITURES 0 102,437 70,000 131,800 400 74111 PRINCIPAL PAYMENT 876,370 4,530,482 1,473,407 2,112,621 620 74111 PRINCIPAL PAYMENT 7,697,565 3,307,354 1,539,374 1,321,209 400 74112 INTEREST PAYMENT 1,344,289 1,824,137 1,763,380 1,589,429 620 74112 INTEREST PAYMENT 810,298 665,002 835,042 675,872 74-DEBT SERVICE 10,728,522 10,326,975 5,611,203 5,699,131 620 91100 TO GENERAL 480,105 499,607 470,674 469,385 620 91720 TO STORM SEWER CONST 504,111 0 0 1,525,000 91 -TRANSFER TO 984,216 499,607 470,674 1,994,385 55-ENGINEERING TOTAL 15,771,006 15,753,435 11,119,290 12,561,367 -168- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING MIN 1111 ENGINEERING ADMEN. - 55100 i FUNDING SOURCE:ENGINEERING SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 6,800 EQUIPMENT 30,831 8,175 1,950 SUPPLIES AND SERVICES 169,528 246,770 239,162 WAGES AND BENEFITS 1,773,438 377,573 380,812 11111111M 1W 11M11"--' ENGINEERING ADMIN. 1,973,798 628,724 LEASES -55150 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 2,657 - 2,135 111 LEASES 2,657 - 2,135 PROJECT ENGINEERING -55400 FUNDING SOURCE:DEBT SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget ADMIN/OVERHEAD/STORES GAR (9,338) CIP EXPENDITURES 43,085 70,000 75,000 DEBT SERVICE 4,793,635 1,169,190 1,139,839 EQUIPMENT 273,705 361,940 370,007 SUPPLIES AND SERVICES 219,974 314,941 308,345 WAGES AND BENEFITS 791,095 1,454,992 1,450,778 MilMilir11M111 PROJECT ENGINEERING 6,112,156 I I; 3,343,969 ASBURY PLAZA PHASE II -55405 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 3,294 65,000 93,000 WAGES AND BENEFITS 14,567 9,366 27,658 MilY PLAZA PHASE II 17,861 TIMBER-HYRST PHASE I -55418 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget. FY19 Recomm'd Budget WAGES AND BENEFITS 143 Mill TIMBER-HYRST PHASE I 143 - - h TIMBER-HYRST PHASE II -55419 FUNDING SOURCE:GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 1,813 WAGES AND BENEFITS 159 TIMBER-HYRST PHASE II Mi. - - -169- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING WYNSTONE - 55421 FUNDING SOURCE: GENERAL Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget WAGES AND BENEFITS 141 - - =illiWYNSTONE 141 FATS OILS GREASE -55500 FUNDING SOURCE:SEWAGE FACILITY OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget WAGES AND BENEFITS 11,723 FATS OILS GREASE 11,723 0 0 SANITARY SEWER INT SERV -55610 im FUNDING SOURCE:ENGINEERING SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget WAGES AND BENEFITS 51,193 269,838 281,555 -I- SANITARY SANITARY SEWER INT SERV 51,193 269,838 281,5 STORMWATER UTILITY O&M - 55620 FUNDING SOURCE:ENGINEERING SERVICE Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 50,000 CONTRACTUAL SERVICES - 586 - DEBT SERVICE 3,972,356 2,374,416 1,997,081 EQUIPMENT 1,645 675 1,650 SUPPLIES AND SERVICES 771,523 5 97,44 8 658,052 TRANSFER TO 499,607 470,674 1,994,385 WAGES AND BENEFITS 312,717 783,090 592,173 STORMWATER UTILITY O&M 5,557,847 4,226,8:;:: 1 '* II TRAFFIC ENGINEERING -55700 FUNDING SOURCE:ENGINEERING SERVICE Account FY17 Actual Expense FY IS Adopted Budget FY19 Recomm'd Budget EQUIPMENT 4,511 4,560 4,560 SUPPLIES AND SERVICES 23,325 16,330 14,942 WAGES AND BENEFITS 6,564 17,129 67,662 TRAFFIC ENGINEERING 34,400 NPDES DISCHARGE ELIM SYST-55750 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget EQUIPMENT 83 SUPPLIES AND SERVICES 6,645 10,000 - WAGES AND BENEFITS 3,933 - 4,928 NPDES DISCHARGE ELIM SYST 10,661 Mi =11111111 -170- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING NPDES EROSION&SED CONTR- 5575 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 5,578 40,000 - WAGES AND BENEFITS 36,379 - 36,367 NPDES EROSION&SED CONTR 41,957 NPDES DISCHARGE DETECTION-55752 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 1,302 10,000 - WAGES AND BENEFITS 1,449 - 1,819 DES DISCHARGE DETECTION 2,751 10,000 NPDES MUNICIPAL OPERATION-55753 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 1,329 0 0 SUPPLIES AND SERVICES 1,408 10,000 - WAGES AND BENEFITS 4,808 - 5,698 NPDES MUNICIPAL OPERATION 7,545 10,000 5,698 NPDES PUBLIC EDUCATION -55754 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY13 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 1,279 10,000 - WAGES AND BENEFITS 8,939 - 4,740 S PUBLIC EDUCATION 10,218 11,;77:1) 4,740 NPDES PUBLIC PARTICIPATIO-55755 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 1,953 10,000 - WAGES AND BENEFITS 5,927 - 1,896 DES PUBLIC PARTICIPATIO 7,880 10,000 1,896 NPDES POST CONSTRUCTION -55756 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 21,427 50,000 - WAGES AND BENEFITS 27,694 - 28,566 NPDES POST CONSTRUCTION 49,121 ='_i;1; illl l 28,566 SALES TAX INCR DEBT = FUNDING SOURCE:DEBT SERVICE -171- Recommended Expenditure Budget Report by Activity & Funding Source 55 - ENGINEERING Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget DEBT SERVICE 1,560,984 2,067,597 2,562,211 I SALES TAX INCR DEBT 1,560,984 2,067,597 2,562,211 STORMWATER I&I PREVENT-55900 _ FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 37,659 SUPPLIES AND SERVICES 52,861 200,000 5,480 WAGES AND BENEFITS 139,736 — 86,616 STORMWATER I&I PREVENT 230,256 200, STORMWATER DITCH REMEDIAT-55910 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 12,285 SUPPLIES AND SERVICES 830 40,000 25,000 WAGES AND BENEFITS 532 0 0 STORMWATER DITCH REMEDIAT 13,647 40,000 25,0 STREAMBANK REHAB ASSIST -55911L. FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 7,967 0 0 SUPPLIES AND SERVICES 2,006 5,000 5,000 1.1111.1.1- I STREAMBANK REHAB ASSIST 9,973 11 I,Yi DETENTION BASIN MAINTENAN-55920 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget CIP EXPENDITURES 112 SUPPLIES AND SERVICES 35,993 29,000 29,000 WAGES AND BENEFITS 5,538 DETENTION BASIN MAINTENAN 41,643 29,000 STORM SEWER INSP&CLEAN-55930 FUNDING SOURCE:STORM WATER OPERATION Account FY17 Actual Expense FY18 Adopted Budget FY19 Recomm'd Budget SUPPLIES AND SERVICES 2,912 25,000 6,500 STORM SEWER INSP&CLEAN 2,912 25,000 6,500 ENGINEERING TOTAL $ 15,753,438.74 $ 11,119,290.00 $ 12,561,367.00 -172- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FY 2017 FY 2018 FY 2019 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61010 Full Time Employee Expense 100 9425 GE-44 CITY ENGINEER 0.75 $ 100,154 0.25 $ 33,922 0.25 $ 34,431 610 9425 GE-44 CITY ENGINEER 0.00 $ - 0.10 $ 13,569 0.10 $ 13,772 620 9425 GE-44 CITY ENGINEER 0.00 $ - 0.10 $ 13,569 0.10 $ 13,772 800 9425 GE-44 CITY ENGINEER 0.25 $ 33,385 0.55 $ 74,628 0.55 $ 75,748 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.25 $ 26,421 0.25 $ 26,846 0.25 $ 27,375 800 3125 GE-40 ASSISTANT CITY ENGINEER 0.75 $ 71,262 0.75 $ 80,538 0.75 $ 82,126 100 4060 GE-40 PROJECT MANAGER 0.16 $ 16,581 0.40 $ 42,278 0.40 $ 43,170 610 4060 GE-40 PROJECT MANAGER 0.00 $ - 0.00 $ - 0.10 $ 10,793 800 4060 GE-40 PROJECT MANAGER 0.84 $ 87,049 0.60 $ 63,416 0.50 $ 53,962 620 5525 GE-38 CIVIL ENGINEER II 0.25 $ 23,754 0.20 $ 19,214 0.15 $ 14,604 610 5525 GE-38 CIVIL ENGINEER II 0.00 $ - 0.00 $ - 0.10 $ 9,799 100 5525 GE-38 CIVIL ENGINEER II 1.10 $ 103,185 0.95 $ 87,482 0.95 $ 89,134 800 5525 GE-38 CIVIL ENGINEER II 2.65 $ 238,623 2.85 $ 262,763 2.80 $ 262,024 610 2230 GE-35 ENVIRONMENTAL ENGINEER 0.15 $ 13,837 0.00 $ - 0.00 $ - 620 2230 GE-35 ENVIRONMENTAL ENGINEER 0.10 $ 9,225 0.00 $ - 0.00 $ - 800 2230 GE-35 ENVIRONMENTAL ENGINEER 0.75 $ 69,186 0.00 $ - 0.00 $ - 100 5700 GE-36 SURVEYOR 0.80 $ 63,244 0.80 $ 67,348 0.80 $ 68,446 800 5700 GE-36 SURVEYOR 0.20 $ 15,811 0.20 $ 16,837 0.20 $ 17,112 100 5550 GE-33 TRAFFIC ENGINEERING ASSISTANT 0.87 $ - 0.87 $ - 0.87 $ 18,807 800 5550 GE-33 TRAFFIC ENGINEERING ASSISTANT 0.13 $ - 0.13 $ - 0.13 $ 2,810 100 GE-35 TRAFFIC ENGINEER 0.00 $ - 0.60 $ 48,316 0.60 $ 49,032 800 GE-35 TRAFFIC ENGINEER 0.00 $ - 0.40 $ 32,211 0.40 $ 32,689 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 10,900 0.15 $ 11,165 0.15 $ 11,354 800 5575 GE-33 SURVEY PARTY CHIEF 0.85 $ 61,768 0.85 $ 63,266 0.85 $ 64,337 100 2700 GE-31 ENGINEERING ASSISTANT II 1.15 $ 76,363 1.00 $ 67,547 1.00 $ 68,555 620 2700 GE-31 ENGINEERING ASSISTANT II 0.00 $ - 0.10 $ 6,697 0.10 $ 6,796 800 2700 GE-31 ENGINEERING ASSISTANT II 0.85 $ 56,083 0.90 $ 60,333 0.90 $ 61,236 100 2700 GE-31 ENGINEERING TECHNICAN 2.00 $ 133,880 1.70 $ 112,203 1.90 $ 127,219 610 2700 GE-31 ENGINEERING TECHNICAN 0.50 $ 32,002 0.10 $ 6,504 0.05 $ 3,301 620 2700 GE-31 ENGINEERING TECHNICAN 1.05 $ 67,869 1.00 $ 65,647 0.95 $ 62,449 800 2700 GE-31 ENGINEERING TECHNICAN 7.45 $ 477,650 6.26 $ 408,442 6.10 $ 405,100 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 9,275 0.15 $ 9,423 0.15 $ 9,645 800 2725 GE-30 SURVEY TECHNICIAN 0.85 $ 52,558 0.85 $ 53,402 0.85 $ 54,637 100 4870 GE-28 UTILITY LOCATOR 0.00 $ - 0.00 $ - 0.25 $ 14,054 610 4870 GE-28 UTILITY LOCATOR 0.34 $ 17,574 0.34 $ 18,826 0.25 $ 14,054 620 4870 GE-28 UTILITY LOCATOR 0.34 $ 18,527 0.34 $ 18,826 0.25 $ 14,054 640 4870 GE-28 UTILITY LOCATOR 0.00 $ - 0.00 $ - 0.25 $ 14,054 800 4870 GE-28 UTILITY LOCATOR 0.32 $ 17,438 0.32 $ 17,718 0.00 $ - 610 GE-26 I&I INSPECTOR 0.00 $ - 0.00 $ - 0.00 $ - 620 GE-26 I&I INSPECTOR 2.00 $ 96,924 0.00 $ - 0.00 $ - 800 GE-26 I&I INSPECTOR 0.00 $ - 0.00 $ - 0.00 $ - 100 225 GE-25 SECRETARY 0.55 $ 25,794 0.25 $ 11,796 0.25 $ 12,044 610 225 GE-25 SECRETARY 0.00 $ - 0.25 $ 11,796 0.25 $ 12,044 620 225 GE-25 SECRETARY 0.00 $ - 0.25 $ 11,796 0.00 $ - 800 225 GE-25 SECRETARY 0.45 $ 21,104 0.25 $ 11,796 0.50 $ 24,088 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.45 $ 16,697 0.50 $ 22,138 0.50 $ 23,712 610 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.00 $ - 0.25 $ 11,069 0.25 $ 11,856 620 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.00 $ - 0.25 $ 11,069 0.25 $ 11,856 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.55 $ 20,407 0.00 $ - 0.00 $ - TOTAL FULL TIME EMPLOYEES 30.00 $ 2,084,530 26.06 $1,894,396 26.00 $1,946,051 -173- CITY OF DUBUQUE, IOWA DEPARTMENT DETAIL-PERSONNEL COMPLEMENT 55 ENGINEERING DEPARTMENT FY 2017 FY 2018 FY 2019 FD JC WP-GR JOB CLASS FTE BUDGET FTE BUDGET FTE BUDGET 61020 Part-Time Employee Expense 620 GE-26 I&I INSPECTOR 0.00 $ — 0.73 $ 35,749 1.48 $ 73,974 100 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 0.00 $ — 0.35 $ 13,195 0.35 $ 13,395 800 1000 GE-25 CONFIDENTIAL ACCOUNT CLERK 1.37 $ 52,444 0.90 $ 33,922 0.90 $ 34,445 TOTAL PART TIME EMPLOYEES 1.37 $ 52,444 1.98 $ 82,866 2.73 $ 121,814 61030 Seasonal Employee Expense 100 5325 NA-34 ENGINEERING AIDE-SEASONAL 0.25 $ 8,242 0.25 $ 8,211 0.50 $ 16,672 800 5325 NA-46 ENGINEERING ASSIST-SEASONAL 0.50 $ 21,788 0.00 $ — 0.00 $ — 800 5325 NA-34 ENGINEERING AIDE-SEASONAL 2.50 $ 82,420 1.00 $ 32,844 1.00 $ 33,344 TOTAL SEASONAL EMPLOYEES 3.25 $ 112,450 1.25 $ 41,055 1.50 $ 50,016 TOTAL ENGINEERING 34.62 $ 2,249,424 29.29 $2,018,317 30.23 $2,117,881 -174- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Engineering Administration-FT General Fund 10055100 61010 100 225 GE-25 SECRETARY 0.55 $ 25,794 0.25 $ 11,796 0.25 $ 12,044 10055100 61010 100 1000 GE-25 CLERK CONFIDENTIAL ACCOUNT 0.45 $ 16,697 0.25 $ 11,069 0.25 $ 11,856 10055100 61010 100 3125 GE-40 ASSISTANT CITY ENGINEER 0.25 $ 26,421 0.25 $ 26,846 0.25 $ 27,375 10055100 61010 100 4060 GE-40 PROJECT MANAGER 0.16 $ 16,581 0.40 $ 42,278 0.40 $ 43,170 10055100 61010 100 9425 GE-44 CITY ENGINEER 0.75 $ 100,154 0.25 $ 33,922 0.25 $ 34,431 Total 2.16 $ 185,647 1.40 $ 125,911 1.40 $ 128,876 Engineering Administration-PT Service Fund 10055100 61020 100 1000 GE-25 CONFIDENTIAL ACCOU NT CLERK 0.00 $ - 0.35 $ 13,195 0.35 $ 13,395 Total 0.00 $ - 0.35 $ 13,195 0.35 $ 13,395 Engineering Administration-FT Service Fund CONFIDENTIAL ACCOUNT 80055100 61010 800 1000 GE-25 CLERK 0.55 $ 20,407 0.00 $ - 0.00 $ - 80055100 61010 800 3125 GE-38 ASSISTANT CITY ENGINEER 0.75 $ 71,262 0.75 $ 80,538 0.75 $ 82,126 80055100 61010 800 4060 GE-40 PROJECT MANAGER 0.10 $ 10,363 0.10 $ 10,570 0.10 $ 10,793 80055100 61010 800 225 GE-25 SECRETARY 0.45 $ 21,104 0.25 $ 11,796 0.25 $ 12,044 80055100 61010 800 9425 GE-44 CITY ENGINEER 0.25 $ 33,385 0.25 $ 33,922 0.25 $ 34,431 Total 2.10 $ 156,521 1.35 $ 136,826 1.35 $ 139,394 Engineering Administration-PT Service Fund 80055100 61020 800 1000 GE-25 CLERK CONFIDENTIAL ACCOUNT 0.30 $ 11,739 0.00 $ - 0.00 $ - Total 0.30 $ 11,739 0.00 $ - 0.00 $ - Project Engineering-FT General Fund 10055400 61010 100 2700 GE-31 ENGINEERING ASSISTANT II 1.15 $ 76,363 1.00 $ 67,547 1.00 $ 68,555 10055400 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 2.00 $ 133,880 1.60 $ 105,545 1.60 $ 107,277 10055400 61010 100 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 9,275 0.15 $ 9,423 0.15 $ 9,645 10055400 61010 100 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 10,900 0.15 $ 11,165 0.15 $ 11,354 10055400 61010 100 4710 GE-35 TRAFFIC ENGINEER 0.00 $ - 0.60 $ 48,316 0.60 $ 49,032 10055400 61010 100 5525 GE-38 CIVIL ENGINEER II 1.10 $ 103,185 0.95 $ 87,482 0.95 $ 89,134 10055400 61010 100 5700 GE-36 SURVEYOR 0.80 $ 63,244 0.80 $ 67,348 0.80 $ 68,446 Total 5.35 $ 396,847 5.25 $ 396,826 5.25 $ 403,443 Project Engineering-Seasonal General Fund 10055400 61030 100 5325 NA-34 ENGINEERING AIDE-SEASONAL 0.25 $ 8,242 0.25 $ 8,211 0.50 $ 16,672 Total 0.25 $ 8,242 0.25 $ 8,211 0.50 $ 16,672 Project Engineering Subdivision Inspection-FT General Fund 10055405 61010 100 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.10 $ 6,658 0.30 $ 19,942 Total 0.00 $ - 0.10 $ 6,658 0.30 $ 19,942 Project Engineering-FT Service Fund 80055400 61010 800 2710 GE-26 I&I INSPECTOR 0.00 $ - 0.00 $ - 0.00 $ - 80055400 61010 800 4870 GE-28 UTILITY LOCATOR 0.32 $ 17,438 0.32 $ 17,718 0.00 $ - 80055400 61010 800 2700 GE-31 ENGINEERING ASSISTANT II 0.35 $ 23,131 0.50 $ 33,547 0.50 $ 34,049 80055400 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 3.40 $ 230,160 3.00 $ 196,870 2.90 $ 193,636 80055400 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.55 $ 34,008 0.30 $ 18,848 0.30 $ 19,272 80055400 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.55 $ 39,968 0.30 $ 22,329 0.30 $ 22,707 80055400 61010 800 5525 GE-38 CIVIL ENGINEER II 1.90 $ 167,362 1.55 $ 137,630 1.55 $ 139,913 80055400 61010 800 4710 GE-35 TRAFFIC ENGINEER 0.00 $ - 0.40 $ 32,211 0.40 $ 32,689 80055400 61010 800 5700 GE-36 SURVEYOR 0.20 $ 15,811 0.20 $ 16,837 0.20 $ 17,112 Total 7.27 $ 527,878 6.57 $ 475,990 6.15 $ 459,378 Project Engineering-Seasonal Service Fund 80055400 61030 800 5325 NA-34 ENGINEERING AIDE-SEASONAL 1.00 $ 32,968 1.00 $ 32,844 1.00 $ 33,344 Total 1.00 $ 32,968 1.00 $ 32,844 1.00 $ 33,344 -175- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET Traffic Engineering-FT General Fund CONFIDENTIAL ACCOUNT 10055700 61010 100 CLERK 0.00 $ - 0.25 $ 11,069 0.25 $ 11,856 10055700 61010 100 4870 GE-28 UTILITY LOCATOR 0.00 $ - 0.00 $ - 0.25 $ 14,054 10055700 61010 100 5550 GE-33 TRAFFIC ENGINEERING ASSIST 0.87 $ - 0.87 $ - 0.87 $ 18,807 Total 0.87 $ - 1.12 $ 11,069 1.37 $ 44,717 Traffic Engineering-FT Service Fund 80055700 61010 800 5550 GE-33 TRAFFIC ENGINEERING ASSIST 0.13 $ - 0.13 $ - 0.13 $ 2,810 Total 0.13 $ - 0.13 $ - 0.13 $ 2,810 Project Engineering-FT Sewer Fund 61055400 61010 610 2230 GE-35 ENVIRONMENTAL ENGINEER 0.15 $ 13,837 0.00 $ - 0.00 $ - 61055400 61010 610 4870 GE-28 UTILITY LOCATOR 0.34 $ 17,574 0.34 $ 18,826 0.25 $ 14,054 CONFIDENTIAL ACCOUNT 61055400 61010 610 1000 GE-33 CLERK 0.00 $ - 0.25 $ 11,069 0.25 $ 11,856 61055400 61010 610 5525 GE-38 CIVIL ENGINEER II 0.00 $ - 0.00 $ - 0.10 $ 9,799 61055400 61010 610 4060 GE-40 PROJECT MANAGER 0.00 $ - 0.00 $ - 0.10 $ 10,793 61055400 61010 610 9425 GE-44 CITY ENGINEER 0.00 $ - 0.10 $ 13,569 0.10 $ 13,772 61055400 61010 610 2710 GE-26 I&I INSPECTOR 0.00 $ - 0.00 $ - 0.00 $ - 61055400 61010 610 225 GE-25 SECRETARY 0.00 $ - 0.25 $ 11,796 0.25 $ 12,044 61055400 61010 610 2220 GE-31 ENGINEERING TECHNICIAN 0.50 $ 32,002 0.10 $ 6,504 0.05 $ 3,301 Total 0.99 $ 63,413 1.04 $ 61,764 1.10 $ 75,619 NPDES PERMIT-FT Stormwater Fund 62055751 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.40 $ 26,141 62055750 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.04 $ 2,614 62055752 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.02 $ 1,307 62055755 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.02 $ 1,372 62055756 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.30 $ 19,606 62055754 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.05 $ 3,431 62055753 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 0.00 $ - 0.00 $ - 0.02 $ 1,307 62055753 61010 620 1900 GE-38 CIVIL ENGINEER II 0.00 $ - 0.00 $ - 0.03 $ 2,940 62055756 61010 620 1900 GE-38 CIVIL ENGINEER II 0.00 $ - 0.00 $ - 0.01 $ 980 62055750 61010 620 1900 GE-38 CIVIL ENGINEER II 0.00 $ - 0.00 $ - 0.01 $ 980 Total 0.00 $ - 0.00 $ - 0.90 $ 60,678 Sanitary Utility-FT Service Fund 80055610 61010 800 5525 GE-38 CIVIL ENGINEER II 0.15 $ 14,252 0.00 $ - 0.00 $ - 80055610 61010 800 9425 GE-44 CITY ENGINEER 0.00 $ - 0.15 $ 20,353 0.20 $ 27,545 80055610 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 1.50 $ 96,007 1.50 $ 97,554 1.50 $ 99,041 80055610 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 9,275 0.30 $ 18,848 0.30 $ 19,290 80055610 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 10,900 0.30 $ 22,329 0.30 $ 22,707 80055610 61010 800 2230 GE-35 ENVIRONMENTAL ENGINEER 0.50 $ 46,124 0.00 $ - 0.00 $ - 80055610 61010 800 225 GE-25 SECRETARY 0.00 $ - 0.00 $ - 0.25 $ 12,044 80055610 61010 800 4060 GE-40 PROJECT MANAGER 0.00 $ - 0.25 $ 26,423 0.15 $ 16,188 Total 2.45 $ 176,558 2.50 $ 185,507 2.70 $ 196,815 Sanitary Utility-PT Service Fund CONFIDENTIAL ACCOUNT 80055610 61010 800 1000 GE-33 CLERK 0.00 $ - 0.15 $ 5,655 0.15 $ 5,741 Total 0.00 $ - 0.15 $ 5,655 0.15 $ 5,741 Project Engineering-FT Stormwater Fund 62055620 61010 620 2220 GE-31 ENGINEERING TECHNICIAN 1.05 $ 67,869 1.00 $ 65,647 0.10 $ 6,671 62055620 61010 620 4870 GE-28 UTILITY LOCATOR 0.34 $ 18,527 0.34 $ 18,826 0.25 $ 14,054 62055620 61010 620 2230 GE-35 ENVIRONMENTAL ENGINEER 0.10 $ 9,225 0.00 $ - 0.00 $ - 62055620 61010 620 2710 GE-26 I&I INSPECTOR 2.00 $ 96,924 0.00 $ - 0.00 $ CONFIDENTIAL ACCOUNT 62055620 61010 620 1000 GE-33 CLERK 0.00 $ - 0.25 $ 11,069 0.25 $ 11,856 -176- CITY OF DUBUQUE,IOWA ACTIVITY PERSONNEL COMPLEMENT SUMMARY FY 2017 FY 2018 FY 2019 ACCT FD JC WP-GR POSITION CLASS FTE BUDGET FTE BUDGET FTE BUDGET 62055620 61010 620 9425 GE-44 CITY ENGINEER 0.00 $ - 0.10 $ 13,569 0.10 $ 13,772 62055620 61010 620 2700 GE-31 ENGINEERING ASST II 0.00 $ - 0.10 $ 6,697 0.10 $ 6,796 62055620 61010 620 225 GE-25 SECRETARY 0.00 $ - 0.25 $ 11,796 0.00 $ - 62055620 61010 620 1900 GE-38 CIVIL ENGINEER II 0.25 $ 23,754 0.20 $ 19,214 0.10 $ 9,704 Total 3.74 $ 216,299 2.24 $ 146,818 0.90 $ 62,853 Stormwater Utility-PT Stormwater 62055900 61020 620 2710 GE-26 I&I INSPECTOR 0.00 $ - 0.73 $ 35,749 1.48 $ 73,974 Total 0.00 $ - 0.73 $ 35,749 1.48 $ 73,974 Stormwater Utility-FT Service Fund 80055620 61010 800 5525 GE-38 CIVIL ENGINEER II 0.60 $ 57,009 1.30 $ 125,133 1.25 $ 122,111 80055620 61010 800 9425 GE-44 CITY ENGINEER 0.00 $ - 0.15 $ 20,353 0.10 $ 13,772 80055620 61010 800 2220 GE-31 ENGINEERING TECHNICIAN 2.55 $ 151,483 1.76 $ 114,018 1.70 $ 112,423 80055620 61010 800 2230 GE-35 ENVIRONMENTAL ENGINEER 0.25 $ 23,062 0.00 $ - 0.00 $ - 80055620 61010 800 2700 GE-31 ENGINEERING ASST II 0.50 $ 32,952 0.40 $ 26,786 0.40 $ 27,187 80055620 61010 800 2725 GE-30 SURVEY TECHNICIAN 0.15 $ 9,275 0.25 $ 15,706 0.25 $ 16,075 80055620 61010 800 4060 GE-40 PROJECT MANAGER 0.74 $ 76,686 0.25 $ 26,423 0.25 $ 26,981 80055620 61010 800 5575 GE-33 SURVEY PARTY CHIEF 0.15 $ 10,900 0.25 $ 18,608 0.25 $ 18,923 80055620 61010 800 2710 GE-26 I&I INSPECTOR 0.00 $ - 0.00 $ - 0.00 $ - Total 4.94 $ 361,367 4.36 $ 347,027 4.20 $ 337,472 Stormwater Utility-PT Service Fund CONFIDENTIAL ACCOUNT 80055620 61020 800 1000 GE-25 CLERK 1.07 $ 40,705 0.75 $ 28,267 0.75 $ 28,704 Total 1.07 $ 40,705 0.75 $ 28,267 0.75 $ 28,704 Stormwater Utility-Seasonal Service Fund 80055620 61030 800 NA-34 ENGINEERING AIDE-SEASONAL 1.50 $ 49,452 0.00 $ - 0.00 $ - ENGINEERING ASSIST- 80055620 61030 800 5325 NA-46 SEASONAL 0.50 $ 21,788 0.00 $ - 0.00 $ - Total 2.00 $ 71,240 0.00 $ - 0.00 $ - Water Utility-FT 64055400 61010 620 4870 GE-28 UTILITY LOCATOR 0.00 $ - 0.00 $ - 0.25 $ 14,054 Total 0.00 $ - 0.00 $ - 0.25 $ 14,054 TOTAL ENGINEERING DIVISION 34.62 $2,249,424 29.29 $2,018,317 30.23 $ 2,117,881 -177- Capital Improvement Projects by Department/Division ENGINEERING FY 19 CIP FY 16 Actual FY 17 Actual FY 18 Adopted Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 1001108 SIDEWALK REPAIR/MAINTENAN 3,158 1,378 30,000 30,000 1001818 ROCKDALE CORRIDOR STUDY 598 22 1001857 UTILITY FRANSHICEANALYST 2,156,273 1002502 ELM COMPLETE STREET 351 1021023 INTERSECTION PREEMPTION 2,751 1021857 UTILITY FRANCHISE ANALYST 206,813 108,804 1022673 16TH ST DET BASIN TRAIL - 6,026 - - 1022674 KERPER BLVD FIBER AND CAM - 23,930 - - 2501039 CORRIDOR STUDY ALTERNATES - - 1,650,000 - 2501077 BRUNSKILL RD BRIDGE REPLC 4,253 22,478 2501281 JACKSON ST.RECONSTRUCTIO 320,000 2501702 3RD ST OVERPASS-PAINT - - 100,000 - 2501916 LED RE-LAMP SCHEDULE 9,253 2502253 ITS TRAFFIC CONTROL EQUIP 24,500 2502274 US 52/CENTRAL TRAFFIC IMP - - 751,800 - 2502724 GRNDVW/UNVRSTY ROUNDABOUT 900,000 2601236 WHEEL CHAIR RAMPS 105 256 12,600 - 2601239 NEIGHBORHOOD REL IMPROVEM 47,750 4,897 93,400 - 2601549 STREET LIGHT REPLACEMENT 28,000 2642769 HUD RESILIENCY ENGINEER 9,690,000 3001011 SIGNALIZATIONPROGRAM 46,059 62,985 110,000 65,000 3001023 INTERSECTION PREEMPTION 8,253 5,593 3001027 GUARDRAIL REPLACEMENT 12,592 - 15,000 10,000 3001029 STONE RETAINING WALLS 102,783 55,721 275,000 50,000 3001034 ACCESSIBILITY BARRIERS 167 3001041 CURB/CATCH BASIN REPL 66,680 32,793 70,000 20,000 3001133 TRAFFIC SIGNAL MASTARM RE 67,848 6,379 60,000 40,000 3001210 GRANDVIEW AVE.LIGHT POLES 16,559 14,439 200,000 - 3001229 TRAFFIC CONTR BATTERY PCK 35,462 - 20,000 20,000 3001258 BRIDGE REPAIRS/MAINT. 17,526 295,083 80,000 85,000 3001266 TRAFFIC SIGNAL INTERCONNE 90,152 35,680 40,000 25,000 3001274 TRAFFIC CONTROLLER REPLAC 63,274 575 45,000 15,000 3001287 SOUTHWEST ARTERIAL 10,777,466 5,965,475 555,000 350,000 3001425 SIDEWALK PROGRAM CITY OWN 48,524 31,703 75,000 - 3001549 STREET LIGHT REPLACEMENT 7,006 12,421 23,000 - 3001615 SIGNAL INTERSEC RECONS TRU 12,921 28,522 120,000 45,000 3001630 DECORATIVE CONCRETE MAINT 3,713 - 25,000 - 3001631 TRAFF SIG FIBER OPTIC NET 123,747 42,322 164,000 - 3001815 TRAFFIC CONSULTANT SERV 29,541 3001816 TRAFFIC SIG VIDEO DET CON 62,745 61,540 67,000 42,000 3001916 LED RE-LAMP SCHEDULE 10,000 29,231 24,500 10,500 3001919 RECON SIGNALS/JFK-WACKER 160,382 3002021 N CASCADE RD RECONSTRUCT 5,583 78,619 3002142 STREET CONST-GENERAL 183,906 182,349 100,000 75,000 3002144 FIBER OPTIC CONDUIT-MISC 27,040 33,253 40,000 - 3002245 PAVEMENT MARKING 67,062 155,531 135,000 135,000 3002246 CROSSWALK WARNING DEVICES - - 31,000 - 3002252 ST LIGHT/SIGNAL KNOCKDOWN 24,860 59,472 30,000 30,000 3002253 ITS TRAFFIC CONTROL EQUIP 30,000 19,752 3002257 PORTABLE RADAR SPEED SIGN 39,382 3002324 UNI&ASBURY INTER IMPROV 852,786 3002325 VIDEO DET CAMERA UPGRADE 13,890 3002327 CATFISH CRTC BRIDGE FIBER 1,143 366,412 -178- Capital Improvement Projects by Department/Division ENGINEERING FY 19 CIP FY 16 Actual FY 17 Actual FY 18 Adopted Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 3002328 SCHOOL ZN CNT-DWN PED SIG 7,955 3,990 3002420 SRGE AND GRND IMPR SIGNAL - 4,009 15,000 - 3002421 STREET CAMERA INSTALL 8,966 6,641 25,000 40,000 3002422 TRAFIC OPS CTR VIDEO SOFT 24,994 24,928 40,000 - 3002423 TRAFIC OPS CNTR EQUP TEST 14,376 3002482 ASBURY ROAD GRINDING 384,134 3002484 LED STREETLIGHT RETROFIT 15,041 26,235 3002485 TOC TEST BENCH 389 3002491 FIBER OPTICS TO AIRPORT 688,823 44,474 125,000 - 3002553 9TH TO 11TH 1WAY2WAYRRX - 20,178 - - 3002557 FLASH YELLOW LEFT TURN 10,117 122 20,000 - 3002558 REPLC LED SIGNS BEACONS - 4,080 - - 3002559 GRANDVIEW SIGNAL RECON 35,285 55,627 3002611 GRANDVIEW/DELHI ROUNDABOU 125,713 672,072 3002612 HEEB STREET RECON 6,435 5,777 3002613 ROW MANAGEMENT 9,092 37,978 3002614 ASBURY RD WEST CITY ASBUR 25,778 19,335 3002615 WAH NEIGH STREET LIGHTS 5,203 - 10,000 - 3002616 STREET LIGHT AUDIT 26,737 3002617 JFK RD COORD WACKER/ASB 2,889 8,310 3002618 WEST LOCUST COMM/CAMERAS 4,260 21,152 3002619 UNIV/ASBURYFIBER/CAMERA 58,154 11,301 3002620 FIBER/NETWORK MGMT PROG 996 122 3002634 SMARTER TRAVEL PROJECT 120,750 8,874 3002672 NEW ST LIGHTS CITY-WIDE - - 10,000 - 3002675 NW ARTERIAL TURN LANE IMP - 2,034 132,000 - 3002676 CITY-WIDE SECURITY CAMERA - 2,020 50,000 - 3002694 KEY WEST DR RECONSTRUCT - 64,182 - - 3002695 NW ARTERIAL LEFT TURN LN - 165,319 - - 3002724 GRNDVW/UNVRSTY ROUNDABOUT - - 250,000 - 3002761 DERBY GRANGE RESURFACE 23,000 3002762 LANDFILL ACCESS ROAD 400,000 3002763 STREETS TRAFFIC CONTROL 200,000 3401654 BEE BRANCH CREEK RESTORAT 8,434,445 6,784,641 3402608 GATE REPLC FLOOD MITIGATI 53,967 33,037 3402609 FLOOD CONTROL MAINT FACIL 308,100 49,202 3402690 HUD RESILIENCY 489,000 3501029 STONE RETAINING WALLS 37,512 3501053 RIVERFRONT LEASEHOLD IMPR 4,414 127,604 - 104,000 3501425 SIDEWALK PROGRAM CITY OWN 49,391 3501465 REHAB RR TRACK 4,408 3501466 HARBOR AREA MAINTENANCE 121,523 - 10,000 - 3501549 STREET LIGHT REPLACEMENT 31,481 3501609 FIBER OPT CON-PRIV&MISC 61 3501630 DECORATIVE CONCRETE MAINT 100,000 3501841 FEDERAL BUILDING RENOVTN 5,523 9,018 3502021 N CASCADE RD RECONSTRUCT - 2,506 - - 3601039 CORRIDOR STUDY ALTERNATES 578,000 3601549 STREET LIGHT REPLACEMENT 19,400 3601608 DWNTWN ST LIGHT REPLACMNT 6,228 89 45,000 - 3601841 FEDERAL BUILDING RENOVTN 39,000 160,000 3602020 MAIN ST STREETSCAPE IMPRO 14,200 3602021 N CASCADE RD RECONSTRUCT - - 406,000 - -179- Capital Improvement Projects by Department/Division ENGINEERING FY 19 CIP FY 16 Actual FY 17 Actual FY 18 Adopted Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 3602421 STREET CAMERA INSTALL 12,509 3602442 1 WAY TO 2WAY CONVERSION 9,546 3602481 18TH ST WALL RECON 30,286 95,524 3602484 LED STREETLIGHT RETROFIT - - 25,000 - 3602487 POD PARKING LOT 25,000 50,000 3602494 DT SECURITY CAMERAS 152,124 121,671 3602551 CHAVANELLE RD REHAB - - 1,500,000 - 3602552 WASH ST RECON 8TH TO 9TH 31,376 35,425 3602671 DOWNTOWN STREET LIGHTS - - 25,000 - 3602676 DOWNTOWN SECURITY CAMERAS - - 10,000 - 3602760 HWY 52 PHASE 4 CENTRAL 1,923,000 7101012 ANNEXATION STUDY/IMPLEMEN 2,523 602 7101067 SEWER CONN ASST-LOW/MOD 8,124 7101289 GENERAL SANITARY SEWER RE 481,248 4,494 7101293 SAN SEWER INTERNAL MAIN 65,000 191,000 7101294 I&I REDUCTION PROGRAM 381,309 75,219 110,000 - 7101297 LATERAL REPL ASST.LOW INC 9,543 7101320 LATERALS-I&I REDUCTION 13,731 12,745 7101335 SAN SEWER MANHOLE REPLACE 283,841 197,802 216,000 77,921 7101350 SEWER EXTENSIONS NEW DEV. 145,349 174,437 7101637 SAN SEWER LINING PROGRAM 11,733 446,675 350,000 150,000 7101638 STREET PROG/RELATED SANIT 1,046 180,239 7102233 FAIRWAY DR SANITARY SEWER - 23,500 - - 7102406 FOX BLACKHAWK SAN SEWER 125,850 7102409 GRANGER CREEK SAN EXT 3,359,630 294,278 7102413 RELOC 30"MAIN OPW GARAGE 44,215 356,408 7102450 $9.4 GREEN ALLEYS 3,445,635 1,826,114 7102544 ENVIRON CONSULT SVC 6,970 7102546 TRACK LN SAN SEWER CLEAN 2,615 7102547 WASH ST SAN 7TH TO 9TH 2,824 7102548 JFK SANITARY SEWER - 59,390 - - 7102571 AUBURN&CUSTER SAN SEWER 1,995 7102606 CEDAR/TERM ASSESSMENTS 16,658 186,787 785,000 - 7102607 CATFISH/GRANGER LIFT IMPR 11,328 194,709 7102633 PRIVATE WATER/SEWER PURCH 833,117 7102638 LAKE ELEANOR LIFT STATION 289,644 13,518 7102663 KERPER SANITARY 16,332 170,041 7102670 SW ART/HWY 20 UTLTY RELOC 275,000 7102720 30TH&JACKSON SAN SEWER - - 170,000 - 7102721 MARQUETTE SAN SEWER - - 225,000 - 7102754 TWIN RIDGE LIFT ST ABANDO 175,000 7102755 HARLAN EUCLID SANITARY 75,000 7201004 STORMWATER DITCH REMEDIAT 30,000 7201008 STORM SEWER IMPRJEXTENSIO 28,333 11,265 - 60,000 7201066 GENERAL REPAIRS 136,793 151,773 - 100,000 72010720 UNDISTRIBUTED-STORM 5,000 7201081 CATCH BASIN/WESTSIDE STOR 759 10,136 - 53,000 7201086 NW ARTERIAL DETENSION BAS 48,500 7201180 JACKSON STREET STORM SEWS 30,000 7201208 ARROWHEAD STORM 6,591 7201352 STREAMBANK REHAB 18,249 7201354 DRAIN TILE PROGRAM 217 28,731 - 20,000 -180- Capital Improvement Projects by Department/Division ENGINEERING FY 19 CIP FY 16 Actual FY 17 Actual FY 18 Adopted Recomm'd Number Capital Improvement Project Title Expense Expense Budget Budget 7201355 NPDES PROGRAM 14,541 7201359 DETENTION BASIN MAINTENAN 36,895 7201363 GUNITE ROCK STORM SEWER 100,000 7201364 PROP TAX EXEMPT SUBSIDY 286,144 7201365 MIDDLE ROAD CULVERT - - 150,000 - 7201375 REMOVAL OF SILT 32ND ST. 175 7201378 LOW INCOME SFU ASSISTANCE 15,324 7201654 BEE BRANCH CREEK RESTORAT 18,368,047 9,937,445 7201659 STORM SEWER CLEANING 27,623 7201809 VILLA ST STORM SEWER PROJ 117 50,218 7201906 STRMWTR SUBSIDY-RES FARMS 8,050 7202015 STORM SEWER SYS ASSESS 1,920 7202062 NPDES-EROSION CONTROL 29,111 7202063 NPDES-ILLICIT DISCHARGE 10,000 7202064 NPDES-MUNICIPAL OPERATION 10,000 7202065 NPDES-POST CONSTRUCTION 50,000 7202066 NPDES-PUBLIC EDUCATION 16,702 7202067 NPDES-PUBLIC PARTICIPATI 16,755 7202133 KANE KAUF-STORM SEW CONST 23,880 7202238 CEDAR CROSS RD STORM 14,014 69,700 7202239 FLOODWALL BREACH ANALYSIS 106,593 12,262 7202274 US-52 STORM IMPROVEMENTS - - 200,000 - 7202331 CATFISH CRK WATERSHED PRT 43,446 7202332 STORMWTR INFILT&INFLOW 107,110 56,978 - 100,000 7202333 STORMWTR INFILT&INFLO PRE 200,000 7202414 WINDSOR STORM EXT 39 7202610 ADMIRAL SHEEHY FLOOD GATE 49,500 7202632 S GRANDVIEW(CANGENELLI) - 82,563 - - 7202668 NORTHRIDGE STORM EXTENSIO 19,000 7202690 HUD RESILIENCY 1,600,000 4,479,042 7202693 CATFISH CRK BRIDGE STORM - 71,403 - - 7202722 WILBRICHT DETENTION BASIN - - 50,000 - 7202723 VAN BUREN STORM OUTLET - - 65,000 - 7202756 US 52 CENTRAL STORMWATER 100,000 7202757 ST ANNE DR STORM 62,500 7202758 HILLCREST ROSEMONT DET 98,800 7202759 MAUS PARK CULVERT 200,000 ENGINEERIN rr I ,11,9 11,720,300 -181- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE PUBLIC WORKS SANITARY SEWER Business Type General Sanitary Sewer Extensions to New Developments $ 191,000 $ 34,822 $ 13,275 $ 33,866 $ 59,145 $ 332,108 146 Twin Ridge Lift Station Abandonment $ 175,000 $ - $ - $ - $ - $ 175,000 147 Sanitary Sewer Extensions to Existing Developments $ - $ 386,310 $ - $ - $ - $ 386,310 148 Sanitary Sewer Extensions- Existing Development, Pre- annexation and Annexation Agreements $ - $ - $ 233,500 $ - $ - $ 233,500 149 Twin Ridge Subdivision -Lagoon Abandonment $ - $ 465,000 $ - $ - $ - $ 465,000 150 Rehabilitation Sanitary Sewer Lining Program $ 150,000 $ 27,500 $ 66,338 $ 29,009 $ 154,653 $ 427,500 151 Manhole Replacement/Rehab Program $ 77,921 $ 100,000 $ - $ 14,472 $ - $ 192,393 152 Cedar and Terminal Street Lift Station and Force Main Assessment and Improvements $ - $ 903,000 $ 1,416,000 $ - $ - $ 2,319,000 153 Track Line Sanitary Cleaning and Lining $ - $ 287,790 $ - $ - $ - $ 287,790 155 Center Place Alley Sanitary Sewer Rehabilitation $ - $ - $ 110,000 $ 300,000 $ - $ 410,000 156 Couler Valley Interceptor Inspection, Cleaning and Rehabilitation $ - $ - $ - $ - $ 85,000 $ 85,000 157 Reconstruction Harlan &Euclid Street Sanitary Reconstruction $ 75,000 $ - $ - $ - $ - $ 75,000 158 Southwest Arterial-US Highway 20 Interchange Utility Relocation $ 275,000 $ - $ - $ - $ - $ 275,000 159 Fox/Blackhawk Sanitary Sewer Reconstruction $ 125,850 $ - $ - $ - $ - $ 125,850 160 Wood Street Sanitary Sewer Reconstruction $ - $ 110,000 $ - $ - $ - $ 110,000 161 Auburn &Custer Sanitary Sewer Reconstruction $ - $ - $ 316,400 $ - $ - $ 316,400 162 Heeb Street Sanitary Sewer Reconstruction $ - $ - $ 20,000 $ 160,000 $ - $ 180,000 163 Grove Terrace Sanitary Sewer Reconstruction $ - $ - $ - $ 110,000 $ - $ 110,000 164 Hempstead Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 30,000 $ 30,000 165 Cooper Place and Maiden Lane Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 30,000 $ 30,000 166 Abott&Cottage Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 20,000 $ 20,000 167 Southfork Interceptor Sewer $ - $ - $ - $ - $ 34,181 $ 34,181 168 -182- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE Knob Hill-Duggan Drive Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 149,310 $ 149,310 169 Brunswick Sanitary Sewer $ - $ - $ - $ - $ 9,400 $ 9,400 170 Southgate Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 13,300 $ 13,300 171 King Street Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 11,300 $ 11,300 172 Center Grove Sanitary Sewer Reconstruction $ - $ - $ - $ - $ 7,300 $ 7,300 173 STORMWATER Business Type General Storm Sewer Projects Stormwater Infiltration & Inflow Elimination Program $ 100,000 $ 100,000 $ 50,000 $ 100,000 $ 150,000 $ 500,000 174 Catch Basin Reconstruction $ 53,000 $ 53,000 $ 53,000 $ 53,000 $ 53,060 $ 265,060 175 Storm Sewer Improvements/ Extensions $ 60,000 $ 60,000 $ 60,000 $ 62,400 $ 63,672 $ 306,072 176 Storm Sewer General Repairs $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 500,000 177 Draintile Program $ 20,000 $ 20,000 $ 20,400 $ 20,810 $ 21,224 $ 102,434 178 Storm Sewer Lining and Rehabilitation $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 125,000 $ 525,000 179 Specific Storm Sewer Projects US-52 Central Avenue $ 100,000 $ - $ - $ - $ - $ 100,000 180 Saint Anne Drive Storm Sewer Extension $ 62,500 $ - $ - $ - $ - $ 62,500 181 Northwest Arterial Detention Basin $ 48,500 $ - $ - $ - $ - $ 48,500 182 Hillcrest-Rosemont Detention Basin $ 98,800 $ - $ - $ - $ - $ 98,800 183 Cedar Cross Road Storm Replacement $ 69,700 $ - $ - $ - $ - $ 69,700 184 Jackson Street Storm Sewer (Street Program) $ 30,000 $ - $ - $ - $ - $ 30,000 185 Northridge Drive Storm Sewer $ 19,000 $ 118,200 $ - $ - $ - $ 137,200 186 Admiral Sheehy Drive Flood Gate $ 49,500 $ - $ - $ - $ - $ 49,500 187 Maus Park Culvert $ 200,000 $ - $ - $ - $ - $ 200,000 188 Roosevelt Culvert Reconstruction $ - $ 21,000 $ - $ - $ - $ 21,000 189 Heeb Street Storm Sewer (Street Program) $ - $ - $ 5,000 $ 25,000 $ - $ 30,000 190 University Ave Storm Sewer $ - $ - $ - $ 175,000 $ - $ 175,000 191 Key Way Drive Outfall Project $ - $ - $ - $ 30,100 $ - $ 30,100 192 Copper Field Storm Sewer Extension Project $ - $ - $ - $ 34,700 $ - $ 34,700 193 Seippel Road Culvert Replacement $ - $ - $ - $ 8,000 $ 48,000 $ 56,000 194 Pennsylvania Culvert Replacement $ - $ - $ - $ 25,000 $ 100,000 $ 125,000 195 Keokuk Storm Sewer Extension $ - $ - $ - $ 44,600 $ - $ 44,600 196 Bennett Street Storm Sewer (Street Program) $ - $ - $ - $ - $ 6,000 $ 6,000 197 -183- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE Sylvan Drive Storm Sewer (Street Program) $ - $ - $ - $ - $ 6,000 $ 6,000 198 Windsor Street Storm Sewer Extension $ - $ - $ - $ - $ 80,500 $ 80,500 199 Bies Drive Storm Sewer(Street Program) $ - $ - $ - $ - $ 7,000 $ 7,000 200 Century Drive Storm Sewer $ - $ - $ - $ - $ 15,500 $ 15,500 201 Bee Branch Watershed Projects 22nd Street Storm Sewer Improvements $ 6,654,000 $ 3,436,000 $ - $ - $ - $10,090,000 202 Bee Branch Creek RR Culverts $ 5,729,042 $16,750,000 $ 3,020,958 $ - $ - $25,500,000 203 17th Street Storm Sewer Improvements $ 2,250,000 $ 5,249,980 $ 3,781,000 $ - $ - $11,280,980 205 Flood Control Maintenance Facility $ 25,000 $ - $ - $ 2,500,000 $1,860,000 $ 4,385,000 206 North End Storm Sewers $ - $ - $ - $ 1,410,000 $ - $ 1,410,000 207 Water Plant Flood Protection $ - $ - $ - $ - $2,400,000 $ 2,400,000 208 Bee Branch Green Alleys $ - $ 500,000 $ - $ 500,000 $ 500,000 $ 1,500,000 209 STREETS Public Works Street Related Improvements Street Construction General Repairs $ 75,000 $ 100,000 $ 100,000 $ 100,000 $ 100,000 $ 475,000 210 Guardrail Replacement $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 10,000 $ 50,000 211 Pavement Marking Project $ 135,000 $ 135,000 $ 85,000 $ 135,000 $ 135,000 $ 625,000 212 East-West Corridor Capacity Improvements $ 578,000 $ 4,450,000 $ 150,000 $ 4,150,000 $ - $ 9,328,000 213 Southwest Arterial Project $ 350,000 $ 100,000 $ - $ - $ - $ 450,000 215 Grandview&University Roundabout $ 900,000 $ - $ - $ - $ - $ 900,000 217 HWY 52 Phase IV- Central Avenue Pavement Rehabilitation from 9th Street to 21st Street $ 1,923,000 $ - $ - $ - $ - $ 1,923,000 218 Jackson Street 11th to 12th Street Reconstruction $ 320,000 $ - $ - $ - $ - $ 320,000 219 Derby Grange Road Resurface $ 23,000 $ - $ - $ - $ - $ 23,000 220 Landfill Access Road $ 400,000 $ - $ - $ - $ - $ 400,000 221 7th Street Extension to Pine Street $ - $ - $ - $ - $ 70,000 $ 70,000 222 North Cascade Road Reconstruction $ - $ - $ 1,497,200 $ - $ - $ 1,497,200 223 Heeb Street Reconstruction $ - $ - $ 50,000 $ 200,000 $ - $ 250,000 225 Bies Drive Reconstruction $ - $ - $ - $ - $ 250,000 $ 250,000 226 Bennett Street Reconstruction $ - $ - $ - $ - $ 80,000 $ 80,000 227 Sylvan Drive Reconstruction $ - $ - $ - $ - $ 35,000 $ 35,000 228 Seippel Road Reconstruction $ - $ - $ - $ - $ 280,000 $ 280,000 229 Century Drive Reconstruction $ - $ - $ - $ - $ 200,000 $ 200,000 230 2-Way Conversion Central& White $ - $ 200,000 $ - $ - $ - $ 200,000 231 Sidewalk Related -184- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE Sidewalk Program-City-Owned Property $ 49,391 $ 46,634 $ 45,000 $ 50,000 $ 50,000 $ 241,025 232 Sidewalk Inspection Program- Assessable $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 233 ADA Curb Ramp Construction Project $ - $ 12,600 $ 12,600 $ 12,600 $ 13,000 $ 50,800 234 Sidewalk Program Related Curb and Catch Basin Replacements $ 20,000 $ 10,000 $ 20,000 $ 31,328 $ 25,777 $ 107,105 235 Decorative Concrete Maintenance $ 100,000 $ - $ - $ - $ - $ 100,000 236 Trails/General Maintenance Stone Retaining Walls $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 48,000 $ 248,000 237 Bridge Repairs/Maintenance $ 85,000 $ 95,000 $ 100,000 $ 100,000 $ 108,000 $ 488,000 238 Bee Branch Trail 16th to 9th Street $ - $ 597,000 $ - $ 697,000 $ - $ 1,294,000 239 MISCELLANEOUS General Government Federal Building Renovation $ 160,000 $ 58,864 $ 315,000 $ 390,000 $ 851,734 $ 1,775,598 241 Community and Economic Development Riverfront Dock Expansion $ - $ - $ - $ - $ 150,000 $ 150,000 243 Neighborhood Related Improvement $ - $ 13,400 $ 13,400 $ 15,000 $ 15,000 $ 56,800 244 Riverfront Leasehold Improvements $ 104,000 $ - $ - $ 75,000 $ - $ 179,000 245 Public Works Port of Dubuque-Security Cameras $ - $ - $ - $ 20,000 $ - $ 20,000 246 Port of Dubuque Parking Lot $ 50,000 $ - $ - $ - $ - $ 50,000 247 TRAFFIC Public Works Street Light Replacement and New Installation $ 78,881 $ 93,600 $ 107,000 $ 175,200 $ 183,200 $ 637,881 248 Signalization Program $ 65,000 $ 80,000 $ 80,000 $ 80,000 $ 100,000 $ 405,000 249 Traffic Signal Mastarm Retrofit $ 40,000 $ 80,000 $ 80,000 $ 90,000 $ 95,000 $ 385,000 250 Traffic Signal Interconnect Conduit Replacement $ 25,000 $ 40,000 $ 60,000 $ 60,000 $ 71,000 $ 256,000 251 Traffic Signal Controller Replacement $ 15,000 $ 45,000 $ 45,000 $ 45,000 $ 45,000 $ 195,000 252 Street Lighting and Traffic Signal Knockdown/Insurance $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 150,000 253 Street Camera Installation $ 52,509 $ 125,000 $ 117,476 $ 105,775 $ 114,798 $ 515,558 254 LED Re-lamp schedule $ 10,500 $ 29,000 $ 30,000 $ 52,000 $ 30,000 $ 151,500 255 Traffic Signal Battery Backup Program $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 20,000 $ 100,000 256 Traffic Signal Intersection Reconstruction $ 45,000 $ 65,000 $ 45,000 $ 82,000 $ 82,000 $ 319,000 257 Surge and Grounding Improvements at Signals City- Wide $ - $ 15,000 $ 15,000 $ 15,000 $ 15,000 $ 60,000 258 STREETS Traffic Control Project $ 200,000 $ 100,000 $ 100,000 $ - $ - $ 400,000 259 -185- PRGRM/ DEPT PROJECT DESCRIPTION FY 2019 FY 2020 FY 2021 FY 2022 FY 2023 TOTAL PAGE Traffic Signal Fiber Optics $ — $ 80,000 $ 90,000 $ 90,000 $ 105,000 $ 365,000 260 ITS Traffic Control Equipment $ 19,752 $ 7,200 $ 18,684 $ 7,952 $ 20,000 $ 73,588 261 Traffic Signal Vehicle Detection Conversion $ 42,000 $ — $ — $ — $ 15,000 $ 57,000 262 Grandview Street Light Replacement $ — $ — $ — $ — $ 50,000 $ 50,000 263 Total - Engineering Department 22,844,846 35,540,900 12,682,231 12,754,812 9,567,054 93,389,843 -186-