Challenge
Before 2019, all of Lakewood’s CCTV inspection work was contracted out. Results were delivered to the city on physical CDs and ingested manually for historic purposes. The city was utilizing OpenGov EAM (formerly Cartegraph) for asset records management and work orders, and Esri ArcGIS as its GIS platform. While these two powerful systems provided support for asset management and GIS mapping, the city had no in-house capture capability, no consistent digital format, and no automated path for inspection data to reach these systems, which were used across the organization for planning and decision-making.
Crews manually updated task statuses after each inspection. Administrative staff performed bulk edits to reconcile work orders. Field assignments were tracked on paper maps. With the integration between OpenGov and Esri, GIS users could see asset locations but had no direct view of inspection condition data. Each system was performing its core function well, but condition data was the missing piece of the workflow, thus requiring significant manual effort that only increased as Lakewood expanded its annual inspection program.
Solution
In 2019, Lakewood brought CCTV inspections in-house with its first camera van and implemented ITpipes SmartVision as the operational hub for inspection data. Using native, bi-directional integrations between ITpipes, OpenGov, and Esri, Lakewood created a connected workflow where inspection, asset, and GIS data move automatically between systems.
ITpipes feeds completed inspections into OpenGov, where the corresponding asset records are updated, inspection video links are attached, and related work orders close automatically. ITpipes also pushes inspection attributes directly into Esri, including all NASSCO-required data captured during inspection, all condition scoring, and a link to the video inspection. An inspection coded in the field by a Lakewood crew is now reflected on the GIS map without manual data entry.
Integrating all three systems also allows every inspection within the city to move through the same workflow. Lakewood’s in-house crews use ITpipes FieldVision and code inspections in the field. Inspections and coding results collected by their outside contractor are also uploaded into ITpipes where Lakewood performs spot-check QA/QC. Through the integration with ITpipes, by the time data reaches OpenGov and Esri, it has already been structured and is in a consistent, digestible format, regardless of what team collected it.
Task creation is now field-driven. When a Lakewood crew identifies a maintenance need during an inspection, the task is created on the spot. That task becomes immediately visible to the rest of the team in OpenGov and pushed to ITpipes, replacing the previous paper-map handoff between supervisors and crews. Any team member can take any assignment from the shared queue, which allows Lakewood to deploy available staff to priority work.
Results
Lakewood has reported a steady, year-over-year decrease in administrative time. Closing work orders, assigning work, and reconciling inspection activity across systems are measurably more efficient than before the integrations were in place. Hours that once went to manual coordination are now available for inspection work and field maintenance.
Inspection throughput has also increased. Lakewood’s in-house crew targets 3,500 feet of pipe per day and completes 8 to 10 inspections per shift, which was not possible before the integration of ITpipes. In the most recent tracked year, the in-house team logged approximately 106,000 feet of inspection, alongside the contractor’s 90,000 feet and 680 inspections, and annual mileage only continues to grow.
Decision-making has moved out of silos. With condition data, NASSCO coding, and video accessible against the GIS, engineers and planners scope capital planning, prioritization, and risk-based maintenance and rehabilitation work from a single, spatially aware view. Field leadership, asset management, and engineering all reference the same information when assigning repairs and shaping renewal projects.
By integrating ITpipes, OpenGov, and Esri, Lakewood has extended the value of CCTV inspection beyond data capture..Lakewood now operates from a shared, continuously updated view of asset condition data that supports field operations, maintenance prioritization, and long-term infrastructure investment planning.
Click here to see how the City of Lakewood, Colorado utilizes this integration to drive efficiency and impact for their team!