GeoNames Forum

Hi,

in a recent blog entry (http://geonames.wordpress.com/2008/03/06/geotree-hierarchical-toponym-browser/), you wrote about the GeoTree widget displaying flags from wikipedia.

How did you do the mapping between the flag names and the ADM codes ?

Is the mapping data with the flags bundle available ?

thanks,
sami dalouche

Hi Sami,

as explained in GeoTree Credits section,
country flags come from http://flags.blogpotato.de/
other flags and coats of arms from Wikipedia.

At the moment they are stored in a CSV file :
Code:

 GeoNameId	URL
 3038033	http://upload.wikimedia.org/wikipedia/commons/thumb/7/71/Alzacja_herb.png/100px-Alzacja_herb.png
 3037350	http://upload.wikimedia.org/wikipedia/commons/thumb/7/72/Blason_de_l%27Aquitaine_et_de_la_Guyenne.svg/100px-Blason_de_l%27Aquitaine_et_de_la_Guyenne.svg.png
 3035876	http://upload.wikimedia.org/wikipedia/commons/thumb/c/c8/Blason_de_l%27Auvergne.svg/100px-Blason_de_l%27Auvergne.svg.png
 3030967	http://upload.wikimedia.org/wikipedia/commons/thumb/c/cc/Blason_fr_Bourgogne.svg/100px-Blason_fr_Bourgogne.svg.png
 3030293	http://upload.wikimedia.org/wikipedia/commons/thumb/2/26/COA_fr_BRE.svg/100px-COA_fr_BRE.svg.png
 3027939	http://upload.wikimedia.org/wikipedia/commons/thumb/2/2d/Blason_Centre.svg/100px-Blason_Centre.svg.png
 etc...

Mapping was easy for France using adminCode3/adminCode4 found on wikipedia pages.

Would you like to help us for some other countries ?

I'm also interested in the subdivisions flags and coats of arms

All the csv pointing to the png are at http://geotree.geonames.org/img/blasons/, but I don't understand well those csv

For example, for France, there're FR.csv and FR_06.csv, which one to use ?

=> Is there a massive .csv file that may contain all links ? (much easier to process)

Another thing, those csv contain links towards the thumb version of the image (not the biggest image so), with an url that points to a specific version of the file (not always the last version of the coat of arms for example)

As a result, it would be much better to have a csv file that indicates the wikimedia html resources, where are listed the very last version of the coat of arms (including all previous versions of it)

For example, instead of currently value in the csv:
http://upload.wikimedia.org/wikipedia/commons/thumb/7/71/Alzacja_herb.png/100px-Alzacja_herb.png

The perfect link would be http://commons.wikimedia.org/wiki/File:Alzacja_herb.png (where it's easy to parse and retrieve the url of the native image: http://upload.wikimedia.org/wikipedia/commons/7/71/Alzacja_herb.png)

That way, easy afterwards to create a fetch process that scans each html wikimedia resource to get the url of the very last version of the coat of arms, and then process some image filters and so on to have the tiny image for the application (geotree for example)

=> Have you this matching already?