Atlanta City Council City Utilities Committee Department Quarterly

  • Slides: 45
Download presentation
Atlanta City Council | City Utilities Committee Department Quarterly Report Mayor Keisha Lance Bottoms

Atlanta City Council | City Utilities Committee Department Quarterly Report Mayor Keisha Lance Bottoms | Kishia L. Powell, Commissioner April 24, 2018 1

Reports to Council 2

Reports to Council 2

DWM Cyber Update • • No impacts to water and wastewater treatment operations or

DWM Cyber Update • • No impacts to water and wastewater treatment operations or water quality Manual processes implemented for compliance tracking; Monthly monitoring reports submitted on time No impacts to water and wastewater emergency services response Scheduling backlog work impacted due to Hansen application being down Metering and Billing Services – Meter reading and billing has resumed, although customers who receive an electronic statement via email will now receive a paper bill until further notice – Some customers may see a higher than normal bill due to the additional days captured in the billing cycle prior to the meter being read Cash Applications/Operations – The ability to take credit/debit cards was restored as part of our payment options at the Customer Care Centers in City Hall and 72 Marietta – Checks, Cashier Checks, and Money Orders are being accepted – Customers can make a one-time payment via www. payatlwateronline. com; the account number and last name of the account holder is required – All customer account payments have been posted to accounts for the month of March Collections Operations – Property Pay-Off Information: Pay-Off Requests were within current SLA by close of business Monday 4/9/18 – Pay-off checks received from closing attorneys were posted and updated in the system Late payment fees have been suspended until all payment methods have been fully restored 3

Water Loss Audit • 2017 Audit included 12 recommendations; DWM Agreed with each recommendation

Water Loss Audit • 2017 Audit included 12 recommendations; DWM Agreed with each recommendation Final Recommendations – 2017 Audit Implementation Timeframe Actions/Status 1 Conduct on-going leak detection December 2017 Implemented/Ongoing This program has been in place, but has been expanded since the audit was completed. 2 Document clear data management May 2017 policies to best track municipal leaks and breaks and estimate volume Implemented/Ongoing Currently being tracked in the field by OLIO 3 Estimate and add resources to manage vacant accounts Fully Implemented/Ongoing Key positions are filled; New and remaining vacancies are being given priority as suitable candidates are found. 4 Implement system to alert customers of suspected leaks August 2017 Implemented/Ongoing This program is actively being implemented by OCCBS. 5 Finalize SOP for tracking hydrant meters; enforce provisions to track meters and collect billing data June 2017 Implemented/Ongoing This program is actively being implemented by OFA. 6 Finalize Water Loss Control Program June 2017 Implemented/Ongoing The program elements are all active and in place in OLIO, OES, OWTR and OWP. Refinements are ongoing. CUC 2018 Goals & Objectives #2 4

Water Loss Audit Final Recommendations – 2017 Audit Implementation Timeframe Actions/Status 7 Select specific

Water Loss Audit Final Recommendations – 2017 Audit Implementation Timeframe Actions/Status 7 Select specific goals/KPIs for the water loss control plan December 2017 Implemented/Ongoing – Additional goals and KPIs under development Reported through OPA, but significant additional opportunities are available and being explored. 8 Include leak management and capital improvement plan initiatives December 2017 In Progress/Ongoing – Phase 1 to be completed June 2018 Satellite leak program in progress, good success (30 leads found after investigating 100 potential sites). Program expansion planned by OES (Asset Management) and OLIO. 9 Water Loss Team meet at least twice a year December 2017 In Progress – Pending EPD Coordination Initial team meeting being planned for Water Loss training by EPD. Schedule pending EPD scheduling – OPA 10 Participate in voluntary GAWP distribution system audits March 2019 In Progress/Ongoing Scheduled for March 2019 - Pending direction from GAWP 11 Track goals and volume of water saved from apparent and real losses May 2017 Implemented/Ongoing This program is actively being implemented by OFA. 12 Submit annual water audits to AWWA for benchmarking and comparison June 2017 Implemented/Ongoing First submittal to AWWA in April 2018. CUC 2018 Goals & Objectives #2 5

