https://imgur.com/a/yZUPoTq michael.k...@gmx.at schrieb am Samstag, 28. November 2020 um 09:27:44 UTC+1:
> > I am observing the same situation, as well as other WeeWX users near me. > The average is clearly off since the 4.2.0 update. It also affects yearly > average since then. So I guess this is something that happened with the > 4.2.0 Version. I don't want to rebuild my daily values, how to find the bad > values and correct them? Probably in the archive_daily table of the day I > made the update? > > I found something: It's a change with "sum": > 1-13 has "new" sumtime, 14 a mix (the day I updated) and old sumtime are > 15 and and older: > > Isn't there a config that sets how this is calculated? > > > b.cl...@gmail.com schrieb am Donnerstag, 19. November 2020 um 19:43:57 > UTC+1: > >> Yeah, everything looks great again. >> Thank you Tom for that excellent support. >> Greetings from Suedlohn (Germany). >> Berny >> >> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:56:56 >> UTC+1: >> >>> So, for some reason, the weighted sum (field 'wsum') has too high a >>> value, or the sum of observation time (field 'sumtime') has too low a value. >>> >>> The easiest fix is to just rebuild the daily summaries using the >>> wee_database >>> utility <http://www.weewx.com/docs/utilities.htm#wee_database_utility>. >>> >>> Stop weewxd. then, >>> >>> *wee_database --drop-daily* >>> *wee_database --rebuild-daily* >>> >>> Restart weewxd >>> >>> For a database of your size, it shouldn't take more than a minute or two. >>> >>> It could take some time for the NOAA and html files to get corrected. >>> You can speed things up by deleting them and allowing weewx to regenerate >>> them. >>> >>> -tk >>> >>> >>> >>> On Thu, Nov 19, 2020 at 8:48 AM Berny Cl <b.cl...@gmail.com> wrote: >>> >>>> sqlite> select sum(wsum)/sum(sumtime) from archive_day_outTemp where >>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >>>> 60.1308595259353 >>>> >>>> Ok, that looks the same like the value in my history table. >>>> >>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um 17:13:38 >>>> UTC+1: >>>> >>>>> 1. That looks reasonable. One other query to try: >>>>> >>>>> sqlite> *select sum(wsum)/sum(sumtime) from archive_day_outTemp where >>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>>>> >>>>> 2. If that doesn't reveal anything, I will send you an instrumented >>>>> version of xtypes.py that will log the calculation. >>>>> >>>>> >>>>> On Thu, Nov 19, 2020 at 6:44 AM Berny Cl <b.cl...@gmail.com> wrote: >>>>> >>>>>> sqlite> select avg(outTemp) from archive where strftime("%Y-%m", >>>>>> dateTime,'unixepoch','localtime')=='2020-11'; >>>>>> 51.117818676717 <(781)%20867-6717> >>>>>> sqlite> select sum(sum)/sum(count) from archive_day_outTemp where >>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11'; >>>>>> 51.114923603352 >>>>>> >>>>>> Thank you! >>>>>> OK, I did that. The two numbers are very close. I think they are >>>>>> correct (in Fahrenheit) but in my history table the temperature ist too >>>>>> high (in degree Celsius). >>>>>> >>>>>> tke...@gmail.com schrieb am Donnerstag, 19. November 2020 um >>>>>> 15:02:55 UTC+1: >>>>>> >>>>>>> Most likely it's some bad data. Let's check the database directly. >>>>>>> >>>>>>> First find the database. If you did a package install, it's most >>>>>>> likely at /var/lib/weewx/weewx.sdb. If you did a setup.py install, it's >>>>>>> at >>>>>>> /home/weewx/archive/weewx.sdb. Let's assume the former. >>>>>>> >>>>>>> Then, run two queries: >>>>>>> >>>>>>> *sqlite /var/lib/weewx/weewx.sdb* >>>>>>> sqlite> *select avg(outTemp) from archive where strftime("%Y-%m", >>>>>>> dateTime,'unixepoch','localtime')=='2020-11';* >>>>>>> sqlite> *select sum(sum)/sum(count) from archive_day_outTemp where >>>>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime')=='2020-11';* >>>>>>> >>>>>>> The first method calculates the average temperature for Nov 2020 by >>>>>>> using the main archive table. The second by using the daily summaries. >>>>>>> The >>>>>>> two numbers should be very close. See what you get and we'll take it >>>>>>> from >>>>>>> there. >>>>>>> >>>>>>> -tk >>>>>>> >>>>>>> >>>>>>> On Thu, Nov 19, 2020 at 4:43 AM Berny Cl <b.cl...@gmail.com> wrote: >>>>>>> >>>>>>>> Hi everybody, >>>>>>>> since the last update to version 4.20, i have noticed an incorrect >>>>>>>> value for the monthly average temperature at the history table and >>>>>>>> also in >>>>>>>> the monthly NOAA table. >>>>>>>> I use the niculskin and my station is a FineOffset (WS 1080). >>>>>>>> >>>>>>>> See at: http://haus-volmering.de/history.html >>>>>>>> (Durchschnittstemperatur = Average Temperature for Nov is obviously >>>>>>>> incorrect) >>>>>>>> >>>>>>>> How can I fix that? >>>>>>>> >>>>>>>> -- >>>>>>>> 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 on the web visit >>>>>>>> https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%40googlegroups.com >>>>>>>> >>>>>>>> <https://groups.google.com/d/msgid/weewx-user/277ec811-21b4-41e9-8fc1-cda38d87014dn%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+...@googlegroups.com. >>>>>> >>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/weewx-user/87243ab4-47a4-4c85-b004-530f84e77673n%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+...@googlegroups.com. >>>> >>> To view this discussion on the web visit >>>> https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%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 on the web visit https://groups.google.com/d/msgid/weewx-user/c720db5a-0470-43e8-9044-f73db6ccd307n%40googlegroups.com.