Hello Thomas,
Thanks for the pointer to the SQL solution. I can see that method as fine
for a one-time or infrequent interval conversions. The main part that
groups and averages most columns is straightforward but the part that uses
trig functions to calculate averages for wind direction and
Hi, Bill.
1. WeeWX can handle mixed intervals.
2. The time, field dateTime, is indexed, so it does not slow down reports
as much as you think. My database is about 1.5 M records and it performs
fine on a very slow machine. The exception is queries that
involving finding the min and max of the
Hello,
I've been testing a CSV import configuration with wee_import. The CSV data
is in 1 minute intervals whereas weewx.conf has an archive_interval = 300
for 5 minutes. my csv.conf has interval = 1 to match the data interval
(which has a few gaps).
What I'm finding is the imported data is