Could you do a full select on archive_day_outTemp?

select * from archive_day_outTemp;

It looks like there is some data in there.

-tk

On Sun, Mar 3, 2019 at 5:33 AM Michael <[email protected]> wrote:

> Hello, Thomas,
>
> my imported data has different origins. The first year only inTemp un
> OutTemp, 2 values per day (min and max). Then until 2017 the values
> recorded by the software of my station and from 06/2018 the values of WeeWX.
> Here is a small example from weewx.archiv
> MariaDB [weewx]> SELECT datetime, barometer, pressure, outTemp, inTemp
> FROM weewx.archive
>     -> where datetime = 1104581280
>     -> or datetime = 1293901680
>     -> or datetime = 1551526200
>     -> order by datetime;
>
> +------------+-----------+------------------+------------------+------------------+
> | datetime   | barometer | pressure         | outTemp          |
> inTemp           |
>
> +------------+-----------+------------------+------------------+------------------+
> | 1104581280 |      NULL |             NULL |             23.4
> |             23.8 |
> | 1293901680 |      NULL |             NULL |             22.5
> |             23.3 |
> | 1551526200 | 1018.6875 | 991.814351600413 | 11.4620689655172 |
> 21.8724137931035 |
>
> +------------+-----------+------------------+------------------+------------------+
> 3 rows in set (0.00 sec)
>
> whether the imported values are all valid, I cannot say so. In my opinion
> yes, but something seems to be wrong, otherwise the NOAA reports would be
> filled with values.
> When I look at the 3 lines from the DB, I notice that the barometer value
> for the imported values is NULL. I also think I read something about NOAA
> reports and an existing barometer value.
> So I changed barometer for dateTime = 1293901680 from NULL to 0. After
> that I deleted the Daily Sumaries and rebuilt them. After that I re-created
> the NOAA reports. And see there, the report for the corresponding date has
> values.
> Do I understand correctly that the barometer must not be set to NULL?
>
> To answer your question. The NOAA report is available, contains only the
> data from the template but no values, see Hardcopy
> Regards,
> Michael
>
> --
> You received this message because you are subscribed to the Google Groups
> "weewx-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>

-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to