Satellite Leak Detection Pilot Program Provider: Hydromax USA Cost and duration: $147, 000; six

Satellite Leak Detection Pilot Program Provider: Hydromax USA Cost and duration: $147, 000; six months Scope: Three deliverables, 500 miles each; 100 suspected leaks to be correlated per deliverable Progress to date: – Kick-off January 19, 2018 – First image acquisition February 27, 2018 – Field verification March 20, 2018 - April 5, 2018 • 31 of 100 suspected leaks confirmed by correlation • 1 of 2 correlated subsurface leak verified by excavation – Second image acquisition March 27, 2018 • Field verification for second pass – Estimated start in May 2018 6

HIGHLIGHTS OF THE CLEAN WATER ATLANTA PROGRAM With the help of MOST revenues, the

HIGHLIGHTS OF THE CLEAN WATER ATLANTA PROGRAM With the help of MOST revenues, the City has been able to: • Repair and replace old, decrepit sewer lines in compliance with two federal consent decrees • 375 miles of small sewer rehabilitation • 57 square miles of capacity relief • Increase sewer capacity throughout the City, supporting over $5 billion in development that would otherwise not have happened • Achieve a 62% reduction in the number, and 97% reduction in volume of sewer spills between 2004 and 2018 7

Two Consent Decrees Required Atlanta to Address Combined and Sanitary Sewer Overflows at an

Two Consent Decrees Required Atlanta to Address Combined and Sanitary Sewer Overflows at an Estimate of $4 billion by 2027 8

Two Consent Decrees Required Atlanta to Address Combined and Sanitary Sewer Overflows at an

Two Consent Decrees Required Atlanta to Address Combined and Sanitary Sewer Overflows at an Estimate of $4 billion by 2027 9

Consent Decree Project Accomplishments Old Fourth Ward Capacity Relief Ponds Cost: $25 M Economic

Consent Decree Project Accomplishments Old Fourth Ward Capacity Relief Ponds Cost: $25 M Economic Impact: 387 jobs Completed: June 2011 Cost Savings: $15 M Highlights: Old Fourth Ward Park serves as a stormwater run-off pond designed to eliminate neighborhood flooding. The park was designed through a unique community partnership, while driving $475 M in economic development Nancy Creek Tunnel Cost: $164 M Economic Impact: 2, 542 jobs Completed: December 2005 Highlights: Significant spill reduction and improved quality of life in Buckhead 10

Consent Decree Project Accomplishments Proctor Creek Tunnel Diversion Cost: $1. 67 M Economic Impact:

Consent Decree Project Accomplishments Proctor Creek Tunnel Diversion Cost: $1. 67 M Economic Impact: 25 jobs Completed: October 2006 Highlights: Automated facility helps to manage peak flow system conditions and allows for diversion of up to 20 MGD from RM Clayton to Utoy Creek Sewer Groups 1 & 2 Rehabilitation and Capacity Upgrades Cost: $700 M Economic Impact: 10, 850 jobs Completed: July 2014 Highlights: Improve sewer system reliability through elimination of structural defects found during SSES. Construct new sewers to provide adequate, reliable longterm, peak wet weather capacity. 11

Clean Water Atlanta Consent Decree Capital Needs Original CIP Budget Current CIP Forecasted Budget

