Page 1 of 1

Highcharts Wind Rose

Posted: Thu 03 Jan 2013 10:44 pm
by mcrossley
I keep looking at the Highcharts Wind Rose and wondering if we could use that with Cumulus. I think the only way at the viable moment would be via SQL database table of either realtime logs, or the archive logs. I can't see any way of getting this from Cumulus web tags - other than processing the wind 'arrays' which would be relatively costly in terms of bandwidth.

Re: Highcharts Wind Rose

Posted: Thu 03 Jan 2013 11:33 pm
by steve
Presumably the best solution would be for Cumulus to generate web tags containing the values? 16 arrays (one for each direction) containing the values for the 7 wind speed bands?

Re: Highcharts Wind Rose

Posted: Thu 03 Jan 2013 11:40 pm
by tobyspond
Mark,

I use the realtime log for my last 24 hour windrose and the monthlylog files for the longer term windroses. Both the realtime and monthly log files are in a SQL database that I query to generate the windroses. However, I am using jpgraphs and not highcharts. I decided on jpgraphs becuase they had a windrose and purchased the professional version for the windrose. Unfortunately, the highchart windrose capability did not exist at the time I was looking into various charting software. The highchart version looks nice though.

Kerry

Re: Highcharts Wind Rose

Posted: Thu 03 Jan 2013 11:44 pm
by mcrossley
steve wrote:Presumably the best solution would be for Cumulus to generate web tags containing the values? 16 arrays (one for each direction) containing the values for the 7 wind speed bands?
Yes, that would be the most generic solution I guess :lol:

16 or 8 directions depending on the resolution selected in Cumulus.

I'm trying to find what the 'standard' speed bands are though, anyone any idea, are there any standards in this area?

Also what interval should be used? last 12 hours, 24 hours? Today? last 30 days? I guess that depends on the intended use.
tobyspond wrote:Mark,
I use the realtime log for my last 24 hour windrose and the monthlylog files for the longer term windroses. Both the realtime and monthly log files are in a SQL database that I query to generate the windroses. However, I am using jpgraphs and not highcharts. I decided on jpgraphs becuase they had a windrose and purchased the professional version for the windrose. Unfortunately, the highchart windrose capability did not exist at the time I was looking into various charting software. The highchart version looks nice though.

Kerry
Kerry, your response came in as I was typing the above, any thoughts?

Re: Highcharts Wind Rose

Posted: Thu 03 Jan 2013 11:53 pm
by tobyspond
Hi mark,

I'm using the following speed intervals in mph 1-3, 4-7, 8-12, 13-17,18-24, >25. I did spend some time researching the speeds to use and I do not remember where I found these intervals. My wind speeds tend to the lower end of these ranges. I wanted ranges that would capture my wind speeds at my location. You could check to see what the UKMET uses for ranges. I think windroses are more typically used for longer periods of time (30 years), but I wanted to look at shorter intervals as well. In addition to the last 24 hour windrose, I have annual, monthly, and daily windroses. I plan on creating an all time windrose - it is on the to do list with many other items:).

Kerry

Re: Highcharts Wind Rose

Posted: Fri 04 Jan 2013 2:41 am
by BCJKiwi
There is already a whole set of RecentWindxxxx tags including gust, direction, speed etc for which you can select the intervals you want (by the minute up to 1 week ago).

Of course they will only be sent to the website at the tags interval but this could be used to build a database with data every minute if you kept sending say each minute's data from 1 thru 10 every 10 minutes.

Re: Highcharts Wind Rose

Posted: Fri 04 Jan 2013 4:28 am
by gwheelo
Presumably the best solution would be for Cumulus to generate web tags containing the values? 16 arrays (one for each direction) containing the values for the 7 wind speed bands?
That is certainly the best solution for me and I suppose all the other users without integrated SQL.

gwheelo

Re: Highcharts Wind Rose

Posted: Fri 04 Jan 2013 9:38 am
by mcrossley
Kerry, yes, I'd seen that the usual Wind Rose is for a 30 year period - I guess that rules out most Cumulus users! :lol:

I also see that many people like yourself using them for shorter periods offer a range of roses covering different intervals.

It sounds more and more like a job for SQL rather than web tags to me.
BCJKiwi wrote:There is already a whole set of RecentWindxxxx tags including gust, direction, speed etc for which you can select the intervals you want (by the minute up to 1 week ago).

Of course they will only be sent to the website at the tags interval but this could be used to build a database with data every minute if you kept sending say each minute's data from 1 thru 10 every 10 minutes.
The problem is they are 'instantaneous' values (or 10 minute averages anyway), so you would have to bin and sum them for every direction to work out the percentages - only really viable from a database. If you are using SQL then you will probably already be recording the Cumulus monthly logs into a table so have the 'raw' data available anyway?

Hmm, on to the back burner again for a while I think.