The missing data in your plot is from midnight 20 August through until just after sunrise on 21 August not from 22 August as per your database extract. Try dropping each timestamp in your query by 86400.
Gary On Wednesday, 23 August 2023 at 21:55:29 UTC+10 [email protected] wrote: > Hi, > There's something strange, and I'd like your help to debug the issue. > The *outside temperature curve* of my weather station has *a cut during > the night of Aug 21 and Aug 22*. *But*, to my understanding, *the data > exists in the SQLite database*! > Why? > How can I trigger the curve to be re-generated ? > [image: weektempdew.png] > > This is the content of the database. I cut off some of the long output, > but you can see I always have an outside temperature. No error. > > select datetime(dateTime,'unixepoch', 'localtime'),outTemp from archive > where dateTime > 1692640000 and dateTime < 1692680000; > ... > 2023-08-21 23:00:00|28.1666666666667 > 2023-08-21 23:05:00|28.1666666666667 > 2023-08-21 23:10:00|28.25 > 2023-08-21 23:15:00|28.2222222222222 > 2023-08-21 23:20:00|28.1111111111111 > 2023-08-21 23:25:00|28.0 > 2023-08-21 23:30:00|28.0 > 2023-08-21 23:35:00|28.0 > 2023-08-21 23:40:00|28.0 > 2023-08-21 23:45:00|28.0 > 2023-08-21 23:50:00|27.8888888888889 > 2023-08-21 23:55:00|27.8888888888889 > 2023-08-22 00:00:00|28.1666666666667 > 2023-08-22 00:05:00|28.3055555555556 > 2023-08-22 00:10:00|28.1481481481481 > 2023-08-22 00:15:00|28.1666666666667 > 2023-08-22 00:20:00|28.4444444444444 > 2023-08-22 00:25:00|28.1666666666667 > 2023-08-22 00:30:00|27.8888888888889 > 2023-08-22 00:35:00|28.1111111111111 > 2023-08-22 00:40:00|28.25 > 2023-08-22 00:45:00|28.4259259259259 > 2023-08-22 00:50:00|28.4444444444444 > 2023-08-22 00:55:00|28.3888888888889 > 2023-08-22 01:00:00|28.8055555555556 > 2023-08-22 01:05:00|28.0740740740741 > 2023-08-22 01:10:00|27.1666666666667 > 2023-08-22 01:15:00|27.2777777777778 > 2023-08-22 01:20:00|27.1111111111111 > 2023-08-22 01:25:00|27.3055555555556 > 2023-08-22 01:30:00|27.3703703703704 > 2023-08-22 01:35:00|26.9444444444444 > 2023-08-22 01:40:00|26.8518518518519 > 2023-08-22 01:45:00|26.7777777777778 > 2023-08-22 01:50:00|26.8518518518519 > 2023-08-22 01:55:00|26.75 > 2023-08-22 02:00:00|26.6481481481481 > 2023-08-22 02:05:00|26.6111111111111 > 2023-08-22 02:10:00|26.3888888888889 > 2023-08-22 02:15:00|26.2222222222222 > 2023-08-22 02:20:00|26.1666666666667 > 2023-08-22 02:25:00|26.2962962962963 > 2023-08-22 02:30:00|26.25 > ... > > > - Weewx 4.10.2 on a Raspberry Pi > - Actually I have the same problem on outside humidity and barometer. > > > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/3f38fc33-5e66-48a4-90df-9e43f27f94e6n%40googlegroups.com.
