Thanks. I was able to edit the archive database.
My next question is where is the record high/lo data stored in? I need to remove those entries? Thanks Dave From: [email protected] <[email protected]> On Behalf Of p q Sent: Thursday, May 30, 2019 6:12 PM To: [email protected] Subject: Re: [weewx-user] Abnormal Rain amount You can start by tweaking the StdQC section in weewx.conf to limit the erroneous values. I don't know what causes it. I get random winds of 40 mph when I've never seen real wind above 20 in my sheltered location. To fix it, I stop the weewx service (sudo /etc/init.d/weewx stop on my raspberry PI). Make a backup copy of the database (/var/lib/weewx/weewx.sdb is the default) and then edit the database to remove the bogus entries. You can use any SQLite database editor, but I copy it to my Windows PC and edit it with DB Browser. You'll want the archive table. DB Browser lets you filter the results. Look in the rain or maybe rainRate field. I'd just null out the bad records or put in 0s. Save and copy the file back and restart Weewx and you should be good to go. When you're editing the db, one thing I find useful is to check the dateTime field of the records that I'm editing. This is stored as unix Epochs. Easiest way to convert to human readable time is to use a online tool like https://www.epochconverter.com/ Good luck On Thu, May 30, 2019 at 4:02 PM <[email protected] <mailto:[email protected]> > wrote: Hello everyone, I am fairly new to running weewx and so far I love it. I am running it on a raspberry pi with a separate MySQL server and HTTP server. Here is my problem. This morning I was looking at the weather data thru the http server and I noticed that I received a very large amount of rain, but in fact there is no rain at the place of my sensor. So I have a couple of questions. 1st – Is there a way to see what triggered the large amount of rain? It measured 5+ inches of rain. 2nd – Is there a way to adjust or remove that entry so it doesn’t skew the data? 3rd – I have seen this a couple of times, but is there a way to help prevent this? Thanks Dave -- 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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/19e001d5173b%249ed27680%24dc776380%24%40gmail.com <https://groups.google.com/d/msgid/weewx-user/19e001d5173b%249ed27680%24dc776380%24%40gmail.com?utm_medium=email&utm_source=footer> . For more options, visit https://groups.google.com/d/optout. -- Peter Quinn (415)794-2264 -- 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] <mailto:[email protected]> . To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAA1SM234TY4DEEGgtUb_3y08VprjFPGUaZ1KON7DSSfsKHx5PQ%40mail.gmail.com <https://groups.google.com/d/msgid/weewx-user/CAA1SM234TY4DEEGgtUb_3y08VprjFPGUaZ1KON7DSSfsKHx5PQ%40mail.gmail.com?utm_medium=email&utm_source=footer> . 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/000d01d5174f%2450275d70%24f0761850%24%40gmail.com. For more options, visit https://groups.google.com/d/optout.
