'mysql return 360 degrees returned with strengths

I have a table of wind directions and strengths over a 24 hour period, sample data at the bottom of this question.

only directions that have strengths are stored in the database, I'm currently using the following SQL:

SELECT winddirection, avespeed 
FROM  wp_weather_data 
WHERE ID%10 = 0

what I would like to return is an entry for every degree (0 value for any degree not in the db) and where there are multiple entries for a given degree to only return the highest value. Oh, and they need to be in ascending order of degrees.

Is this possible?

This is so I can plot a wind distribution chart on a polar chat plugin in WordPress.

sample data returned from the above sql:

mysql sql charts

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'mysql return 360 degrees returned with strengths

Sources

Related Questions