Hi there, I need to remove some temperature spikes from my weewx.sdb database. I know this has been already asked many times, but my case is different. I need to delete spikes in which the values are climatically acceptable: so, it is not sufficient to give (temperature is intended in °C)
echo "delete from archive where outTemp < -6;" | sudo sqlite3 /home/weewx/archive/weewx.sdb for solving the problem. In my case, the spike was about 16°C when temperature was about 20°C (see the graph below) [image: daytempdew.png] What I need to do is something like: DELETE if Δt = 300 AND |ΔT| > 5, where Δt is time difference (in seconds, I chose 300 because my archive interval is 5 minutes) and ΔT is the temperature difference in that time bin. In other words I am thinking about using a differential approach. It seems to me that this can be the only solution, is this possible with sqlite3? Thank you, Andrea -- 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/32298c8c-6d93-4a80-8b9e-29fdcc181c8an%40googlegroups.com.
