digital innovation and data integration key to successfully managing charlotte’s sewer rehab...
DESCRIPTION
Since 1997 >2,000,000 LF Rehab’d >2,000,000 LF Rehab’d CIPP CIPP PVC F&F PVC F&F HDPE F&F HDPE F&F Pipe Bursting Pipe Bursting Slip Lining Slip Lining Dig & Replace Dig & Replace >50,000 Manholes Rehab’d >50,000 Manholes Rehab’dTRANSCRIPT
Digital Innovation and Data Digital Innovation and Data Integration Key to Successfully Integration Key to Successfully
Managing Charlotte’s Sewer Managing Charlotte’s Sewer Rehab ProgramRehab Program
Aaron Frazier - Frazier EngineeringAaron Frazier - Frazier EngineeringKeith Shirley - Charlotte WaterKeith Shirley - Charlotte WaterChris Allen – Charlotte WaterChris Allen – Charlotte Water
Charlotte Water’s Charlotte Water’s Service AreaService Area
Population >800,000Population >800,0004,200 miles of sewer4,200 miles of sewer
Mint HillMint Hill
MatthewsMatthews
PinevillePineville
HuntersvilleHuntersville
CorneliusCorneliusDavidsonDavidson
CharlotteCharlotteMecklenburg Co.Mecklenburg Co.
Since 1997Since 1997 >2,000,000 LF Rehab’d>2,000,000 LF Rehab’d
• CIPPCIPP• PVC F&FPVC F&F• HDPE F&FHDPE F&F• Pipe BurstingPipe Bursting• Slip LiningSlip Lining• Dig & ReplaceDig & Replace
>50,000 Manholes Rehab’d>50,000 Manholes Rehab’d
Yearly Rehab Budget and Yearly Rehab Budget and ProgramProgram
Yearly Rehab Budget of $13 millionYearly Rehab Budget of $13 million
Rehab ConstructionRehab ConstructionRoot ControlRoot ControlClean and TV ContractsClean and TV ContractsEngineeringEngineering
Find-and-Fix Annual Contracts Find-and-Fix Annual Contracts Primary Rehab Construction Method - $7 - $8 Primary Rehab Construction Method - $7 - $8
million per year in constructionmillion per year in construction
Fast Tracks Projects from Design to Fast Tracks Projects from Design to ConstructionConstruction
Saves Substantial Time and Money – estimated Saves Substantial Time and Money – estimated
savings of over $8 million since 2000savings of over $8 million since 2000
Massive Amounts of Data Drive the Massive Amounts of Data Drive the Find-and-Fix Annual Contracts. Find-and-Fix Annual Contracts.
Data Integration and Using Digital Data Integration and Using Digital Technology are key to success and Technology are key to success and
quick decisions.quick decisions.
Data Inputs into Rehab DecisionsData Inputs into Rehab Decisions
SSES WorkSSES WorkSmoke TestingSmoke TestingManhole InspectionsManhole Inspections
CCTV DataCCTV Data>500,000 LF/Year>500,000 LF/Year6 different sources6 different sources
Acoustic InspectionAcoustic InspectionSL-RATSL-RAT2 different sources2 different sources
Flow Monitoring DataFlow Monitoring DataTemp and PermTemp and PermSmart CoversSmart Covers
GIS DataGIS Data
Data Inputs into Rehab DecisionsData Inputs into Rehab Decisions
Historical RecordsHistorical RecordsSewer BackupsSewer BackupsCustomer ComplaintsCustomer ComplaintsBackflow PreventersBackflow Preventers
Hot-Spot AreasHot-Spot AreasRoot ControlRoot ControlRoutine O&MRoutine O&MGrease ControlGrease ControlCritical AssetsCritical Assets
Data Inputs into Rehab DecisionsData Inputs into Rehab Decisions
Rehab WorkRehab WorkPast WorkPast WorkCurrent WorkCurrent WorkPlanned WorkPlanned WorkCost of WorkCost of Work
Work by Others:Work by Others:CIP ProjectsCIP ProjectsStormwater Stormwater
ProjectsProjectsPavement Pavement
Resurfacing Resurfacing ProjectsProjects
All of these inputs are reviewed continuously for All of these inputs are reviewed continuously for every rehab area/project issued.every rehab area/project issued.
The rehab projects move very quickly. We The rehab projects move very quickly. We spend $600,000 or more every month on rehab spend $600,000 or more every month on rehab
construction.construction.
The work is all over Charlotte’s extensive The work is all over Charlotte’s extensive service area. Need quick and efficient service area. Need quick and efficient
decisions. decisions.
Data Management ProceduresData Management Procedures ““Old” Procedures:Old” Procedures:
GIS Mapping and InformationGIS Mapping and Information Spreadsheets to track rehab workSpreadsheets to track rehab work Spreadsheets to track other data inputsSpreadsheets to track other data inputs Digital Database/Software for CCTVDigital Database/Software for CCTV InfoNet Software for SSES DataInfoNet Software for SSES Data
All Data Collected and Stored DigitallyAll Data Collected and Stored Digitally
Data Management Data Management DesiresDesires Combine all data into a single location:Combine all data into a single location:
Look at all data at the same timeLook at all data at the same time Quicker and more efficient access to dataQuicker and more efficient access to data Better/easier reporting and trackingBetter/easier reporting and tracking Better access to data by Charlotte WaterBetter access to data by Charlotte Water Cost and time savingsCost and time savings
Required Data OutputsRequired Data Outputs
General ReportingGeneral Reporting Maps……and more mapsMaps……and more maps Data……and more dataData……and more data Report requests….and more requestsReport requests….and more requests Work performed by Basin or AreaWork performed by Basin or Area Decision makersDecision makers Community groupsCommunity groups
Required Data Outputs (cont’d)Required Data Outputs (cont’d)
SSES ReportingSSES ReportingPast SSES ResultsPast SSES ResultsCurrent SSES Areas Current SSES Areas
and Resultsand ResultsPlanned SSES WorkPlanned SSES WorkHistorical Flow DataHistorical Flow Data
Rehab ReportingRehab ReportingPast RehabPast RehabAs-Built DataAs-Built DataCurrent RehabCurrent RehabPlanned RehabPlanned RehabEstimated CostsEstimated Costs
Required Data Outputs (cont’d)Required Data Outputs (cont’d) Issue work directly to SSES Crews and Issue work directly to SSES Crews and
Rehab Contractors – streamlined Rehab Contractors – streamlined process…...process…...
Quickly and Efficiently Coordinate all Quickly and Efficiently Coordinate all Data Inputs with Proposed Rehab Data Inputs with Proposed Rehab Construction WorkConstruction Work
Improved Data Management Improved Data Management ProceduresProcedures
““New” Procedures:New” Procedures:
Upgrade to InfoMaster SoftwareUpgrade to InfoMaster Software GIS integrated with InfoMasterGIS integrated with InfoMaster Move away from stand-alone spreadsheetsMove away from stand-alone spreadsheets
All Data Collected and Stored DigitallyAll Data Collected and Stored Digitally
ResultsResults We upgraded from a “basic” data management We upgraded from a “basic” data management
“system” to a single, robust data management “system” to a single, robust data management software programsoftware program
Data integration and database development have Data integration and database development have been costly and time consuming…but beneficial…been costly and time consuming…but beneficial…
Don’t expect this to be “easy”Don’t expect this to be “easy” Don’t expect this to be “inexpensive”Don’t expect this to be “inexpensive” The costs are on-going and will continue…….The costs are on-going and will continue……. Make sure you are prepared to “tackle” this – Make sure you are prepared to “tackle” this –
time and budgets…time and budgets… “ “New” costs are offset by current data costsNew” costs are offset by current data costs
BenefitsBenefits Data Queries – Improving Data Queries – Improving ↑
Data Outputs – Improving Data Outputs – Improving ↑
Data Reporting and Analyses – Improving Data Reporting and Analyses – Improving ↑
Rehab Tracking – Improving Rehab Tracking – Improving ↑
Rehab Budgeting – Improving Rehab Budgeting – Improving ↑
Benefits (cont’d)Benefits (cont’d)
Coordination of all available data when planning Coordination of all available data when planning and designing rehab work – and designing rehab work – ImprovingImproving
All work within Charlotte is better coordinated All work within Charlotte is better coordinated leading to a very successful rehab programleading to a very successful rehab program
ConsiderationsConsiderations Is our Data Management Plan the right decision Is our Data Management Plan the right decision
for Charlotte??for Charlotte??
Is your current Data Management Plan the right Is your current Data Management Plan the right decision for you??decision for you??
Is comprehensive data management necessary for Is comprehensive data management necessary for your system??your system??
Is the budget available to implement such a Is the budget available to implement such a system??system??
Are you collecting data digitally??Are you collecting data digitally??