XX.zip and alternateNames.zip

[jpic]

Hi all,

I don't understand how to join data from XX.zip with
alternateNames.zip. According to alternateNames.zip, XX.zip should
provide with geonameid column. But that's not the case.

This is the structure of an XX.txt from XX.zip (from the readme.txt
file):

country code : iso country code, 2 characters
postal code : varchar(20)
place name : varchar(180)
admin name1 : 1. order subdivision (state) varchar(100)
admin code1 : 1. order subdivision (state) varchar(20)
admin name2 : 2. order subdivision (county/province)
varchar(100)
admin code2 : 2. order subdivision (county/province) varchar(20)
admin name3 : 3. order subdivision (community) varchar(100)
admin code3 : 3. order subdivision (community) varchar(20)
latitude : estimated latitude (wgs84)
longitude : estimated longitude (wgs84)
accuracy : accuracy of lat/lng from 1=estimated to 6=centroid

This is the structure of alternateNames.zip:

alternateNameId : the id of this alternate name, int
geonameid : geonameId referring to id in table 'geoname', int
isolanguage : iso 639 language code 2- or 3-characters; 4-
characters 'post' for postal codes and 'iata','icao' and faac for
airport codes, fr_1793 for French Revolution names, abbr for
abbreviation, link for a website, varchar(7)
alternate name : alternate name or name variant, varchar(200)
isPreferredName : '1', if this alternate name is an official/
preferred name
isShortName : '1', if this is a short name like 'California' for
'State of California'

Thank you in advance

[Denis Arnaud]

Hi,

On Mar 3, 12:14 pm, jpic <james...@gmail.com> wrote:
> I don't understand how to join data from XX.zip with
> alternateNames.zip. According to alternateNames.zip, XX.zip should
> provide with geonameid column. But that's not the case.

allCountries.zip (which aggregates the information of all the
countries, i.e., all XX.zip files) contains, for sure, the geonameid
column.

[Marc Wick]

Hi

The postal code extract is a separate table and not related to the
gazetteer files. There is no relation between the two.

Best Regards

Marc

[James Pic]

Got it, thanks.