Case Study – Wellington City Council

Unlocking the Value of Legacy CCTV Data: How Wellington City Council Improved Asset Management

Wellington City Council had a clear objective: make decades of CCTV inspection data accessible to all stakeholders through its new Asset Management System AMS.

What followed was a large scale data consolidation and engineering evaluation programme that transformed fragmented legacy records into a strategic infrastructure asset, delivering measurable financial and operational benefits.

This article outlines the challenge, the process, and the results.

The Problem: Decades of CCTV Data Locked Away

Over several decades, Wellington City Council invested significant resources collecting CCTV condition data across its underground pipe network for maintenance planning, renewal forecasting, development compliance, and strategic asset management.

After an initial review, it became clear that:

  • Inspection videos and data were stored in multiple formats

  • Records existed across different legacy systems

  • Physical copies were held in folders, boxes, and cabinets

  • Data was located in various office locations

  • Access was limited to the original collecting teams

There was little usable access to data older than a few years. This prevented long term condition deterioration analysis and limited the Council’s ability to improve the asset register.

Valuable infrastructure intelligence was effectively dormant.

The Objective: Consolidate and Deploy Data into the New AMS

The goal was not simply to archive historical data. It was to extract and standardise CCTV inspection records, validate and cleanse asset information, align inspection data with the asset register, reformat video and metadata for AMS compatibility, and enable engineering evaluation across the organisation.

ReticManager was engaged to undertake a structured data consolidation, post processing, and engineering evaluation programme.

The Approach: More Than Data Migration

This was not a simple file transfer exercise.

System and Process Audit

Existing systems, contracts, metadata specifications, and workflows were reviewed and audited.

As a result:

  • A new CCTV contract framework was developed

  • Improved metadata specifications were created

  • Internal processes were refined for future inspections

This ensured long term value beyond the immediate consolidation.

Extraction and Standardisation

Inspection data was extracted from multiple legacy systems.

Specifications, schemas, and formats were analysed and standardised to ensure compatibility with the new Asset Management System.

Both video files and inspection data were reformatted according to defined technical requirements.

Engineering Led Post Processing

Each inspection header was verified against the asset register to:

  1. Tag the survey to the correct asset

  2. Identify alignment and node errors

  3. Assess compliance with industry standards

  4. Evaluate overall data quality

This step transformed raw inspection files into structured, validated engineering data.

The Scale of the Programme

Over a 30 month period:

  • 18,000 CCTV inspections were post processed

  • Representing 482 kilometres of network

  • Nearly 3,000 alignment and node errors were identified and reported

Without this intervention, much of this data would have remained unused or been permanently lost.

The Results: Measurable Value

Asset Register Improvement

Verification of inspection headers against the asset register identified thousands of discrepancies, improving spatial and network accuracy.

Engineering Efficiency

The newly structured data enabled:

  • Consistent condition grading

  • Efficient renewal planning

  • Improved maintenance prioritisation

  • Better cross department decision making

Financial Benefit

The estimated value of inspection verification alone was approximately $1.6 million when compared to conducting equivalent field investigations.

The overall benefit cost ratio was estimated at at least 4 to 1 in favour of post processing and engineering evaluation.

Why This Matters for Infrastructure Asset Management

Many councils and infrastructure owners hold decades of CCTV inspection data in obsolete formats, disconnected databases, poorly structured archives, and inconsistent metadata frameworks.

Without consolidation and validation, this data cannot contribute meaningfully to long term asset lifecycle planning, network deterioration modelling, renewal forecasting, or risk based prioritisation.

The Wellington City Council programme demonstrates that legacy CCTV data, when properly consolidated and engineered, becomes a high value strategic asset.

Adding Value Beyond Data Manipulation

The programme extended beyond technical data processing. It supported change management, contract specification improvements, metadata standardisation, internal process development, and long term governance improvements.

This ensured sustainable value rather than a one off data migration.

Conclusion

Infrastructure organisations often underestimate the value stored within historical inspection data.

By consolidating, validating, and engineering 18,000 CCTV inspections into a single Asset Management System, Wellington City Council unlocked significant financial and operational benefits while improving the integrity of its asset register.

For councils and network owners holding fragmented inspection archives, structured post processing and engineering evaluation may represent one of the highest return on investment initiatives available in asset management.