Yeah – that’s exactly it – DST 😊.
Thanks to all who responded….. From: [email protected] <[email protected]> On Behalf Of gjr80 Sent: Tuesday, February 11, 2020 5:06 PM To: weewx-development <[email protected]> Subject: Re: [weewx-development] WeeWx archiving Hmm, wouldn't be a daylight saving change to put clocks back in November each year would there? Gary On Wednesday, 12 February 2020 10:31:36 UTC+10, Tom Keffer wrote: Yes, modulo DST weirdness, you should see 288 counts per day. Are the high counts consistent? That is, every day? -tk On Tue, Feb 11, 2020 at 1:44 PM <[email protected] <javascript:> > wrote: I’ll admit I haven’t dug deep into the code (yet); but, I’m trying to understand how weewx processes archive vs loop records and how those eventually get aggregated into the “archive_day” tables. I have loop_interval = 2.5 and archive_interval = 300, if that makes any difference. Anyway, what I would have expected is to see at MOST 288 (24*12), maybe +/- 1, counts in the “archive_day” tables: Instead, I have below – can anyone offer some insight? Thanks! Clay Jackson MariaDB [weewx]> select dateTime, from_unixtime(dateTime), `count` from archive_day_wind where `count` > 12*24; +------------+-------------------------+-------+ | dateTime | from_unixtime(dateTime) | count | +------------+-------------------------+-------+ | 1509865200 | 2017-11-05 00:00:00 | 297 | | 1541314800 | 2018-11-04 00:00:00 | 298 | | 1572764400 | 2019-11-03 00:00:00 | 294 | +------------+-------------------------+-------+ MariaDB [weewx]> select avg(`count`) from archive_day_wind; +--------------+ | avg(`count`) | +--------------+ | 282.1309 | +--------------+ -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <javascript:> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/231a01d5e124%247116a780%245343f680%24%40n7qnm.net <https://groups.google.com/d/msgid/weewx-development/231a01d5e124%247116a780%245343f680%24%40n7qnm.net?utm_medium=email&utm_source=footer> . -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/6d6ea11d-eed2-4349-8c5f-6d6ca8ccf4c2%40googlegroups.com <https://groups.google.com/d/msgid/weewx-development/6d6ea11d-eed2-4349-8c5f-6d6ca8ccf4c2%40googlegroups.com?utm_medium=email&utm_source=footer> . -- You received this message because you are subscribed to the Google Groups "weewx-development" 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-development/259401d5e1bd%240e0cdc10%242a269430%24%40n7qnm.net.
