The City of Hamilton, Ohio, required a clear and reliable understanding of the condition of its large-diameter storm sewer system along a critical corridor but faced the challenge of managing complex inspection data and translating it into actionable insights. The project team addressed this need by performing a comprehensive LDCA using standardized NASSCO methods and advanced technologies. All inspection data, media and defect coding were integrated into an accessible GIS-based dashboard, providing the city with a centralized, intuitive tool to support maintenance planning and long-term infrastructure decisions.
CCTV Inspection & Automated Defect Coding
Following structure inspections, CCTV evaluations were conducted on all connected sewer pipes. Video data was processed through PipeAId, which automatically analyzed and coded defects in accordance with NASSCO PACP standards, providing consistent and objective condition ratings.
GIS Integration & Dashboard Delivery
A key deliverable was an interactive GIS dashboard that allows users to visualize inspection locations, review defect severity, access linked media and explore recommended improvements, creating a one-stop shop of streamlined workflow for system evaluation and decision-making.
Integrated Data & Tools:
- MACP inspection forms with condensed summaries and site photos
- 360° video paired with LiDAR point clouds
- Surveyed coordinates for each structure
- PACP defect coding geospatially linked to CCTV video
- Immersive, asset-based inspection records
Client Value:
- Reduced time spent locating and reviewing inspection data
- Centralized access to all system information on one platform
- Scalable solution built on the existing GIS framework
- Preservation of institutional knowledge through asset-based data organization
Deliverables & System Insights
The final deliverables included a comprehensive technical summary report, updated GIS data, defect coding exports, linked inspection media and prioritized recommendations for cleaning, rehabilitation or replacement. The integrated dataset and dashboard provide a clear and accessible foundation for ongoing asset management.