How Do Utilities Modernize Legacy Transmission Asset Data? 8 Steps to Better Connected Systems
A Practical Path From Scattered Transmission Records to a Trusted View of the Network
A transmission infrastructure drawing from the 1940s can still hold information an engineer needs today. Whether that information can be found, trusted and used across the utility's systems is critical to supporting daily operations. But finding it can mean sending an email and waiting for someone to locate the right file. Even then, the asset may have different identifiers in the drawing, SAP and GIS. That makes the information harder to find, verify and use reliably.
Tamazari helped a major PNW utility modernize historical records across 229 transmission lines. Here are eight steps utilities can take to modernize decades of legacy transmission asset data.
1. Define What the Modernized Data Must Support
Start with the task a person needs to complete. If a field crew needs to locate a structure and open its latest drawing during restoration, a searchable folder of PDFs will only solve part of the problem. The utility also needs a reliable structure identifier, a location and a link available in the crew’s field application.
That use case tells the team which information to capture from historical records and where it must appear. The result is a set of data requirements tied to actual engineering, maintenance and field workflows.
2. Inventory and Prioritize Existing Transmission Records
A utility may have paper drawings for one line, revised CAD files for another and asset details scattered across spreadsheets and SAP. Before converting records, it needs to establish which versions exist, where they are stored and which ones teams rely on.
This inventory helps establish a practical migration sequence. High-priority lines, frequently requested drawings or records associated with upcoming projects may be modernized first instead of attempting to transform every record simultaneously.
3. Digitize Legacy Transmission Drawings
Digitizing legacy transmission drawings requires more than scanning paper and saving the result as a PDF. Each drawing should be reviewed to determine:
Which transmission line and assets it represents
Whether the drawing reflects current or historical conditions
Which revisions or as-built changes apply
Whether important information is missing or illegible
How it relates to other drawings and system records
Which information should become structured asset data
The process may include editing CAD drawings, updating asset information and producing standardized PDF records. Naming conventions, revision histories and document relationships should be applied consistently so the files can be found and maintained after migration. The original record should also be preserved. Historical drawings can provide valuable engineering context even when newer information has been added to the operational system.
4. Create a Consistent Transmission Asset Data Model
A modern transmission data environment depends on common definitions. Utilities need to decide how transmission lines, structures, conductors and related equipment will be represented across their systems.
Without a shared data model, the same asset may appear under different names or identifiers in engineering records, SAP and GIS. A consistent model allows records from different decades and sources to become part of the same operational structure. It also makes duplicate, incomplete and conflicting records easier to identify.
5. Reconcile and Improve Transmission Asset Data Quality
Legacy transmission data frequently contains conflicts. A structure may have one identifier in a drawing, another in SAP and a third in GIS. Locations may be incomplete, equipment descriptions may vary and past replacements may not be reflected consistently. Improving transmission asset data quality requires comparing records across available sources and resolving those differences through defined business rules.
When a conflict cannot be resolved from existing documentation, the utility may need input from engineers, asset owners or field personnel. This is one of the most important parts of modernization. Digitizing inaccurate information only makes the inaccuracies easier to distribute.
6. Establish Clear Ownership Across SAP and GIS
Before connecting systems, decide where each asset record and attribute is created, who can correct it and how a change reaches other applications. Otherwise, an integration can move an outdated value just as efficiently as an accurate one.
In a Tamazari-supported Transmission GIS transformation, SAP served as the foundational system, with data flowing into Smallworld GIS and then into downstream platforms, including Esri and Tenzing. Keeping those systems aligned was essential to creating a consistent view of transmission assets.
7. Validate the Complete Data Flow
Testing should begin with a real task: Can an engineer select a transmission structure in a map and open the correct drawing? Can a field user access the information needed when working offline? Trace the record from its source through each connected system to the person using it.
Then test what happens when an identifier is missing, a structure has been retired or an update does not reach a downstream tool. The result is evidence that the information works in daily operations, beyond confirmation that the migration loaded successfully.
8. Make Transmission Information Accessible and Maintainable
The value of modernization appears when people can access reliable information without depending on manual searches and individual knowledge. Engineers, operators and field users need to be able to access drawing links through the applications they already use. This reduces manual email requests and helps replace a search-and-wait process with more immediate self-service access.
The project also demonstrates why modernization cannot end when the initial data has been loaded. A modern system will eventually become another legacy system if the utility does not maintain the information after implementation.
Modernizing Transmission Data with Tamazari
Historical drawings become more valuable when the information inside them can be verified, connected to the right assets and accessed by the people who need it. Tamazari helps utilities coordinate that work across drawings, data quality, SAP, GIS, testing and field access.
About Tamazari
Tamazari is a minority-, veteran-, woman-owned professional services firm and execution consultancy serving utilities, fleet operators, public agencies and critical infrastructure organizations across the U.S. Our work spans energy IT, SCADA, GIS, ERP/SAP, enterprise modernization, telecom infrastructure, data centers and fleet telematics.
