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 On Sun, 2 Feb 2025, 9:49 am Jeff A. D., <jadavisw...@gmail.com> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/a0029552-cb07-4e5d-b5e0-13d70b02f5d5n%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/CAEzr%3D0YQjDAyug3HrJNQ2WdoaaUe%3DpF3dA9dwMocTTAXpA8k8A%40mail.gmail.com.
