I just discovered geonames a couple of weeks ago and i think is a really good work you do here!
I need mostly the admin divisions of Europe and Colombia. The ones in Europe are really good, but in Colombia there are some of the adm2 divisions missing.
Departments are the adm1 and municipalities the adm2
So I would like to help to entry the rest of divisions but I'm not sure how to do it.
I think all of them should be already at the data base as populated places.
So we would only need to duplicate them and assign an adm2 code and the population of the hole municipality ( that should be higher than the populated place because can contain some other populated places )
The admin2 code should be there to allow children for than division, is that right?
At this moment there is none at the data base
My proposal is to insert them at my local geonames data base and send you the insert statements so you can check them
Achi does not show up on the geotree as its admin1code '05' is missing in the database. It is displayed in the webinterface as an obsolete code. I will fix this.
Ok, I see there are 862 second admin divisions and the total is 1119, so I'll insert the rest.
I found out what the problem was with Achí, and I've seen as well that there are the following orfaned second divisions:
05, 06, 07, 18 adm1code in second divisions missing in first divisions
the ones with 05 corresponds to bolívar which is 35
I made this change:
UPDATE geoname SET admin1='05' WHERE country='co' and admin1='35';
the ones with 06 corresponds to boyacá which is 36
I made this change:
UPDATE geoname SET admin1='06' WHERE country='co' and admin1='36';
the ones with 07 corresponds to caldas which is 37
I made this change:
UPDATE geoname SET admin1='07' WHERE country='co' and admin1='37';
the ones with 18 corresponds to Magdalena which is 38
I made this change:
UPDATE geoname SET admin1='18' WHERE country='co' and admin1='38';
I supose you have all this right somewhere because when you search for the second admin division like in "Achí" the results shows the right admin divisions