How do I correct my daily rain data?

[dens...@yahoo.com]

Hardware maintenance resulted in 1.63" of daily rain data that is not real. Is there an easy way to correct this error?

I am running WeeWX 5.0 on a Raspberry Pi.

Thanks,

Den

[vince]

https://github.com/vinceskahan/weewx-odds-and-ends/blob/master/fix-bad-rain.md is one way to do it

[dens...@yahoo.com]

Thank you for the quick reply... I am sure my lack of Pi / SQLite knowledge is at issue here.

I pasted:

echo "select datetime(dateTime,'unixepoch','localtime'),dateTime,rain,rainRate from archive order by rowid desc limit 20;" | sqlite3 weewx.sdb

into the terminal as the user Pi  (pi@raspberrypi:) and get back:

bash: sqlite3: command not found.

Adding the preface sudo did not change the response.

If more explicit instructions would help, please advise.

Den

[vince]

You likely need to install the sqlite3 utility. 

[dens...@yahoo.com]

! I have been researching this and found just what you suggest: I need to install sqlite3. Not knowing much I have been concerned that sqlite3 will interfere with the weewx database. From what I see it is a stand alone utility that I can use to access weewx.sdb AND not a database installer. 

THANKS Vince, a project for tomorrow. Wish me luck.

[vince]

After you clear out the bad records in the archive table, the official way to rebuild the daily summary table would be to run weectl database with the rebuild-daily option and specify just the date in question.  My example kinda slam dunks the value an unofficial way.

Official docs are at https://weewx.com/docs/5.1/utilities/weectl-database/#rebuild-the-daily-summaries