So, you reviewed thousands upon thousands of feet of CCTV footage and now you have mountains of great data on your sewer system. Great, but now what? How do you take the time, effort, and spreadsheets teeming with information from your CCTV endeavors and turn them into something that works for you? As your fight-or-flight response begins to kick in, take a moment to collect yourself and know that you’re not alone. Now that you’ve recentered yourself and crept back in from the fire escape, our asset management pro, Tristan Nickel, PE, AWAM, has some insights on putting your data to work.
First order of business: Do you have a preventative maintenance program (PM)? If so, how are you prioritizing your program to ensure you are actually benefiting your system based on the level of effort being conducted? If you answered “no” to either of these questions, that is OK. This is where those mountains of data come into play.
RJN leverages features of InfoAsset Planner software to quickly sift through volumes of CCTV data using highly complex decision trees, assigns criticality scores, and prioritizes sewer segments to reveal answers to next steps. GIS layers serve as the foundation and critical information about your sewer system can be incorporated into the analysis to target hot spots such as areas congested with or likely to have high concentrations of fats, oils, and grease (FOG) build up. Correlating inspection data with locations of high-density housing and commercial dining provides focused recommendations on where the issues are.
“It would take forever to manually go through the massive amounts of data,” Nickel said. “If we run your CCTV review data through the asset management software, we can build a prioritized program that tells you where you have trouble brewing and assist with setting cleaning frequencies for your program (i.e., 3, 6, 9, 12, or 18-month cleaning cycles). When you are armed with actionable intel, your preventative maintenance program becomes a smart tool that focuses your maintenance budgets where they will do the most good.”
This brings us to our second point: The quality of your data is critical to the success of using smart analytics to build a preventive maintenance program. So, do you have an assortment of internal and external sources working on your CCTV inspection program?
“We worked with a client who had major disparities in their data,” Nickel said. “With the lack of uniformity, they were really at a standstill on how to move forward because it was like working with apples and oranges. It was imperative that we help them develop standard operating procedures (SOP) for their CCTV data collection and analysis processes,” he added.
It is important to establish qualification, verification, and quantification procedures that are rooted in standardization. Industry-accepted NASSCO guidelines provide a sound starting point with clear standards for processes and categorizing pipeline conditions based on criticality and severity of pipeline defects. Implementing workflows for accepting and reviewing CCTV and establishing defined QA/QC checkpoints and measures prior to acceptance will produce consistent data that will flow into the analysis process and produce consistent results for sound decision making.
“Our client’s high-volume of CCTV footage and variances in data quality meant that each city analyst spent more than 50% of their time on follow-up, which caused their annual maintenance program to fall behind.” Nickel said, “To remedy this, we worked with the city to develop SOPs to develop requirements for CCTV data deliverables and quality control measures. We then facilitated data workshops with city staff and their contractors to establish expectations and get everyone on the same page.” If you are looking to efficiently turn your CCTV data into usable intelligence, it is important to standardize the data for consistency so you can be confident planning is using apples to apples analyses. Smart analytical tools will use your unique requirements to transform your data into budgetable and actionable short- and long-term maintenance plans.