Clean Water Atlanta Consent Decree Capital Needs Original CIP Budget Current CIP Forecasted Budget Expenditures to date Anticipated Need through 2027 Consent Decree Program (CSO) Projects Completed $1, 055, 575, 934 $741, 365, 162 $720, 196, 497 $0 First Amended Consent Decree Program (SSO) 1, 536, 611, 306 1, 868, 519, 047 1, 073, 445, 246 795, 073, 801 $2, 592, 187, 240 $2, 609, 884, 210 $1, 793, 641, 742 $795, 073, 801 Subtotal Regulatory 140, 323, 304 147, 980, 508 136, 154, 543 11, 825, 965 Renewal and Extension 232, 029, 004 840, 743, 508 204, 641, 845 636, 101, 663 $372, 352, 308 $988, 724, 016 $340, 796, 389 $647, 927, 628 Subtotal Total Wastewater Projects Source: Department of Watershed Management Clean Water Atlanta Program 1998 - 2027 Wastewater Program Baseline Summary Report $2, 964, 539, 548 $3, 598, 608, 225 $2, 134, 438, 131 $1, 443, 001, 429 12

Administrative Highlights 13

Administrative Highlights 13

Positions: Filled & Vacancy Report # Positions: 1756 Position Status: 84% Authorized Positions: 1668,

Positions: Filled & Vacancy Report # Positions: 1756 Position Status: 84% Authorized Positions: 1668, 96% 88, 4% 1600 1400 1200 1000 800 1398, 84% 600 400 Active 400 200 Extra Help 1398, 84% 600 270, 16% Vacant 0 Filled 245 200 25 0 Filled On-boarding Vacant Notes: Filled/Vacancy by Office 83% 85% occupancy rate w/on-boarding (candidate identified/selected) 45. 5% of the vacancies are within OLIO • • 600 75% 500 400 89% 300 86% 200 100 85% 83% 95% 75% 80% 0 IT OCCBS OCCR OCO OES OFA Fillled OLIO OPA 87% OSS 95% 86% 88% OWP OFM OAM OWTR Vacant 14

FY 2018 Budget Financial Resilience Appropriations ($610 M) Revenue Sources ($610 M) $34; 6%

FY 2018 Budget Financial Resilience Appropriations ($610 M) Revenue Sources ($610 M) $34; 6% Operation & Maintenance $125; 20% $30; 5% $17. 5 $255; 42% $119. 9 $450; 74% $46. 8 $325; 53% Water & Sewer Other $70. 3 MOST Operation & Maintenance Other Departments Misc • Miscellaneous: IJ Revenue, tap meter sales, stormwater Purchases Services Personnel Supplies Non-Departmental • Non-Departmental (Debt Service, indirect costs, PILOT/franchise fees, OPEB, charges, interest earnings, administrative services GEFA payments/reserve, bad debt reserve, fund-wide reserve) OPERATION & MAINTENANCE (O&M) Personnel Non-Personnel FY 18 Budget $119. 0 $134. 7 Through 3 rd QTR of FY 18 $85. 4 $66. 2 % Spent 71. 8% 49. 2% *July 1, 2017 through March 30, 2018. 15

FY 18 Operational Results Financial Resilience $ 600 Fiscal Year 2018 $ 445. 6

FY 18 Operational Results Financial Resilience $ 600 Fiscal Year 2018 $ 445. 6 $ 500 Month $ 457. 4 Projected $ 417. 6 $ in millions) $ 400 $ 300 $ 200 $ 100 $ Jul Aug Sep Oct Nov Dec Jan FY'18 Projected Revenues (M)* Feb Mar Apr May Jun Expenses Actual Jul '17 $52. 2 $50. 9 $24. 7 Aug '17 $106. 4 $104. 0 $49. 3 Sep '17 $154. 9 $157. 6 $74. 6 Oct '17 $205. 3 $216. 3 $232. 4 Nov '17 $254. 1 $265. 5 $260. 7 Dec '17 $298. 9 $313. 0 $293. 8 Jan '18 $345. 8 $366. 2 $322. 9 Feb '18 $385. 5 $413. 9 $347. 3 Mar '18 $433. 8 $457. 4 $445. 6 Apr '18 $478. 8 May '18 $527. 3 Jun '18 $575. 2 * Does not include miscellaneous revenues FY'18 Actual Revenue FY'18 Actual Expenses 16

