How to fix the wind data from kts to km/h?

[mihec]

Hello,

I have installed weewx version 5.x in my ubuntu 24.04. I have imported 10 years archive data from Weather Display into weewx.sdb and I think everything worked just fine.

After I generated NOAA reports, I see they all match with Weather Display.

Except for the wind data. Weather Display obviously stores it in knots and such data made it into weewx database.

What is the right way to fix the wind data in the weewx.sdb?

At the moment, I'm not using weewx on a live system but just for keeping the archive.

Many thanks,

Peter

[Tom Keffer]

Probably the easiest way is to use the tool sqlite3 to scale windSpeed, then rebuild the daily summaries. Assuming your database is in US Customary units, it would look something like this (NOT TESTED, make a backup first):

sqlite3 weewx.sdb

sqlite> UPDATE archive SET windSpeed=1.15078*windSpeed

-tk

--
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 visit https://groups.google.com/d/msgid/weewx-user/407e3a3f-aee0-471a-a528-b0a71323211en%40googlegroups.com.

[mihec]

Tom, thank you for your fast reply. Conversion worked (I used 1.852) and reports are correct.

Peter

ponedeljek, 26. januar 2026 ob 21:46:49 UTC+1 je oseba Tom Keffer napisala: