I would like to build a local dataset of monthly averages for rainfall, sunshine hours, temperate (C/F) for all the major cities of the world.
I have all the lon/lat's stored for all the cities I need in SQL, so what is the best way to mine this data?
The links to the monthly Global Historical Climatology Network files seem to be broken, and I wouldn't quite know the best way to parse them.
I can consume an API if there is a free one; but it also looks like what Weather Underground offers;
I know its a lot of data I need, but I really need to find a free source for this data ideally, or at worst one which wont cost hundreds of dollars.
Can anyone help?