MX SQL query

[sfws]

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.

Must be because the Davis station uses zero for calm anyway?

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!

Some options

Yes, that includes the option Freddie & I were discussing.

I *thought* I had that option enabled, but I don't, however the bearing definitely goes to zero when calm...

Sounding like the action of the parameter has been reversed.

I have never seen any dashes. I used to have that option enabled, but I don't anymore.

Suggesting the option has no effect whatsoever.

It's logging 'N' as it's calm.

So the option being off now does have an effect, but not same as for Mark?

[freddie]

In fact, I will look at the source code tomorrow and come up with a patch for Mark.

Thank you.

Done!

Anyway, please no ongoing arguments, we are friends not foes!

I don't see it as an argument - more of a debate. It's how differences get solved. I apologise if I came across as argumentative - I am very passionate about "getting things meteorologically correct" so will always state my case when I think something doesn't quite follow the rules/guidance.

[mcrossley]

Iirc the "use zero for calm" option was for stations that did not implement that themselves - like the Fine Offset. I do not think its logic has been reversed.

In my log file, the bearing is recorded as zero when the wind speed drops to zero. Note that this is only the average speed and bearing.

[sfws]

It is calm this morning. MX is recording a bearing of zero, but direction is displayed as 'N' not as '---' as I saw with Cumulus 1.

Incidentally, N is neither the recent direction, nor the direction my vane is currently pointing (SW my console and look out the window confirm), so Cumulus MX IS DOING PROCESSING on raw data.
To confirm that, I disabled "Use bearing zero when Calm" and then Cumulus MX, my console and my look out of the window all indicated 'WSW'. I enabled it again and MX 3.5.1 went back to 'N'.

I stopped MX, copied data folder of MX back into data folder of Cumulus 1, edited the date formats in today.ini into year last (instead of ISO as used by MX), started Cumulus 1 and there the direction is "---", but all other readings are same. Freddie - I said I remembered seeing '---' in Cumulus 1, well I have just confirmed my elderly memory is still proving reliable.

Did I go back to MX? - that does not matter, but we will see when Freddie's modification to MX is released whether all contributors to this topic start showing unknown direction in calm. And equally importantly, as Freddie said in his proposal for the function change, assign (for those weather stations that report bearings) small non-zero bearings of 1,2, 3, 4, 5, to 'North'.

In the beteljuice supplied function (I looked it up and he attributes it to beeker425 at http://www.weather-watch.com/smf/index. ... 097.0.html), I use with my web pages, a modification I made was to specifically test for zero bearing and assign '---' for that. His original would indeed use 'North' for 0 degrees.

Code: Select all

function windDirVerbose($windBear)
	{ 
		if(!$windBear)return '---'; // added by SFWS
		// user language e.g.North-Northwest
		# Take wind direction value, return the VERBOSE text label based upon 16 point compass -- function by beeker425
		#  see http://www.weather-watch.com/smf/index.php/topic,20097.0.html
		$langWindVerbose = [ // can be used in text for wind direction 
			"North", "North-North-east", "North-east", "East-North-east",
			"East", "East-South-east", "South-east", "South-South-east",
			"South", "South-South-west", "South-west", "West-South-west",
			"West", "West-North-west", "North-west", "North-North-west","True North"];
		return $langWindVerbose[floor((($windBear + 11) / 22.5) % 16 )];  //  beteljuice uses +11 to put in centre of compass range (the .25 of the true value 11.25 would be removed by the floor operation anyway)
	}   // END function windDirVerbose

Iirc the "use zero for calm" option was for stations that did not implement that themselves - like the Fine Offset. I do not think its logic has been reversed.

In my log file, the bearing is recorded as zero when the wind speed drops to zero. Note that this is only the average speed and bearing.

Just to say, that in Cumulus 1, both average speed and gust directions get reported as '---' in a calm, as well as both bearings going to zero.

[mcrossley]

So!....

I'll modify the compass direction to return "-" when the direction is zero as provided by freddie. That will sort the average and gust compass direction.

I found with the WLL, that if the average is > 0, but the latest wind is zero, the station code was returning zero for the direction (the WLL actually sends a null value when calm), but because I did not have the "Use zero when calm" option enabled, this got translated to 360, so it displayed as "N". Enabling the Use zero option also makes the latest direction = 0 when the latest wind = 0.

[mcrossley]

OK, ver 3.5.2 is released which has the new compass direction of "-" for bearing zero.

It also implements two new web tags for today/yesterday high gust direction in compass ordinals.

[sfws]

OK, ver 3.5.2 is released which has the new compass direction of "-" for bearing zero.

It also implements two new web tags for today/yesterday high gust direction in compass ordinals.

Thank you for all those.

[freddie]

OK, ver 3.5.2 is released which has the new compass direction of "-" for bearing zero.

It's working well - my current conditions page shows this nicely.

calm.png

(not to mention in the banner below - at the time of posting, of course )

[sfws]

It's working well - my current conditions page shows this nicely.

I just noticed that on the user interface I still see 'N' for bearing 0.
But yes Freddie, your mod is working well on my snapshot web page.

[mcrossley]

I just noticed that on the user interface I still see 'N' for bearing 0.

On the "Now" page? - Noted...