Collections Efforts Commercial Accounts (OFA) FY 18 Performance • $5, 845, 889. 88 collected

Collections Efforts Commercial Accounts (OFA) FY 18 Performance • $5, 845, 889. 88 collected • 2, 533 delinquent payments collected Next Steps • Continue to maximize collection efforts with site visits by collections staff for larger commercial water users. • Increasing cuts from 50 to 85 -100 per week. Vacant Accounts (OFA & OSS) FY 18: Performance Commercial (OFA) • $2, 178, 251. 96 collected • 178 new service accounts enforcement Residential (OSS) • $110, 302. 85 collected • 574 new service accounts enforcement. Next Steps • New service policies and procedures currently under review to identify best practices, process efficiencies, and controls. *July 1, 2017 through March 30, 2018. Multi-Family Accounts (OFA) FY 18: Performance • $7, 016, 943. 51 collected • 1, 981 delinquent payments collected. • Top 50 delinquent accounts isolated for collection efforts Next Steps • Execute disconnection strategy with stakeholders to coordinate essential services by March 2018. • Work with DOL about suggested code changes to enhance City’s legal position and collection abilities. 17

Vacant Accounts w/ Consumption Financial Resilience Vacant Accounts with Consumption (Residential and Commercial) •

Vacant Accounts w/ Consumption Financial Resilience Vacant Accounts with Consumption (Residential and Commercial) • 800 1, 000 700 900 600 800 700 500 600 400 500 300 400 200 100 0 Oct-17 Dec-17 Jan-18 Feb-18 Oct-17 Nov-17 Dec-17 New Accounts 445 129 123 146 Resolved Accounts 693 310 161 174 Open Accounts 933 685 504 476 Open Accounts Number of New and Resolved Accounts Resolved Oct. 2017 through Feb. 2018 • • 300 200 100 • DWM has reduced accounts with vacant consumption by more than 87% from February 2017 to February 2018. Maintaining a 96% or better customer satisfaction rating at the Customer Service Walk-In Center Improved process of customer data reviews, field verifications and meter repairs, resulting in increased revenue of $2. 5 M annually A/R REDUCTION: $2. 3 M for the last quarter of 2017 0 Feb-18 148 180 444 18

Operational Highlights 19

Operational Highlights 19

Service Metrics 20

Service Metrics 20

Main Breaks Infrastructure Reliability Main Breaks by Month 140 120 100 80 60 40

Main Breaks Infrastructure Reliability Main Breaks by Month 140 120 100 80 60 40 20 18 b. Fe 18 Ja n- 17 ec D 17 ov - 7 N -1 ct O 17 p. Se 17 g. Au l-1 7 Ju 17 n. Ju 17 ay - 7 M r-1 Ap -1 7 M ar 17 b. Fe 17 n. Ja 16 ec D 16 ov - 6 N -1 O ct 16 p. Se 16 g. Au Ju l-1 6 0 * The upward trend of main breaks continued into January with our secondhighest month of recorded main breaks since 2010. 21

Metal Plate Tracker Number of Plates in Place (Mar. 28, 2018): 25* Average Age

Metal Plate Tracker Number of Plates in Place (Mar. 28, 2018): 25* Average Age of Current Plates: 91 Days* Council District Install Dates of Current Plates 7 12 6 10 5 8 4 6 3 4 2 2 1 ut 12 of C O A O 11 10 9 8 7 6 5 4 3 2 1 -1 8 0 M ar 18 b. Fe 18 n. Ja 17 17 ec D 7 ov N -1 ct O 17 p. Se 17 g. Au Ju l-1 7 0 *Data as of March 28, 2018 22

Utility Cut Restoration Efforts Summary as of March 14, 2018: • The Office of

