"Open Weather" is an open data project that shows historical data for cities. To give you an of the size of the files/data, it lists 19,722 cities in the US alone.
We want to basically work with this data using whatever technology currently interests us. Possibly we do this on the front end in javascript, but it's also possible we use PHP to render PNG files, and serve those PNG files as static images to show year-round weather.
The main thing that interests me about this is I want to plot each city on a map - This data format includes the lattitude and longitude of each city- so we can go through each row of the data and put the lattitude and longitude into a google maps marker. We put markers at each city, and when you click the marker show the average daily high and low temperature each day of the year. The idea is to have hundreds of spots on the map - but then above the map there are things you can specify like "I want' to live somewhere that never really gets below 60", or "I want to live somewhere rainy". Then, the number of points on the map gets lower, but with the points on the map that remain, you know they meet your requirements.
We will iterate on this and show more than just the average weather high/low, we will later show living standards information - median income, cost of goods, cost of housing and utilities(electric), a link to goole or if they have an official tourist page, stuff like that. First we put together all the pieces where we do have a graph of the high/low temp for the year appear once we click the marker for that city.