Depending on your SQL skill, you should be able to clean them up directly
in the slqlite database. (Syntax slightly different if you're using mysql.)
Backup your database first!
I have a similar issue with outside temperature. For a few months my DIY
station was indoors, so the outside temperature recorded was much too high.
sqlite> select max(outTemp) from archive;
119.984
Gives me something to aim for. In my location, it never gets above 100F.
sqlite> update archive set outTemp=NULL where outTemp > 100.0;
sqlite> select max(outTemp) from archive;
99.9968
Or even 90F
sqlite> select count(*) from archive where outTemp > 90;
14321
You could also constrain by time. First look:
select datetime(datetime,'unixepoch'), outTemp
from archive
where strftime('%m', datetime(datetime, 'unixepoch'))='02' and outTemp
> 95;
and then null them out. For example
update archive set outTemp = NULL
where strftime('%m', datetime(datetime, 'unixepoch')) = '02'
and outTemp > 95;
sets the outside temperature to NULL (blanks it) if it is over 95F in
February.
If you know exactly when you got the driver working, you could NULL rain
for all records before that time.
update archive seet rain = NULL where datetime < 1456000000;
And then backfill
On Thursday, 8 December 2016 21:55:03 UTC-4, [email protected] wrote:
>
> During the time when I was developing a new driver, I managed to get some
> ridiculous rain values in the database - even here we don't get rain that
> is measured in kilometres!
>
> I've tried to delete the very large 'rain' values form the database and
> also running the 'wee_database' tool to delete an recreate the daily totals
> but I'm still seeing very large values in any display/report that goes back
> beyond the current month.
>
> Is there a way to wipe all of those bad values (happy to show that it
> didn't rain at all) without scrapping the whole database (only about 6
> weeks so not a total loss if I have to) and starting again?
>
> Susan
>
--
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].
For more options, visit https://groups.google.com/d/optout.
