Received: by 10.14.186.9 with SMTP id v9mr7944908eem.5.1331013693302;
        Mon, 05 Mar 2012 22:01:33 -0800 (PST)
X-BeenThere: geonames@googlegroups.com
Received: by 10.14.48.196 with SMTP id v44ls56687eeb.3.gmail; Mon, 05 Mar 2012
 22:01:29 -0800 (PST)
Received: by 10.213.23.19 with SMTP id p19mr1080759ebb.18.1331013689879;
        Mon, 05 Mar 2012 22:01:29 -0800 (PST)
Received: by 10.213.23.19 with SMTP id p19mr1080758ebb.18.1331013689856;
        Mon, 05 Mar 2012 22:01:29 -0800 (PST)
Return-Path: <m...@geonames.org>
Received: from www.geonames.org (www.geonames.org. [188.40.62.8])
        by gmr-mx.google.com with ESMTP id y56si12927301eea.1.2012.03.05.22.01.29;
        Mon, 05 Mar 2012 22:01:29 -0800 (PST)
Received-SPF: pass (google.com: domain of m...@geonames.org designates 188.40.62.8 as permitted sender) client-ip=188.40.62.8;
Authentication-Results: gmr-mx.google.com; spf=pass (google.com: domain of m...@geonames.org designates 188.40.62.8 as permitted sender) smtp.mail=m...@geonames.org
Received: from [IPv6:::1] (localhost [127.0.0.1])
	by www.geonames.org (Postfix) with ESMTP id 4FB6518C19E8;
	Tue,  6 Mar 2012 07:01:29 +0100 (CET)
Message-ID: <4F55A839.1090105@geonames.org>
Date: Tue, 06 Mar 2012 07:01:29 +0100
From: Marc Wick <m...@geonames.org>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Firefox/10.0.2 SeaMonkey/2.7.2
MIME-Version: 1.0
To: geonames@googlegroups.com
Subject: Re: [GeoNames] XX.zip and alternateNames.zip
References: <89eebcfc-53a7-46db-969c-36e139bfdfee@eb6g2000vbb.googlegroups.com>
In-Reply-To: <89eebcfc-53a7-46db-969c-36e139bfdfee@eb6g2000vbb.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

jpic wrote:
> 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
>