The importance of reliable, consistent data in the sewer inspection industry cannot be overstated.
As asset management programs become more sophisticated and data-driven decision-making continues to evolve, organizations must ensure that the information they rely on is both accurate and usable over time. Recognizing this need, NASSCO has developed conversion tables designed to assist users in transitioning legacy Pipeline Assessment Certification Program data from Version 6 to Version 7, and from Version 7 to Version 8.
PACP has undergone several updates over the years to improve clarity, standardization and overall quality of condition assessment data. And with each new version comes a challenge: how to effectively use and preserve the vast amount of data collected under previous version standards.
Improvements made include new codes, field coding parameter requirement changes and grade alterations. The updates can cause legacy data to lack clean alignment with the evolved data model. In some cases, the absence of a direct one-to-one relationship between older and newer elements requires interpretation and informed assumptions during conversion.
The newly developed conversion tables provide a structured approach to translating older PACP codes and observations into their updated equivalents wherever possible. Rather than forcing organizations to abandon or manually reinterpret legacy datasets, these tools allow for a more seamless migration, preserving historical value while aligning with current standards.
High-quality data is the backbone of effective asset management. Municipalities, utilities and engineering firms depend on inspection data to prioritize maintenance, allocate budgets and mitigate risk. Inconsistent or outdated data can lead to misinterpretations, potentially resulting in unnecessary repairs or worse, missed failures.
For example, a defect coded under PACP Version 6 may not directly correspond to a code in Version 8 due to refinements in defect definitions, code groups, severity grading or required fields. Without proper conversion, this discrepancy could skew condition ratings, making a pipe appear in better or worse condition than it truly is. Without thoughtful conversion and validation, discrepancies and data gaps can erode confidence in cost projections and distort infrastructure risk profiles.
Consider a utility that has been collecting inspection data for over a decade using PACP Version 6. As they adopt Version 8 to meet current industry standards, they face a critical challenge: integrating historical data with newly collected inspections.
Without conversion, the utility would essentially be comparing apples to oranges — older inspections using outdated coding structures alongside newer, more refined data. Even with conversion, careful consideration is required where legacy data cannot provide context for updated mandatory fields, or where multiple legacy entries map to a single modern equivalent. By applying NASSCO’s PACP conversion tables alongside informed review, the utility can standardize its dataset while maintaining context, enabling more reliable trend analysis, life cycle modeling and long-term capital planning.
While the introduction of these conversion tables is a significant step forward, it also highlights a broader need for clear, consistent guidance on data conversion best practices. Many organizations struggle not just with how to convert data, but with understanding the implications of those conversions on reporting, scoring and decision-making.
Because conversion is not always a direct translation, guidance is essential for handling ambiguous mappings, missing required values and differences in data structure. Future efforts from the NASSCO Software Committee are expected to focus on expanding resources and educational materials specifically related to conversion methodologies including validation procedures and strategies to maintain data integrity throughout the transition process. To download PACP data conversion workbooks, please visit nassco.org.
Continue reading for free
