I want to attach information about postal codes to main database with administrative-territorial division. Both tables with administrative-territorial division and tables with postal codes have field for admin1 code. But these codes are different. Does any tables of their correspondance exist? Where can I find them?
The geoname tables are mainly using fips codes whereas the postal code tables are using iso codes. The idea is to use iso codes in both tables.
I have started to map them. The information available so far is on the country admin div page:
http://www.geonames.org/US/administrative-division-united-states.html
I am reusing the same thread, as, as Kurush, I need to link postal codes to the related geoname entry but have trouble with iso vs fip;
in which downloadable file would I be able to connect ADM1 iso to fip codes?
![[Search]](/gforum/templates/default/images/icon_mini_search.gif){kind=icon}
![[Recent Topics]](/gforum/templates/default/images/icon_mini_recentTopics.gif){kind=icon}
![[Groups]](/gforum/templates/default/images/icon_mini_groups.gif){kind=icon}
![[Register]](/gforum/templates/default/images/icon_mini_register.gif){kind=icon}
Register![[Login]](/gforum/templates/default/images/icon_mini_login.gif){kind=icon}
Login
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif){kind=icon}
![[Up]](/gforum/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/gforum/templates/default/images/icon_www.gif){kind=icon}