Hi Matthew, It does look like there is something putting data in for those sensors. There are still inserts taking place, some in the last few minutes.
select dateTime,leafTemp1 from archive; 1644646200|-88.0 1644646500|-88.0 <---Friday, February 11, 2022 10:15:00 PM GMT-08:00 <https://www.epochconverter.com/timezones?q=1644646500> It seems I need to stop the new data going in. Removing any previous data would be in vein if new data went in moments after. The data may need to be removed, but stopping new data seems like the first task. Any pointers on where to look? Thank you, Roger On Friday, February 11, 2022 at 4:16:13 AM UTC-8 matthew wall wrote: > On Thursday, February 10, 2022 at 11:38:23 PM UTC-5 roger...@gmail.com > wrote: > >> Here are the last few lines of the select statement. I did not see any >> null values. >> >> 1644552300|-89.0 >> 1644552600|-89.0 >> 1644552900|-89.0 >> 1644553200|-89.0 >> 1644553500|-89.0 >> 1644553800|-89.0 >> 1644554100|-89.0 >> sqlite> >> > > roger, > > the timestamps for these observations are recent - 1644554100 is Friday, > February 11, 2022 4:35:00 AM UTC > > so it looks like *something* is inserting data for leafTemp1... > > try the query for the others. you can do it for multiple observations > like this: > > select dateTime,leafTemp1,leafTemp2,leafWet1,leafWet2 from archive; > select dateTime,soilTemp1,soilTemp2,soilTemp3,soilTemp4 from archive; > select dateTime,soilMoist1,soilMoist2,soilMoist3,soilMoist4 from archive; > > for each query, check the latest dateTime that has data (non-null). to > view the timestamp in human-readable form, use an epoch converter such as > this one: > > https://www.epochconverter.com/ > > m > -- 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/ab3363a3-59ec-4a13-9612-6d1f95c8fc63n%40googlegroups.com.
