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.