Possible Answers

Topic Getting the outage information back into the GIS for Engineers to use in studies...

You may need to log in to view this topic.

Getting the outage information back into the GIS for Engineers to use in studies...
Posted on Feb 16, 2017
 

All,

I’m sure other Intergraph shops are already doing it, so just looking for some guidance. My assumption is there is some table in InService that will give us a Transformer number or Premise number, and the number of minutes it was out for each outage. However, I’m sure there are duplicates and bad data that we need to be taught how to weed out to get the true number of minutes. I may be completely off too and there is a completely different way of doing it. Basically what we are looking for is some way to look at a block, section of town, entire circuit, etc. and see how many outages minutes have occurred on the area of interest.

Thanks,

Joel


The Following Answers May Help to Solve This Question
  Results
Discussion RE: Getting the outage information back into the GIS for Engineers to use in studies...
Have you looked at the outhist table? That's what we use when extracting outage data for our outage reporting system. That's in 8.3.1.
Discussion RE: Getting the outage information back into the GIS for Engineers to use in studies...
One caution on outhist_transformers is that, in our system, that table is reliable real time but not after the outage is completed. So for example, if the cause code or outage dates/times are changed during the outage closure, that information is not reflected in outhist_transformers but it is in outhist.
Discussion RE: Getting the outage information back into the GIS for Engineers to use in studies...
I believe the outhist and outage _duration tables might be where you want to start Joel, then for all the impacted xfmrs maybe outhist_transformers.
Discussion RE: Getting the outage information back into the GIS for Engineers to use in studies...
Agreed ... Joel, the Outage Reconciliation functionality in NetViewer/NetDispatcher manipulates the outhist and outage _duration table data only (not outhist_transformers). And these are where your statistical data will reside after an outage is closed (cust_minutes, etc.).
Discussion Getting the outage information back into the GIS for Engineers to use in studies...
I’m sure other Intergraph shops are already doing it, so just looking for some guidance. My assumption is there is some table in InService that will give us a Transformer number or Premise number, and the number of minutes it was out for each outage . However, I’m sure there are duplicates and bad data that we need to be taught how to weed out to get the true number of minutes.