GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
IATA City Codes not joining?  XML
Forum Index -> General
Author Message

Joined: 21/04/2020 17:00:02
Messages: 1

Hi All,

In alternateNamesV2.txt I count 20,371 alternate names in the "iata" category. However, when I join these with the base table on geonameid (field 2 in alternateNamesV2.txt) only 7,082 rows join, leaving 13,289 iata alternate names that are joining. Does anyone know why this is happening?

Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team