Every electric utility regularly deals with transformer replacements. Transformers encounter issues related to everything from animals, theft, lightning, voltage changes, fires, and, of course, sizing issues. Middle Tennessee Electric (MTEMC) used a sleek blend of technology to aggregate, analyze, query, and report on their current transformer installations by comparing customer consumption against Rated KVA. The transformer analysis results were made available in SQL Server Reporting Services (SSRS) and visually in ArcGIS Online to drive new enterprise decisions both in the field and the back office.
Is your utility, telecommunications company, or pipeline operation interested in getting up and running on ArcGIS Online, ArcGIS Enterprise, and/or Portal for ArcGIS? Learn about the ArcGIS Online Jumpstart option from SSP on our GIS Jumpstarts overview page here. We’ll get your team up and running quickly on the leading Esri web GIS platform.
Alright, so let’s take a look at the application we’ve deployed here at Middle Tennessee. Using an IPad, iOS, of course you can use android or windows just as easily depending on the application you’re using. The key to using Esri ArcGIS Online for this deployment was that we could actually expose that same web map to any number of Esri out of the box applications. For example, if we go into the standard Esri application, the green app as it’s called internally. I could just browse into my groups here. Through my groups, I can see the MTEMC transformer load group and get to the app that way and load it here within the map. Alternatively, our group often prefers to use Esri Collector for ArcGIS.
Collector is a little different in that we have to expose at least one editable layer within the web map. But we’ve done that with a kind of a dummy layer just to get this map to show up since it is read only. But you can see that it’s available there. I’ll load that same production transformer loading map. You can see the map comes up very much in the same way. So within this map we’ve actually exposed our ArcFM™ stored displays from the back office. All that data translated very nicely.
This is sort of the first step to exposing the data out. One of the other key things that we wanted to do was to enable easy searching for our field crews. So by simply clicking the search, we’ve been enabled here so that we can search on various asset numbers. We actually index about 25 of our feature classes on the backend every week or so. Expose those. So we can search on the given asset number and click search. They can find the various numbers such as the light company number or transformer company number. You can see that those are in different areas of the service territory. But that’s a really easy way to get to those locations on the map. Within that we can then of course go and add to your places or get directions to that location by simply using the out of the box app and or it could transition into the navigator application from Esri. Either way. So one of the key things we can do here. Let’s go ahead and search in on a franklin substation here. We’ll go ahead and zoom in a bit so we can see that better.
So here at this Franklin Rural substation, just near where I know there will be a transformer of interest to us. We’ll go ahead and just zoom a little bit to the north side there. What we can see as this data comes in is that in addition to all our base data behind the ArcFM™ stored display we’re also seeing color coded thematic mapping here. That shows the transformer loads by phase. That was one of the key things we mentioned was to do it by phase. So one of the things we can tell directly here is how the transformers loaded. So we developed those thematic map qualities that based on the loading percentage we can tell how heavily loaded a transformer is. The users in the field of course, click on any of these individual readings to get the detail for it. So we can see at this particular one here that the a phase transformer number of 61449 is loaded at 9.78 percent. Very low load there on that transformer. If you scroll through the details here, the all time max was achieved there in 2015 of summer. And really nothing to worry about on that one.
So if we were to replace this a phase we would definitely not worry about upsizing or to make any decisions based on it. However, let’s zoom over to this other transformer. This is an interesting one because it’s a three phase overhead. And as you can see, all three phases are represented individually with the different colors. So in this case, we’re replacing the b phase, that transformer would not be an issue. As it’s only loaded here at 42.61 percent. However, a or c phase might be a different case. If we take a look at the details for one of those, we can see that the c phase is loaded at 213 percent and if we go through the detail here the most recent winter load there, 199 percent.
The most recent summer, 160. The all time max load was 213. So it wasn’t last winter, but the winter before. So the point is this transformer is pretty heavily loaded and if this thing blew out. It would’ve likely wanted me to go ahead and replace it. Same thing over here on transformer A, you can also see that is 213 percent loaded. So the ability to get this detail out to the field crew very easily. Of course, I search on the area, but of course they could use the GPS as they rolled up on scene. That was really key to exposing this information.
So that’s just a really quick demo here of using the application. Again, it’s a targeted web application that could be put into the hands of any field user who can locate themselves using GPS and then bring up the transformer information of the specific transformers