Utility Cut Restoration Efforts Summary as of March 14, 2018: • The Office of Linear Infrastructure Operations (OLIO) has partnered with the Department of Public Works (DPW) to catch up on backlog of utility cut restoration needs • Total number of restoration work orders in backlog as of June 1, 2017: 2, 634. • Total number remaining as of March 14, 2018: 571 • Restoration work order backlog has decreased by 2, 063 as a result of OLIO re-prioritizing work; physical verification of locations and closing work orders confirmed as completed. • DPW’s Contractor has a total of 3 working crews dedicated to addressing backlog restoration repairs, as of March 14, 2018 • Total number of work orders delivered to DPW for repair: 367 • Total number of work orders completed by DPW’s Contractor: 116 23

Compliance 24

Compliance 24

Drinking Water Quality Exceedence - Total Trihalomethanes (TTHM) • US EPA Disinfection Byproducts Rule

Drinking Water Quality Exceedence - Total Trihalomethanes (TTHM) • US EPA Disinfection Byproducts Rule (DBPR) - 2006 – – – • • DWM monitors 12 US EPA-approved sites throughout the distribution system Exceedance at Sampling Site 501 - 10745 Rivertown Road in the southern portion of Fulton County – – • 2017 four (4) quarter average: 80. 07 ug/L > 80 ug/L MCL Potentially affected 16 customer connections downstream Received Georgia EPD Notice of Violation on March 19, 2018 – – – • Requires monitoring for chemicals that can occur from the breakdown of disinfection chemicals used to remove harmful bacteria from drinking water DWM monitors for a group of four (4) chemicals known as Total Trihalomethanes (TTHM) TTHM Maximum Contaminant Level (MCL) = 80 micrograms per liter (ug/L) based on a 4 quarter average Required “Tier 2” customer notifications of exceedence within 30 days Precautionary notification of potential health effects from long term exposure to TTHMs (70 years) Notifications issued: • Explanatory letters sent to potentially affected customers by USPS Certified Mail – 4/9/2018 • Public notice published in the AJC – 4/12/2018 Corrective Actions – Completed November, 2017 – – – Distribution system valve replacement near Stonewall Tank Installation of a permanent auto-flusher to remove “aged” water and bring in “fresh” water Sample results for Q 1 -2018 indicate water quality has been restored 25

National Pollutant Discharge Elimination System (NPDES) Permit Compliance Status Q 1 -2018 NPDES VIOLATIONS

National Pollutant Discharge Elimination System (NPDES) Permit Compliance Status Q 1 -2018 NPDES VIOLATIONS - 13 10 3 West Area WQCF Clear Creek CSCF 0 0 Tanyard Creek CSCF 0 North Avenue CSCF 0 Cause Mitigation Operational – 10 • • Consolidated Limits 0 Custer Avenue CSCF RM Clayton WRC 0 East Area WQCF Facility Consolidat ed Limits 0 Utoy Creek WRC RM Clayton WRC 0 Sout River WRC 12 10 8 6 4 2 0 Number of Violations Phosphorous Limits – 4 Total Suspended Solids Limit – 6 Operational - 3 • • RM Clayton Facility Headworks construction is complete; Post-construction operational optimization in progress • Zero (0) Violations for March 2018 Phosphorous Limits – 3 26

Spill Data Compliance All Spills Quarter 2015 2016 2017 2018 Q 4 76 32

Spill Data Compliance All Spills Quarter 2015 2016 2017 2018 Q 4 76 32 35 - Q 3 39 28 28 - Q 2 47 41 58 - Q 1 32 88 56 37 Total 194 189 179 37 17 9 15 3 14 21 21 16 YTD Major Spills (> 10, 000 Gallons) YTD Spills Prevented (Flow Monitoring Alert Program) Major Spills for the Quarter No Date/Location/Receiving Water Details 1 1/5/18 2138 FAULKNER RD NE –PEACHTREE • Volume 18, 750 gallons, collapse, repaired 2 1/8/18 1500 JAMES JACKSON PKWY-PROCTOR CREEK • Volume: 32, 100 gallons, debris, cleared 1/11/18 5675 BUCKNELL DR SW-UTOY CREEK • Volume: 870, 000 gallons, contractor bypassed sewer repair line into treated effluent tunnel from South River Plant 3 27

