WeeWx archiving

50 views
Skip to first unread message

cl...@n7qnm.net

unread,
Feb 11, 2020, 4:44:35 PM2/11/20
to weewx-development

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 |

+--------------+

 

 

Thomas Keffer

unread,
Feb 11, 2020, 7:31:36 PM2/11/20
to cl...@n7qnm.net, weewx-development
Yes, modulo DST weirdness, you should see 288 counts per day. 

Are the high counts consistent? That is, every day?

-tk

--
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 weewx-developm...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/231a01d5e124%247116a780%245343f680%24%40n7qnm.net.

gjr80

unread,
Feb 11, 2020, 8:05:44 PM2/11/20
to weewx-development
Hmm, wouldn't be a daylight saving change to put clocks back in November each year would there?

Gary
To unsubscribe from this group and stop receiving emails from it, send an email to weewx-de...@googlegroups.com.

cl...@n7qnm.net

unread,
Feb 12, 2020, 10:57:01 AM2/12/20
to gjr80, weewx-development

Yeah – that’s exactly it – DST 😊.

 

Thanks to all who responded…..

To unsubscribe from this group and stop receiving emails from it, send an email to weewx-developm...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/6d6ea11d-eed2-4349-8c5f-6d6ca8ccf4c2%40googlegroups.com.

Reply all
Reply to author
Forward
0 new messages