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.clau...@gmail.com> wrote:
> sqlite> select avg(outTemp) from archive where strftime("%Y-%m",
> dateTime,'unixepoch','localtime')=='2020-11';
> 51.117818676717
> 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+unsubscr...@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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/CAPq0zEAwrRcHsmOR-ZX1eJxizuAsAjyx8HbdmH4DMRWfV3ECZA%40mail.gmail.com.
