In the pluto_main database, there are three tables, Country, Region, and City, which are ultimately used to find a particular city or town. I want the Weather device to use this data, to pick not only which weather data to display, but also which weather radar data to automatically select for display.

But for this to work, I need lots of data mapped.

Here is a list of all the maps that Weather.com offers from its map room.

And these need to be mapped to countries and regions in the LinuxMCE database, so that when the Weather device looks at your installation, it will select the most appropriate maps to display.

Does anyone want to help? Yes, this is exceedingly tedious, and potentially thousands of mappings may need to be done, but in the end, it will allow for an ease of use and a "just works" functionality that everyone can appreciate.

I will point out, that not EVERY single city needs to be mapped, just the countries and regions.

I would be very indebted to those who help out, and help to make the weather functionality in LinuxMCE heads and shoulders above everything else out there!

Since I have found very few ways in which to give back to the community, I will volunteer my services for this task as it doesn't appear to require any specific technical skill. Just let me know how you would like it done...

Attached, I have an excel spreadsheet containing all 50 states for the US, as a starting test for this.

What needs to happen is this:

The maps.xml (https://96.226.245.101/work/maps.xml) needs to be read through with human eyes, and each map perused. You'll see that each map has at LEAST a static image, and maybe an animated set of images. If you open these up, for example:

you see? Take a look at each of those maps, and you'll get the idea. It turned out the South Central maps are relevant for Texas, but I'm willing to bet there are others relevant too. There are specific maps e.g. for California (smog alerts etc), and New York, etc., as well as airport maps etc..

Anything that is local to the given state, is relevant in this table. I will add additional maps that are relevant all over, but the hard part is trying to sort the regional stuff and pair it all together.

The key here, is that all of this be consistent. If there is no animated image, it should be left blank. only the base URL for the animated image should be used (as the filenames will always be the same), I can then take this data, and parse it into something I can manipulate.

Have a go, and if you have any questions, let me know. I'm here writing the code that will take what you've prepared, and utilize it.

Wow, there is a lot to sort through! I am working on it but it is going to take sometime to complete - probably won't be done til tonight. I am only using the base URL for the animated ones, let me know if you want that differently.

Here is what I have so far... still a lot to add. I am only adding to states that appear in their entirety on each map. I still need to comb back through and check for duplicates as it can get a little confusing when dealing with this much information. Let me know if you want anything changed.