Hexagon Safety & Infrastructure - Post to topic Getting the outage information back into the GIS for Engineers to use in studies...

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

2017-02-16 19:15:59 Etc/GMT

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

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

2017-02-16 19:59:41 Etc/GMT

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.

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

2017-02-16 20:31:09 Etc/GMT

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.

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

2017-02-16 20:39:45 Etc/GMT

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.

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

2017-02-16 21:50:39 Etc/GMT

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.).