Hi Warren thanks for the reply. I saved the db first and then went to see the table names archive_day_dewpoint I found the wrong string 1729807200 -23.637362385367 1729843980 19.482794091558 1729851864 2655.38888646456 149 796616.665939367 44700 I did the first step of the guide echo "SELECT * FROM archive WHERE (dewpoint = -23.637362385367);" | sqlite3 /var/tmp/backup.sdb
but I didn't see anything on the video Did I make a mistake with the query? Il giorno venerdì 25 ottobre 2024 alle 12:16:23 UTC+2 Warren Gill ha scritto: > Ciao Francesco, There is a very good article in the weewx wiki on github > that takes you through the process step-by-step. You can read it here: > https://github.com/weewx/weewx/wiki/Cleaning-up-old-bad-data > > > On Fri, Oct 25, 2024 at 5:06 AM Francesco Fasano <[email protected]> > wrote: > >> Good morning everyone, today in my city there was a very strong climatic >> event with a water accumulation of 130 mm and a Rain Rate of 500 mm/hr. In >> all this there was a lot of thunder and lightning and exactly at 10.11am my >> Davis entered incorrect values such as the minimum temperature at -22.9 °C >> minimum apparent temperature -28.8 °C >> Lowest wind chill -31.3 °C >> Lowest dew point -23.6°C. >> There is a sqllite query that clears these values to zero. >> Obviously these will have to be rebuilt. >> Thanks for the help >> wewwx 5.1.0 >> >> -- >> 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 visit >> https://groups.google.com/d/msgid/weewx-user/f352ef3e-8af3-43fb-8bb3-75204a50c800n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/f352ef3e-8af3-43fb-8bb3-75204a50c800n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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 visit https://groups.google.com/d/msgid/weewx-user/4ad4177d-2bd1-4c3b-b919-c972cc98da6en%40googlegroups.com.
