Forums Search  

Customer Forum:  InService

Unsolved Getting the outage information back into the GIS for Engineers to use in studies...
Comments: 4 - Last Comment by dcbennet on Feb 16, 2017   Comment Filter:
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

Point your RSS reader here for a feed of the latest messages in this topic
RE: Getting the outage information back into the GIS for Engineers to use in studies...
Posted on Feb 16, 2017 in response to: Joel Getz
 
   
 

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...
Posted on Feb 16, 2017 in response to: Joel Getz
 
   
 

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...
Posted on Feb 16, 2017 in response to: dcbennet
 
   
 

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...
Posted on Feb 16, 2017 in response to: Calvin Daling
 
   
 

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


Add a Comment

Please sign in on the right menu to comment.  If you do not have an account, please Join now.

Please Sign In

Username
Password
What's this?

Forgot Username

Forgot Password?