sum: the sum of all archive windSpeed values count: the number of records contributing to the sum. NB: sum/count would be the average wsum: The weighted sum. Same as 'sum', except each value is weighted by the archive interval of the record sumtime: The sum of all the archive intervals. If all archive records are present, should equal one day max_dir: The direction of the wind at max speed. xsum: The sum of the x-component of the wind vector ysum: The sum of the y-component of the wind vector dirsumtime: Similar to sumtime, except for wind components squaresum: The sum of the squares of windSpeed wsquaresum: The of the squares of the windSpeed, weighted by the archive interval.
The measurement unit of 'max' is the same as the observation type. That unit is set by the value of usUnits in the archive database. This is why the unit system cannot change within an archive. Hope this helps. Why do you ask? On Wed, Jan 17, 2018 at 6:34 AM, Joachim Puttkammer <[email protected]> wrote: > Hi, > > what does the following columns in the archive_day_wind table mean? > > sum, count, wsum, sumtime, max_dir, xsum, ysum, dirsumtime, squaresum, > wsquaresum > > and the measurement unit of the 'max' value is? > > many thanks > > -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
