1 / 20

Aaron Frazier - Frazier Engineering Keith Shirley - Charlotte Water Chris Allen – Charlotte Water

Digital Innovation and Data Integration Key to Successfully Managing Charlotte’s Sewer Rehab Program. Aaron Frazier - Frazier Engineering Keith Shirley - Charlotte Water Chris Allen – Charlotte Water. Davidson. Cornelius. Charlotte Water’s Service Area Population >800,000

tater
Download Presentation

Aaron Frazier - Frazier Engineering Keith Shirley - Charlotte Water Chris Allen – Charlotte Water

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Digital Innovation and Data Integration Key to Successfully Managing Charlotte’s Sewer Rehab Program Aaron Frazier - Frazier Engineering Keith Shirley - Charlotte Water Chris Allen – Charlotte Water

  2. Davidson Cornelius Charlotte Water’s Service Area Population >800,000 4,200 miles of sewer Huntersville Mecklenburg Co. Charlotte Mint Hill Matthews Pineville

  3. Since 1997 • >2,000,000 LF Rehab’d • CIPP • PVC F&F • HDPE F&F • Pipe Bursting • Slip Lining • Dig & Replace >50,000 Manholes Rehab’d

  4. Yearly Rehab Budget and Program Yearly Rehab Budget of $13 million Rehab Construction Root Control Clean and TV Contracts Engineering

  5. Find-and-Fix Annual Contracts Primary Rehab Construction Method - $7 - $8 million per year in construction Fast Tracks Projects from Design to Construction Saves Substantial Time and Money – estimated savings of over $8 million since 2000

  6. Massive Amounts of Data Drive the Find-and-Fix Annual Contracts. Data Integration and Using Digital Technology are key to success and quick decisions.

  7. Data Inputs into Rehab Decisions GIS Data SSES Work • Smoke Testing • Manhole Inspections CCTV Data • >500,000 LF/Year • 6 different sources • Acoustic Inspection • SL-RAT • 2 different sources • Flow Monitoring Data • Temp and Perm • Smart Covers

  8. Data Inputs into Rehab Decisions Historical Records • Sewer Backups • Customer Complaints • Backflow Preventers • Hot-Spot Areas • Root Control • Routine O&M • Grease Control • Critical Assets

  9. Data Inputs into Rehab Decisions Rehab Work • Past Work • Current Work • Planned Work • Cost of Work • Work by Others: • CIP Projects • Stormwater Projects • Pavement Resurfacing Projects

  10. All of these inputs are reviewed continuously for every rehab area/project issued.The rehab projects move very quickly. We spend $600,000 or more every month on rehab construction.The work is all over Charlotte’s extensive service area. Need quick and efficient decisions.

  11. Data Management Procedures • “Old” Procedures: • GIS Mapping and Information • Spreadsheets to track rehab work • Spreadsheets to track other data inputs • Digital Database/Software for CCTV • InfoNet Software for SSES Data • All Data Collected and Stored Digitally

  12. Data Management Desires • Combine all data into a single location: • Look at all data at the same time • Quicker and more efficient access to data • Better/easier reporting and tracking • Better access to data by Charlotte Water • Cost and time savings

  13. Required Data Outputs General Reporting • Maps……and more maps • Data……and more data • Report requests….and more requests • Work performed by Basin or Area • Decision makers • Community groups

  14. Required Data Outputs (cont’d) SSES Reporting • Past SSES Results • Current SSES Areas and Results • Planned SSES Work • Historical Flow Data • Rehab Reporting • Past Rehab • As-Built Data • Current Rehab • Planned Rehab • Estimated Costs

  15. Required Data Outputs (cont’d) • Issue work directly to SSES Crews and Rehab Contractors – streamlined process…... • Quickly and Efficiently Coordinate all Data Inputs with Proposed Rehab Construction Work

  16. Improved Data Management Procedures • “New” Procedures: • Upgrade to InfoMaster Software • GIS integrated with InfoMaster • Move away from stand-alone spreadsheets • All Data Collected and Stored Digitally

  17. Results • We upgraded from a “basic” data management “system” to a single, robust data management software program • Data integration and database development have been costly and time consuming…but beneficial… • Don’t expect this to be “easy” • Don’t expect this to be “inexpensive” • The costs are on-going and will continue……. • Make sure you are prepared to “tackle” this – time and budgets… • “New” costs are offset by current data costs

  18. Benefits • Data Queries – Improving ↑ • Data Outputs – Improving ↑ • Data Reporting and Analyses – Improving ↑ • Rehab Tracking – Improving ↑ • Rehab Budgeting – Improving ↑

  19. Benefits (cont’d) • Coordination of all available data when planning and designing rehab work – Improving • All work within Charlotte is better coordinated leading to a very successful rehab program

  20. Considerations • Is our Data Management Plan the right decision for Charlotte?? • Is your current Data Management Plan the right decision for you?? • Is comprehensive data management necessary for your system?? • Is the budget available to implement such a system?? • Are you collecting data digitally??

More Related