Capital Improvement Plan Updates 28

Capital Improvement Plan Updates 28

Watershed Management Master Plans • DWM maintains masterplans to inform capital investment needs and

Watershed Management Master Plans • DWM maintains masterplans to inform capital investment needs and operational decisions • Masterplans must align with the Metropolitan North Georgia District’s Water Resources Plan – New plan approved in 2017 • Current masterplans completed in 2014 – Water Treatment and Distribution – Wastewater Collection and Reclamation – Watershed Protection • DWM will kick-off masterplan updates in April 2018; integrated approach, incorporate City Design needs, Resilient Atlanta outlook, expected growth 29

Watershed Management Master Plans Water Treatment and Distribution • • 50 -Year Planning Horizon

Watershed Management Master Plans Water Treatment and Distribution • • 50 -Year Planning Horizon • Hemphill, Chattahoochee, & Atlanta-Fulton County Water Treatment Facilities; 6 Pump Stations; 12 Finished Water Storage Tanks; distribution system (3 Pressure Zones) Water Demand Projections through 2060 • 2011 water demand (MGD): 98 AADD, 143 MDD • 2060 water demand (MGD): 153 AADD, 224 MDD Water Supply Evaluation • Withdrawal from Chattahoochee River expected to meet AADD through 2060 & MDD through 2035 Hydraulic Modeling • High & low pressure points were identified in the distribution system • 12% of points exceeded 150 psi (maximum) • <1% did not exceed 40 psi (minimum) • Modeling resulted in recommended changes to the pressure zones MGD – million gallons per day; AADD – Annual Average Daily Demand; MDD – Maximum Day Demand 30

Watershed Management Master Plans Water Treatment and Distribution • Capital Improvement Plan Summary •

Watershed Management Master Plans Water Treatment and Distribution • Capital Improvement Plan Summary • Improvements to the distribution system to meet fire service flows • Increase in finished water storage tank capacity • Distribution system reliability & redundancy via distribution mains • Improvements to overall water quality via treatment plant upgrades Project Description Short-term water treatment facility improvements Cost (2013 dollars) $91 M Pipeline improvements $390 M Pump station improvements $6. 5 M Pressure zone improvements $1. 7 M Storage tank improvements $53 M Studies, research, & planning $3. 5 M Total $550 M 31

Watershed Management Master Plans Wastewater Collection and Reclamation • • 50 -Year Planning Horizon

Watershed Management Master Plans Wastewater Collection and Reclamation • • 50 -Year Planning Horizon • Four water reclamation centers; 1, 574 miles of combined and separate sanitary sewers; 16 collection system pump stations; 14 force mains; five tunnels; four tunnel pump stations; six combined sewer control facilities and two water quality control facilities Wastewater Demand Projections through 2060 • Wastewater demand for RM Clayton WRC, Utoy WRC and South River WRC: • 2011 wastewater demand (MGD): 108 AA, 130 MM • 2060 wastewater demand (MGD): 155 AA, 185 MM 32

Watershed Management Master Plans Wastewater Collection and Reclamation • Capital Improvement Plan Summary •

Watershed Management Master Plans Wastewater Collection and Reclamation • Capital Improvement Plan Summary • Evaluation of strategies to produce Class A bio-solids, including thermal drying, thermal hydrolysis, & enhanced anaerobic digestion • Energy reduction strategies including Energy Conservation Measures (ECM’s) & increased energy production via biogas • Nutrient Recovery by Ostara Pearl ® Nutrient Recovery Process • Recommended Improvements to Asset Management & CMOM • Modifications to RM Clayton WRC headworks (currently underway via design-build) CIP Project Area Water Reclamation Centers (WRCs) FY 2013 -2018 FY 2018 -2030 FY 2031 -2060 $430 Million $690 Million $1. 4 Billion CSO Facilities $57 Million $28 Million $9. 2 Million Pump Stations $78 Million $25 Million $270 Million $350 Million Sewer Mains Total $830 Million $1. 1 Billion N/A $900 Million $2. 3 Billion 33

