There are several reasons why you mayy not find a 19.79 value in the database:
- You are searching the wrong table: you won't find the highest daily rainfall in the archive table. (Unless all the rain was recorded in a single interval). Look for the table archive_day_rain and in there you should find a row with that value (in which unit it may be, I don't know) - Units: the database doesn't necessarily contain metric values. Especially if you haven't actively changed the default unit_system for the database. So the value you are looking for might be stored in inch A complete rebuild of your whole history might not be necessary, if such values aren't a repeating pattern. Which version are you on? wee_database is from before v5.0. So if you are on a newer version you should use weectl database - and refer to the docs for the version you use. JohnP schrieb am Dienstag, 9. Dezember 2025 um 22:04:09 UTC+1: > Hi, > > I'm hoping for some pointers to eradicate an erroneous 'Highest Daily > Rainfall' value (see attached image). > > I have 19.79cm of rain registered on 22/April/2025 - a day where there was > no rain at all. > > I've tried to follow some of the steps from other threads, querying the > database for erroneous looking data both from the CLI and by searching with > DB Browser, however I conclude that I am probably looking for the wrong > value in the wrong place! > > Here's what I returned from the database: > > sqlite> select > datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from > archive where dateTime > 1745276400 and dateTime <= 1745366400; > > 2025-04-22 00:05:00|1745276700|0.0|0.0 > > 2025-04-22 00:10:00|1745277000|0.0|0.0 > > 2025-04-22 00:15:00|1745277300|0.0|0.0 > > <---snip - all zero data for every 5 minute interval ---> > > 2025-04-23 00:45:00|1745365500|0.0|0.0 > > 2025-04-23 00:50:00|1745365800|0.0|0.0 > > 2025-04-23 00:55:00|1745366100|0.0|0.0 > > 2025-04-23 01:00:00|1745366400|0.0|0.0 > > I can't find a '19.79' in the database (or 1978 in case of a round up), > and the sum of the values above would clearly be zero. > > I looked at this post: > https://groups.google.com/g/weewx-user/c/pQohXWFsEjk > > Which talks about dropping the daily database and rebuilding it - however > /etc/weewx/scripts/wee_database (and all scripts in that folder) are not > executable, so I am a little concerned they are orphans from an older > version and are superseded by newer utilities in a different location. > > Any pointers would be much appreciated, thanks in advance. > > J > > -- 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 visit https://groups.google.com/d/msgid/weewx-user/0b74845f-11a4-46a8-bea1-847d63ed65f1n%40googlegroups.com.
