OK found it. I did this: select * from archive where windGust > 81.9; Then I deleted the record: delete from archive where dateTime = 1688648400;
Dropped the daily and rebuilt and now no more 295kph wind! I think the first time I deleted the record for 23:00 of today's weather (collateral damage) All good now.........Still don't know why I couldn't find 295. Why is it 81.9? Anyway it is looking a lot better now. https://weather.ubeaut.work/ On Friday, 7 July 2023 at 12:13:55 UTC+10 Greg Reive wrote: > select * from archive_day_windGust where dateTime = 1688565600; > > +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+ > | dateTime | min | mintime | max | maxtime > | sum | count | wsum | > sumtime | > > +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+ > | 1688565600 | 0 | 1688566200 | 81.90000006552 | 1688648400 | > 635.3000005082397 | 288 | 190590.00015247212 | 86400 | > > +------------+------+------------+----------------+------------+-------------------+-------+--------------------+---------+ > > date -d@1688565600 > Thu 06 Jul 2023 00:00:00 AEST > > Maxtime: date -d@1688648400 > Thu 06 Jul 2023 23:00:00 AEST > > The max is 81.9 and not 295? > > > > On Fri, 7 Jul 2023 at 12:05, Greg Reive <[email protected]> wrote: > >> I only have the one database. >> It is very strange that I can't even find the high wind record. >> I will keep looking. >> >> On Fri, 7 July 2023, 12:02 Tom Keffer, <[email protected]> wrote: >> >>> If you did all those things, the only thing I can think of is that you >>> may not be working on the database you think you're working on. >>> >>> >>> On Thu, Jul 6, 2023 at 5:58 PM Greg from Oz <[email protected]> wrote: >>> >>>> I have a windGust reading spike of 295kph and I cannot find it in the >>>> database. >>>> 295 km/h from N/A (N/A) at 06/07/23 23:00:00 >>>> >>>> select dateTime, windGust from archive where (windGust > 100); >>>> Returned nothing. >>>> >>>> I deleted the record for that date and time in the mysql database: >>>> delete from archive where dateTime = 1686142800; >>>> >>>> I dropped the daily records and rebuilt them. >>>> wee_database /opt/weewx/weewx-data/weewx.conf --drop-daily >>>> wee_database /opt/weewx/weewx-data/weewx.conf --rebuild-daily >>>> >>>> I deleted the daywind.png file as well >>>> >>>> It is still there: >>>> >>>> [image: Screenshot from 2023-07-07 10-53-10.png] >>>> >>>> This has me stumped...... >>>> >>>> I have been able to fix up wrong rain readings before and that worked >>>> but this wind record is not working the same way. >>>> >>>> Any ideas? >>>> >>>> >>>> >>>> -- >>>> 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/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "weewx-user" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/weewx-user/OcVhlHxEvHI/unsubscribe. >>> To unsubscribe from this group and all its topics, send an email to >>> [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com >>> >>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.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 on the web visit https://groups.google.com/d/msgid/weewx-user/e1fa6e44-1b85-4304-b85c-0feb07c348fan%40googlegroups.com.
