Fix the daily rain totals for specific days

[mihec]

Hello,

my Davis station has occasional issues with rain measurement lately. I do have data from manual measurements (daily totals).

Is it possible to fix the daily totals in the weewx database so I replace the wrong values with my manual measurements? If yes, any hint how to do it properly so the values will update also in the NOAA reports?

This is only temporary until I have the hardware issue fixed.

Thank you.

[michael.k...@gmx.at]

https://weewx.com/docs/5.1/utilities/weectl-database/?h=wee+database#rebuild-the-daily-summaries

And don't forget to delete existing NOAA files, as they won't be updated if they exist.

[mihec]

Hi, thank you for your quick answer.

I understood the rebuild-daily is my last step. However, my difficulty is in the first step - how to enter the corrected values to the database so they won't be overridden in the future. As I said, I don't have raw (minute) data but only daily totals.

Thanks!

sobota, 1. februar 2025 ob 21:57:00 UTC+1 je oseba michael.k...@gmx.at napisala:

[michael.k...@gmx.at]

Then you need to fill the affected column of the archive table, which isn't possible to do correctly. Depending on the obs_type, you might find a way that would fit your need, but it might have drawbacks. Particulary for rain: if you have the daily rain sum of 30mm, you could manually insert 30mm for any archive value in the rain column, which gives you the correct sum for that day after you rebuild that day, but a insanely high rainRate, if you recalculate derived values. You can distribute the rain over different archive intervals, which is also not correct but would also lead to the correct sum and a wrong rainRate, but this wrong rainRate might be acceptable for you, because it might be below your max rainRate for that month/year/alltime, that you might want to show in a historical summary.

Any way you do it, it won't be correct, you will have to find your individual solution with the most acceptable drawbacks.

[Graham Eddy]

i think weewx handles differing intervals in the database (change from one archive period to another, or in your case add daily interval records at the start)

but i don’t think weewx handles a change of database unit system within a query (so every entry in database should have same unit system)

⊣GE⊢

--
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 weewx-user+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/weewx-user/20283003-84e9-4aca-894b-a53dba1278f1n%40googlegroups.com.

[Jeff A. D.]

I do take manual readings during the winter months to get the moisture equivalent of the snowfall.  I don't have a set time to enter it, but usually around the time the snowfall ends.  Or you could do it a 0700 when Cocorahs totals are generally reported.  It really doesn't matter for me as I just want to keep track of total precipitation.

Anyway, I enter the value in the rain column of the archive table at whatever time desired.  I use DB Browser for SQLite to access the db.  As my AWS rain gauge is covered during winter, I don't have other values for rain or rain rate that I need to remove, but if you do just set them to NULL.  If you just input the precipitation total and and leave the archive table rain rate values all NULL, it's not going to give you any rain rate even when you rebuild daily.

[Jeff A. D.]

Actually, the values in the rainRate and rain columns are set to 0.0, not Null, sorry for stating it wrong.

[Jimi Lawson]

I've just recently done a similar thing using the same method as Jeff. The wind direction and speed during storm Eowyn (24th Jan) caused my tipping bucket rain gauge to give false reading during a 6 hour period (10.45")
I used DB Browser for SQLite to look at the rain & rain rate values in that period and made any that were obviously wrong 0.0 in total I zeroed about 17 rain/rain rate values.

I then rebuilt the 24th, deleted the NOAA report for  year 2025 & month Jan then restarted WEEWX. This worked fine, checking nearby stations shows my rain figures for the 24th to be very similar now. I know they  not correct but they are not far enough out that it will adversely affect my averages in the way that 10.45" in 6 hrs would.

Jimi

To view this discussion visit https://groups.google.com/d/msgid/weewx-user/a0029552-cb07-4e5d-b5e0-13d70b02f5d5n%40googlegroups.com.