Georef Database

["Aurélio A. Heckert"]

Hi all,

We have a great interest in georef, and that is a lot more important to 
EcoSol enterprises, but we still not using it very well.

We rely so much on user to set its own lat/lng on the map, but that does 
not happens. We can think on UI to make that better, but we must not 
expect 100%. In the other hand, it is easy to fill city and country.

For some geo search/filtering  we don't need the exact location, so 
giving the city lat/lng to the profile will help us to do a nice job.

So, i found this:
http://www.geonames.org/export/
This is a cool CSV database of cities with name variation (helping the 
search) country, georef and more, in CC-by.

We can write a rake command to download the last allCountries.zip file 
and fill or update the region related models, extended with the extra 
useful data from this CSV.

Please, write spec ideas here:
http://noosfero.org/Development/ActionItem2970
Also visit this pag to see more data. ;-)

Hasta!
  Aurium