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. On Sunday, February 2, 2025 at 1:35:56 AM UTC-7 Graham Eddy wrote: > 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⊢* > > On 2 Feb 2025, at 7:30 pm, 'michael.k...@gmx.at' via weewx-user < > weewx...@googlegroups.com> wrote: > > 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. > mihec schrieb am Sonntag, 2. Februar 2025 um 08:05:44 UTC+1: > >> 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: >> >>> >>> 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 schrieb am Samstag, 1. Februar 2025 um 19:50:31 UTC+1: >>> >>>> 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. >>>> >>> > -- > 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 > > <https://groups.google.com/d/msgid/weewx-user/20283003-84e9-4aca-894b-a53dba1278f1n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- 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+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/weewx-user/aee8c4ee-cd88-42ce-a8b6-358b1f48df10n%40googlegroups.com.
