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]> 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]. > 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/CAPq0zEDjH-yu9%3DRHEECFe%3DhaaTrx2yGdAdfGBaiR0nv8HD5F_Q%40mail.gmail.com.