Watershed Management Master Plans Watershed Protection • CITY OF ATLANTA Watershed Areas 10 major

Watershed Management Master Plans Watershed Protection • CITY OF ATLANTA Watershed Areas 10 major surface watersheds • • 50 -Year Planning Horizon • Challenges to Watershed • Increased impervious area resulting in more runoff & pollutant loading; • higher level in streams; lower base flow; decreased infiltration Prioritization of Drainage Improvements Projects • 62 locations investigated, 51 recommended projects Proctor Creek Watershed Study • Infrastructure inventory, stream assessment, sediment transport modeling Pipe Criticality Assessment • Replacement costs & prioritization using criticality scores • Proposed Long-Term Action Plan Hydrology, biology, habitat, water quality, community health, economy 34

Watershed Management Master Plans Watershed Protection CITY OF ATLANTA Watershed Areas 10 major surface

Watershed Management Master Plans Watershed Protection CITY OF ATLANTA Watershed Areas 10 major surface watersheds • Capital Improvement Program Summary • Watershed management: Planning, long-term modeling & TMDL implementation plan • Infrastructure: Green infrastructure, improve drainage, repair & replacement existing infrastructure, Proctor Creek watershed improvements • Data & Information Management: Manage existing assets, understand performance, identify future activities • Operations & Maintenance: Inspection, cleaning, compliant response, repairs, street sweeping, maintenance CIP Project Category Cost (low) Cost (high) Watershed & Stormwater Planning $50 M $75 M Data & Information Management $20 M $30 M Drainage $300 M $700 M Water Quality $500 M $800 M Green Infrastructure $220 M $420 M Repair & Replacement $500 M $800 M Operation & Maintenance $450 M $600 M Total $2. 1 Billion $3. 5 Billion 35

Watershed Improvement Plans – 2014 to 2017 • • Watershed Improvement Plans (WIPs) prepared

Watershed Improvement Plans – 2014 to 2017 • • Watershed Improvement Plans (WIPs) prepared as part of the required watershed improvement planning activities 10 watersheds prioritized in 2012 Updated WIPs completed by December 2017 Total of 978 project opportunities identified at an estimated cost of $507 M Project Type Green Infrastructure Stream Restoration New Stormwater Control Measure Retrofit Stormwater Control Measure TOTAL # of Projects 699 66 75 138 978 Cost $278, 508, 000 $71, 131, 000 $77, 855, 000 $79, 777, 000 $507, 271, 000 36

DWM Capital Program & Long-term Needs Long-term Infrastructure Need Water System $1. 4 B

DWM Capital Program & Long-term Needs Long-term Infrastructure Need Water System $1. 4 B Watershed Protection $3. 4 B Long-Term Need of $8. 3 Billion Based on 2014 Master Plans Overview of 5 -year CIP Watershed Protection $32. 8 General $126. 4 Water Supply Program $400. 0 Green Infrastructure $53. 6 Upper Proctor Creek $45. 6 Current 5 -YR Capital Improvement Program $1. 26 Billion Water Facilities $9. 3 Wastewater System $4. 2 B Meet Service Levels Meet Compliance Goals Operational Resiliency Water Distribution $126. 1 Wastewater Facilities $361. 7 $872 M Committed Wastewater Collection $151. 7 $718 M Under Contract $444 M Expenditures 37

Current Capital Program

Current Capital Program

Current Project Highlights Water Supply Program Authorized Budget: $342 M Economic Impact: 5, 301

