There is no average direction, what you are looking for is the direction of a vector, the resulting vector (speed, direction) of all measuerements of a given timespan. I am not too familiar with all database tables and entries, but I thinking of the parts I know, I doubt that you can retrieve the vector an it's direction by a query (at least with a considerable simple one).
What is your use case and why can't you use the provided variables you have mentioned? Phil D schrieb am Freitag, 11. August 2023 um 05:58:31 UTC+2: > Hello everyone, > > I am trying to create an sql query from the archive_day_xxx tables to find > the daily and monthly values of the average wind direction that we > retrieve in the variables $day.wind.vecdir and $month.wind.vecdir. > I tried several things from the archive_day_wind and archive_day_winDir > tables but without finding the exact values. > Anyone know how to find them? > sorry for the google translate > Thanks in advance > Phil -- 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/0d856397-4479-439e-80ee-e7bfbd799285n%40googlegroups.com.
