Actually, the values in the rainRate and rain columns are set to 0.0, not Null, sorry for stating it wrong.
On Sunday, February 2, 2025 at 2:36:10 AM UTC-7 Jeff A. D. wrote: > 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/a0029552-cb07-4e5d-b5e0-13d70b02f5d5n%40googlegroups.com.
