I'm afraid your going to have to do a bit of self help. If you've taken the steps to use MySQL/MariaDB there is an expectation you have some level of familiarity with MySQL/MariaDB. All you are doing is searching your archive table for values that are clear wrong.
Something like: $ mysql -u root -p mysql> SELECT * FROM archive WHERE windSpeed>100; or limit the fields you are displaying: mysql> SELECT datetime,windSpeed FROM archive WHERE windSpeed>100; if you have any replace the 'bad' fields with null: mysql> UPDATE archive SET windSpeed=NULL WHERE windSpeed>100; Then drop/rebuild the daily summaries as per the wiki page. Gary On Friday, 14 January 2022 at 08:25:46 UTC+10 [email protected] wrote: > I have tried the instruction "old 'bad' data" . But I use the > mysql-database. To convert the DB ( 1 million records) to a sqlite-DB was > not succesfull. > Furthermore run here 2 instances, so no weewx.conf or weewx db but with > other names ( ecowitt.conf with weewx_eco db etc). > > Joachim > > gjr80 schrieb am Donnerstag, 13. Januar 2022 um 11:31:40 UTC+1: > >> Hi, >> >> Have you worked through the Cleaning up old 'bad' data wiki page >> <https://github.com/weewx/weewx/wiki/Cleaning-up-old-'bad'-data> with an >> emphasis on the field windSpeed? You most likely do not see the spikes >> on the Seasons year plots as the Seasons year plots plot a day average >> value, perhaps you are seeing the spikes on the Belchertown plots because >> they plot a different aggregate (or perhaps no aggregate at all). >> >> Gary >> >> On Thursday, 13 January 2022 at 19:44:56 UTC+10 [email protected] wrote: >> >>> >>> Hi, >>> >>> how can i delete the two peaks in the berlchertown year chart? >>> These peaks do not appear in the season year diagram. >>> [image: wind-belchertown.png][image: wind-season.png] >>> Joachim >>> >> -- 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/fa3576e6-b018-41d9-ac95-10dc5dea4f9cn%40googlegroups.com.
