GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
I want to help with the Colombian admin divisions  XML
Forum Index -> Administrative Divisions
Author Message
calvera



Joined: 02/12/2008 17:14:35
Messages: 2
Offline

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.


Here is a list of the complete divisions:
http://en.wikipedia.org/wiki/Municipalities_of_Colombia

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

A little thing I don't understand is why the "Achí" municipality you can see it here as adm2 (Colombia » Bolívar » Achí):
http://www.geonames.org/3690550/achi.html

but not here:
http://geotree.geonames.org/?id=CO

marc



Joined: 08/12/2005 07:39:47
Messages: 4412
Offline

Hi Calvera

Thanks a lot. A flat csv file with the new records would be fine.

There are already a lot of admin2 records: http://www.geonames.org/search.html?q=adm2+co&country=CO

you can get the admin2 code from dane: http://www.dane.gov.co/files/censo2005/provincias/subregiones.pdf

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.

Best

Marc

[WWW]
calvera



Joined: 02/12/2008 17:14:35
Messages: 2
Offline

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
marc



Joined: 08/12/2005 07:39:47
Messages: 4412
Offline

Hi Calvera

Thanks, I have updated the database with your fixes.

Best

Marc

[WWW]
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team