I was trying to read the dump of the US cities: http://download.geonames.org/export/dump/US.zip But then I found out the mapping between states and places is NOT correct. Here are some examples:
Houston has code “AL” for Alabama, where it should be Texas
Los Angeles has code “TX” for Texas, where it should be California
Phoenix has code “GA” for Georgia (I think), where it should be Arizona
![[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}