Re: MX SQL query
Posted: Mon 13 Apr 2020 6:24 am
I seem to have stirred up an issue here. But I am left even more confused.
It is windy here, and I'm not climbing up a ladder to disconnect my anemometer for a test.
I have archived off my Cumulus 1 files, so I cannot easily look for past evidence of '---' usage, although I remain positive I saw this.
In the database daily summary table for my old home, 10 Nov 2015 seems to be only day with zero bearings (and '---' direction), but that is not proof as an ex beteljuice function is used by the PHP that loaded the table to convert bearing to direction.
In my MX log for this month, the bearing does go to zero at various times when the wind speed was zero. But I admit I can't spot any 360 bearing.
Maybe Freddie's investigation of the code will resolve this later.
In terms of the question that started this topic, the bearings I can have are only 0 and multiples of 22.5, so that simplifies the function Mark proposed in his first post!
It is windy here, and I'm not climbing up a ladder to disconnect my anemometer for a test.
I have archived off my Cumulus 1 files, so I cannot easily look for past evidence of '---' usage, although I remain positive I saw this.
In the database daily summary table for my old home, 10 Nov 2015 seems to be only day with zero bearings (and '---' direction), but that is not proof as an ex beteljuice function is used by the PHP that loaded the table to convert bearing to direction.
In my MX log for this month, the bearing does go to zero at various times when the wind speed was zero. But I admit I can't spot any 360 bearing.
Maybe Freddie's investigation of the code will resolve this later.
The Fine Offset console does not contain bearings, it supplies compass direction (but as a number), and Cumulus converts this direction into a bearing. So the station cannot tell Cumulus whether to use 0 or the returned direction for calculating degrees, Cumulus looks at the wind speed to decide that, or it did in Cumulus 1.
In terms of the question that started this topic, the bearings I can have are only 0 and multiples of 22.5, so that simplifies the function Mark proposed in his first post!
Yes, that includes the option Freddie & I were discussing.
Sounding like the action of the parameter has been reversed.
Suggesting the option has no effect whatsoever.
So the option being off now does have an effect, but not same as for Mark?