Welcome to the new Energy Central — same great community, now with a smoother experience. To login, use your Energy Central email and reset your password.

Bill Meehan
Bill Meehan
Expert Member
Top Contributor

Three Ways to Improve Data Quality In GIS

Old Habits Die Hard. 

All my life, I've struggled to manage my weight. I've probably lost 1,000 pounds in my life, but the problem is I've gained 1,050 pounds. If I really wanted to lose weight permanently, I would kill off my old bad eating habits for good, not just suspended them for a while during the diet and then bring them back again as soon as I lose enough weight. To really transform, old, negative habits must die.

We’ve heard a lot about digital transformation. There are really two, maybe three elements of digital transformation. The first element is the right technology platform. The second is a change in behavior, maybe even a radical change. Sometimes, the third is a complete business disruption. UBER, iPhone, Netflix and Airbnb have changed the way we use taxi’s, communicate, watch movies and stay in hotels. These transformations involve an upheaval in behavior. The reason I can’t manage my weight is that I have not successfully changed my behavior.

Electric utilities are transforming. Customers are installing solar systems in droves. People are hanging batteries on their garages. Microgrids are popping up all over the place. Electric companies are unbundling their component parts: generation, transmission, distribution, and retail services.

Need to Kill Bad Habits

To survive profitably, transmission and distribution (T&D) companies need to kill old habits and rituals they have perfected since the time of Thomas Edison. It’s not a secret that many forward-thinking industries are data driven. To survive digital transformation, they must change.

Lack of investment in management, processing, and upkeep of good data is one really bad habit of utilities. They need to kill that habit. Good data is a fundamental requirement for solid operational and financial efficiency. Most electric companies have a GIS. Yet study after study and interview after interview reveal that utilities just don’t trust the quality of their GIS data. Most don’t have a complete record of their T&D facilities in GIS. They keep substation information in CAD. Then they rarely update their substation data to reflect as-built situations. They rarely model underground structures. Most do not have processes to ensure the data is timely. And in all too many cases, the facility location is not even close to GPS accurate. In a study several years ago, Esri asked utilities how long it takes for information from the field to make it into the GIS. In some cases, they measured the time in weeks, not minutes, hours, or even days. The price of this lack of precision, timeliness and completeness is simply lack of efficiency, which translates into higher costs; poor customer service and reliability; and, in some cases, accidents. While most now agree that GIS is a fundamental component in every T&D utility's IT portfolio, the simple existence of GIS is not enough.

How do many utilities deal with incomplete, inaccurate, or out-of-date information? Easy. They just have folks jump into vehicles and have people check so to see if the information in their records is in fact correct. This is a costly and time-consuming bad habit. Utilities do it a lot.

The data has got to be right.

The reason many companies do not have a complete set of data is of course is the cost to migrate, collect, and maintain the data. The T&D utility has an aging work force, aging infrastructure, greater cost exposure, lower margins, and increasing customer expectations. So they believe there isn't money left over to do a better job of completing the data migration and of capturing the more difficult assets such as underground facilities, substations, or secondary services. Yet today, information drives most modern business decisions, including how to prioritize facility investment. Processes are dependent on good data. Grid modernization demands it.

Three Ways to Improve Data Quality in GIS

1.  Think of the GIS a Platform

GIS is not a map making machine. Esri’s ArcGIS platform is at its best when it serves as a means of pulling information from a variety of data sources, both inside and outside the company. This includes business intelligence, data from first responders, from smart city resources, customer information, materials, work management, asset management, SCADA, ADMS, AMI, and network analysis systems. Utilities don't have to store and maintain all the data in GIS. Ironically, utilities often capture too much information in GIS.

What does the GIS need?

  • Complete inventory of facility assets
  • The location of those assets,
  • The spatial relationships of assets to each other and to the world around them.

They have too much information in one place and not enough where they need it. If utilities want to see demographics on the map, they can pull it from the web. Model Assets as They Really Are. 

Utilities began their GIS journey replicating their old paper and distribution and transmission maps. They wanted the digital version to look exactly like the old paper maps. This was a digital transition, since the behavior of the workers didn’t really change very much. That meant that things were not really modeled as they exist on the group. With the new ArcGIS Utility Network Management Extension utilities can now get the best of both worlds. They can make easy to use maps and represent network elements with all the features, like terminations, grounding configuration and banking technology built in.

2. Capture the Complete Network in GIS

The notion that the GIS is the single source of truth is a lie. Well today it is a lie. It should be the single portal to the truth. Information about substations, transmission designs, relay systems, underground structures, and a host of other facilities are stored somewhere else. The GIS can store a complete model of the T&D system, sometimes called a digital twin in the GIS. Having all facility data in one place avoids duplication, out of synch data and convoluted processes – all bad habits!

3. Put Data Into the Hands of Everyone

Believe it or not, utilities still print out maps for their field workers. That puts a crimp in communication, collaboration and coordination – the three c’s of good data management. Using the ArcGIS platform, when something happens in the field and is updated on the field worker’s mobile device, everyone knows about it right then on any device, anywhere, any time. The ArcGIS platform takes is cue from social media platforms. Tweets are immediate. So too, when field workers update their data on a mobile device, everyone knows. Paper drags the processes down. It just slows things down to a crawl.

With the ArcGIS platform, there is no long journey from the field into the GIS department

If I ever want to lose weight, my old eating habits must die. Likewise, if T&D utilities want to transform, their old data habits must die. No more defaulting to field checks for data accuracy. No more reliance on GIS as solely a mapmaking machine. No more keeping data in file cabinets. Instead, companies must improve integration with corporate systems and invest in modern processes of data governance. That’s what a true location platform provides.

For more information on the ArcGIS platform for utilities, click here.