there would be lots of such gaps - you excluded rainRate==0 from your selection
if there are no bad values now in the 5 minute data, presumably the bad values are in summary data, so rebuild your summary tables (instructions in manual) after that, if no bad values in 5 minute data or in summary data, it would have to be the graph generation software > On 8 Jul 2020, at 12:41 am, Andre <[email protected]> wrote: > > I've noticed in result.txt there is a 5 hour gap between 2020-07-04 > 07:05:00|1|0.0314960628 and 2020-07-04 12:00:00|1|0.1496062983. > Could this caused my issue? > > Am Dienstag, 7. Juli 2020 16:03:27 UTC+2 schrieb Andre: > My first thought was that it would be a good idea to search for "bad data" in > rainRate. > So I tried again to search with > > echo "SELECT datetime(dateTime,'unixepoch','localtime'),usUnits,rainRate FROM > archive WHERE (RainRate);" | sqlite3 /home/pi/weewxcopy.sdb > > Please see result.txt - As you can see, no "bad data" is apparent. Also my > HighCharts images are without any abnormal outlier. > My actual skin is Belchertown and maybe it could be a display issue. Not sure. > You could see it live here www.wetter-norderstedt.de > <http://www.wetter-norderstedt.de/> - please take a look at "Stärkster Regen: > 13107,0 mm/h" on frontpage. > I'm now not sure where I can take another look for identifying wrong values. > > Am Dienstag, 7. Juli 2020 09:20:04 UTC+2 schrieb Graham Eddy: > usUnits==1 → rainRate is inches/hour. are you looking for > 13 inches/hour? > > also, for easier reading of timestamps, you could use > SELECT datetime(dateTime,’unixepoch’,’localtime'),usUnits,rainRate FROM > archive ... > >> On 7 Jul 2020, at 5:06 pm, Andre <[email protected] <>> wrote: >> >> Thanks again, Gary. >> This is my result of the query >> >> echo "SELECT dateTime,usUnits,rainRate FROM archive WHERE (RainRate > >> 13);"| sqlite3 /home/pi/weewxcopy.sdb >> 1581284100|1|13.3385826805 >> 1581284400|1|13.3385826805 >> >> I don't understand the dateTime 1581284100 which means 02-09-2020, 22:35:00. >> But my "bad data" are from 4 July 2020 09:33. I can't see where the "bad >> data" come from. >> > > > -- > You received this message because you are subscribed to the Google Groups > "weewx-user" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <mailto:[email protected]>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/c744f102-1a69-461b-b69b-4e48faa5e96do%40googlegroups.com > > <https://groups.google.com/d/msgid/weewx-user/c744f102-1a69-461b-b69b-4e48faa5e96do%40googlegroups.com?utm_medium=email&utm_source=footer>. -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3E33E403-F6BA-4516-AA79-60F122C94614%40gmail.com.