Current Project Highlights Water Supply Program Authorized Budget: $342 M Economic Impact: 5, 301 jobs Ongoing Highlights: Securing Atlanta's water future. Increasing water supply from 3 days to 30 days. Protecting $100 M in daily economic activity Updates • Quarry and Hemphill Pump Stations – Completion by December 2018 • Conveyance tunnel: 10’ dia. ; 15, 640 of 23, 800 feet excavated by Driller Mike • Tunneling operation has stopped due to water intrusion; will resume after testing • Condition assessment and cleaning of debris in raw water mains at Hemphill WTP completed in April 2018. • Hemphill PS 5 Shafts completed in March 2018 • 90 MGD Chattahoochee PS design – May 2018 expected completion • Program completion on track for October 2019 39

Current Project Highlights Clean Water Atlanta Consent Decree Program – General and Sewer Group

Current Project Highlights Clean Water Atlanta Consent Decree Program – General and Sewer Group 3 (SG 3) Authorized Budget (Projects): TBD Economic Impact: TBD Ongoing – Compliance Milestone July 2020 Highlights: Implementation of projects to comply with SSO Consent Decree entered in 1999 for Clean Water Act compliance. Updates • General • Completed engineering design for (7) CWA capital projects • Completed critical sewer repairs for total of 52 sites in support of OLIO • Submitted Quarter 4 2017 CSO & 2 nd Half 2017 Semi-Annual SSO reports to EPA/EPD • SG 3 Small diameter rehabilitation – Const. start Q 2 (Contracts B and C); Q 3 (Contract D) • SG 3 Capacity Relief Projects • Ashby-Jett Trunk – Anticipated construction start Q 2 2018 • Terrell Creek Trunk – Procurement Phase; Anticipated construction start Qtr. 3 2018 • Lower Proctor Creek Trunk – Pending advertisement Q 2 2018 40

Current Project Highlights Peachtree Creek Trunk Sewer Stabilization Cost: $36. 9 M Economic Impact:

Current Project Highlights Peachtree Creek Trunk Sewer Stabilization Cost: $36. 9 M Economic Impact: 571 jobs Pending Construction Highlights: Cleaning and trenchless rehabilitation of approx. 11, 000 LF 90" diameter 80 year old sewer to reduce inflow and infiltration, safeguard against future breaches, and ensure long-term structural integrity of sewer. Updates • Anticipated Construction start Q 2 2018 41

Current Project Highlights Rodney Cook Sr. Park-Historic Vine City Cost: $22 M Economic Impact:

Current Project Highlights Rodney Cook Sr. Park-Historic Vine City Cost: $22 M Economic Impact: 341 jobs Ongoing Highlights: Collection of innovative stormwater practices designed to redirect surface runoff away from the combined sewer system. Updates • Soil Remediation on-going • GA Power Transmission line relocation began April 2018 • Project completion scheduled November 2018 42

Current Project Highlights Renew Atlanta Water Line Replacement Projects Cost: $8. 5 M Economic

Current Project Highlights Renew Atlanta Water Line Replacement Projects Cost: $8. 5 M Economic Impact: 131 jobs Ongoing Highlights: A reduction in street leaks/main breaks. Ongoing asset management efforts to provide reliable, safe, clean drinking water and upgrade the distribution system. Updates • Construction began in March 2017 • Working closely with Renew ATL • Assessed 194 projects • Designed 37 water main replacement projects • Construction of 11 water main replacements is complete • Approximately 24, 000 LF of water main replaced to date and in service • One site is currently under construction, totaling 3, 500 LF; should be finished by end of April • Highlighted numbers in figure to the right are completed 43

MOST-Funded Stormwater Projects FY 2018 15 Projects 11 Completed 3 Under Construction 1 Remaining

MOST-Funded Stormwater Projects FY 2018 15 Projects 11 Completed 3 Under Construction 1 Remaining Before After 44

Questions & Answers 45

Questions & Answers 45