295kph windGust reading cannot find in database cannot fix

[Greg from Oz]

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:

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?

[Tom Keffer]

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. 

--
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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/815dbad8-10cb-4843-b98c-bdab8ac34227n%40googlegroups.com.

[Greg Reive]

I only have the one database.

It is very strange that I can't even find the high wind record.

I will keep looking.

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 weewx-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBDvt6OqFWPpZ0uxO-_T19_Lut00dCTM8zyVsRd30yR-Q%40mail.gmail.com.

[Greg Reive]

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?

--

¯\_(ツ)_/¯

[Greg from Oz]

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/

[Karen K]

Greg from Oz schrieb am Freitag, 7. Juli 2023 um 04:46:06 UTC+2:

All good now.........Still don't know why I couldn't find 295. Why is it 81.9?

I guess the database is in US units. This is the default. 

[Greg Reive]

Actually 81.9 is metres per second which works out to be 294.84 KPH

Now I know what to look for next time.

Yes I thought it was US in the database as well but I selected METRICWX from the beginning so it must store metric in the database.

Thanks

--

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 weewx-user+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/0d37b807-291c-4b35-bcba-65576d0f3fd8n%40googlegroups.com.

--

¯\_(ツ)_/¯