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 - 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/c744f102-1a69-461b-b69b-4e48faa5e96do%40googlegroups.com.
