Hi,
i have the following issue.
I imported 2 years of data in weewx database but i noticed some issues on
daily archive.
The most important is with the rain.
Taking data from archive table, i perform the following query on sql db for
a specific day in order to have the total amount of rain for t
Hi,
Just a couple of points on terminology so we are on the same sheet of
music. In a default install your WeeWX database has a table named archive,
this is commonly known as 'the archive'. There are numerous other tables in
the database whose name are in the format archive_day_x, these tab
Hi gary,
As i reported,I already did every step you suggested,data on
archive_daily_rain is still wrong
Il dom 23 ott 2022, 10:42 gjr80 ha scritto:
> Hi,
>
> Just a couple of points on terminology so we are on the same sheet of
> music. In a default install your WeeWX database has a table na
I'm sorry I am a bit confused. You just said 'as reported I already did
every step you suggested' but your original post made no mention of the
steps I mentioned. It's not clear to me what you have/have not done.
Irrespective, can you please stop WeeWX, execute the wee_database
--drop-daily and
Hi Gary,
i performed the step you reported,dropping daily and rebuilding them.
I have still the issue,below the queries after steps you reported.
Thanks in advance.
sqlite> select sum(rain) from archive where dateTime > 1601157600 and
dateTime <= 1601244000 and rain != 0;
sum(rain)
1.13385826771
I have now connected WeeWx to the Cotech 36-7959 Weathjer Station by using
a RTL-SDR stick.
I downloaded sdr.py from https://github.com/matthewwall/weewx-sdr and added
a decoder for Cotech.
...
class Cotech367959Packet(Packet):
# Cotech Weather Station, 36-7959 from Clas Ohlson. Created 202
Thanks.
On Saturday, October 22, 2022 at 5:32:03 PM UTC-7 tke...@gmail.com wrote:
> I can think of three approaches.
>
> 1. You could write a WeeWX service that caches the barometer data.
>
> 2. Use the last non-null value in the database. Try $day.barometer.last
> and see if that works for you.
OK, if there is a discrepancy between the daily summaries and the archive
the solution is to drop and rebuild the daily summaries. If that approach
does not work we need to track down why. The first step is to look at the
output of the wee_database --drop-daily and wee_database --rebuild-daily
