Thanks Gary, much appreciated. I just found the wiki
https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data and used
that to delete the data, yes it was today. Will rebuild the daily summaries
now.
I used 'null' so there is just nothing in those parts of the table (rather
than 0.0 in the r
If you know it definitely didn't rain in the archive periods concerned then
use 0.0, if it did rain but you don't know how much then you could use None
to indicate no rainfall data for those periods. Or you could just use 0.0
for the lot, not really going to make too much difference at the end o
OK, so used epoch time to find the records I want to delete (with rain and
rainRate), now do I just delete them or do they need to be replaced by null
(or 0.0?). I may need a hand with the correct syntax for that please
*pi@wduino*:*~ $* echo "SELECT rainRate FROM archive WHERE (dateTime >
1617159
I'm thinking that the easiest road here is to delete (or null??) all of
todays rain data. So that would be 'rain' and 'rainRate'?
Thanks
Colin
On Wed, 31 Mar 2021 at 17:44, colin@gmail.com
wrote:
> It's not my week lol!
>
> Now that I've rebuilt Weewx my weather station decided to go rogue
It's not my week lol!
Now that I've rebuilt Weewx my weather station decided to go rogue and tell
me it rained about 500mm in the last hour. I've stopped it thinking it's
raining but now how do I get rid of the rogue data from the database in
Weewx? I did a search for all kinds of database issu