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.
[email protected] 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 <[email protected]> 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).
>>
>> [email protected] 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 <[email protected]> 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 [email protected].
>>>> 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 [email protected].
>>
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/f5a4768c-27f7-49c6-807e-496296d0c380n%40googlegroups.com.
