AnsweredAssumed Answered

Backfill Weather Data to PI Archive. Fill Gaps as 'Bad Data' or 'NA'

Question asked by rmulla on Feb 10, 2017
Latest reply on Feb 16, 2017 by rmulla

I'm attempting to backfill some PI points we've created for weather data with data I've pulled from NOAA.

 

I'm formatting everything as a CSV and then importing using UFL

 

The problem I have is that NOAA data can have gaps. I'd like these gaps to show up as 'no-data' or 'NA' so when I query the time period I don't get a bogus value.

 

Ideally I'd like PI to notice if a last value was > 2 hours ago, and if so change the state to 'Bad data'.

 

Is there an easy way to do this? I'm doing this with 30+ points for 7 years, so its going to be somewhat automated.

 

An example of the gap in data.

 

Outcomes