http://forum.geonames.org/gforum/posts/list/4.page JForum - http://www.jforum.net http://forum.geonames.org/gforum/posts/list/1567.page#6515 http://forum.geonames.org/gforum/posts/list/1567.page#6515 GMT Gisgraphy i got the same question, i have coded an algorithm that try to detect adm by codes and try to correct (potential) errors. You can see the code here or use the gisgraphy importer that inject geonames csv files into a postgres database in a tree structure Hope it helps David]]> http://forum.geonames.org/gforum/posts/list/1567.page#6516 http://forum.geonames.org/gforum/posts/list/1567.page#6516 GMT http://forum.geonames.org/gforum/posts/list/1567.page#6525 http://forum.geonames.org/gforum/posts/list/1567.page#6525 GMT http://forum.geonames.org/gforum/posts/list/1567.page#6527 http://forum.geonames.org/gforum/posts/list/1567.page#6527 GMT http://forum.geonames.org/gforum/posts/list/1567.page#6529 http://forum.geonames.org/gforum/posts/list/1567.page#6529 GMT