GeoNames Forum

Hi,

Here is a correction in the ADM2 List :
the adm1 code is missing in :
CZ..0100 Okres Praha Okres Praha 6533385

which should be corrected (I think) into :
CZ.52.0100 Okres Praha Okres Praha 6533385

(I think Okres means something like a district in czech, and according to what I understand from these pages, http://en.wikipedia.org/wiki/Districts_of_the_Czech_Republic, http://en.wikipedia.org/wiki/Regions_of_the_Czech_Republic, http://en.wikipedia.org/wiki/Praha, http://www.aneris.cz/praha_05.html ), Okres Praha seems to be the district of Praha, which is the district of Prague, and the only district I could find in your adm1 list with praha inside is CZ.52, Praha, Hlavní Město, so I guess it is the right one... (the last link I gave writes PRAHA - hlavní město České republiky )

Thanks for reporting the change in your dumps,
Regards,
Sami

Hi,

Here is the list of circulating currencies' symbols, that, I think, would be suitable for the language dump.

I have copied them from http://en.wikipedia.org/wiki/List_of_circulating_currencies

When wikipedia doesn't give any symbol, I just use the currency code itself.

Hope it is useful for you,
Regards,
Sami Dalouche

currency.short-name.KWD = د.ك
currency.short-name.ANG = ƒ
currency.short-name.HNL = L
currency.short-name.MYR = RM
currency.short-name.COP = $
currency.short-name.PHP = ₱
currency.short-name.MDL = L
currency.short-name.MRO = UM
currency.short-name.INR = ₨
currency.short-name.CRC = ₡
currency.short-name.ISK = kr
currency.short-name.MXN = $
currency.short-name.DZD = د.ج
currency.short-name.GBP = £
currency.short-name.CLP = $
currency.short-name.JMD = $
currency.short-name.QAR = ر.ق
currency.short-name.LRD = $
currency.short-name.LVL = Ls
currency.short-name.GIP = £
currency.short-name.GEL = ლ
currency.short-name.AMD = դր.
currency.short-name.MGA = MGA
currency.short-name.MUR = ₨
currency.short-name.CAD = $
currency.short-name.BMD = $
currency.short-name.ZMK = ZK
currency.short-name.IRR = ﷼
currency.short-name.BZD = $
currency.short-name.SBD = $
currency.short-name.MNT = ₮
currency.short-name.TOP = T$
currency.short-name.TTD = $
currency.short-name.GMD = D
currency.short-name.KYD = $
currency.short-name.SYP = £, ل.س
currency.short-name.PGK = K
currency.short-name.XOF = Fr
currency.short-name.THB = ฿
currency.short-name.LAK = ₭
currency.short-name.EGP = £,ج.م
currency.short-name.BGN = лв
currency.short-name.SRD = $
currency.short-name.SHP = £
currency.short-name.UAH = ₴
currency.short-name.VUV = Vt
currency.short-name.JOD = د.ا
currency.short-name.KRW = ₩
currency.short-name.MMK = K
currency.short-name.PYG = ₲
currency.short-name.TMM = m
currency.short-name.TJS = ЅМ
currency.short-name.PLN = zł
currency.short-name.BBD = $
currency.short-name.HRK = kn
currency.short-name.NIO = C$
currency.short-name.BYR = Br
currency.short-name.RUB = р.
currency.short-name.GYD = $
currency.short-name.ARS = $
currency.short-name.RWF = Fr
currency.short-name.CHF = Fr
currency.short-name.AED = د.إ
currency.short-name.MWK = MK
currency.short-name.LBP = ل.ل
currency.short-name.TWD = $
currency.short-name.HTG = G
currency.short-name.NPR = ₨
currency.short-name.CDF = Fr
currency.short-name.LSL = L
currency.short-name.LKR = ரூ
currency.short-name.UZS = UZS
currency.short-name.IQD = ع.د
currency.short-name.PKR = ₨
currency.short-name.ILS = ₪
currency.short-name.BHD = ب.د
currency.short-name.BOB = Bs.
currency.short-name.MAD = د.م.
currency.short-name.MKD = ден
currency.short-name.JPY = ¥
currency.short-name.SCR = ₨
currency.short-name.BTN = BTN
currency.short-name.UYU = $
currency.short-name.SZL = L
currency.short-name.CZK = Kč
currency.short-name.STD = Db
currency.short-name.BSD = $
currency.short-name.FJD = $
currency.short-name.ALL = L
currency.short-name.KES = Sh
currency.short-name.SAR = ر.س
currency.short-name.OMR = ر.ع.
currency.short-name.KPW = ₩
currency.short-name.SOS = Sh
currency.short-name.NZD = $
currency.short-name.SGD = $
currency.short-name.KZT = Т
currency.short-name.BND = $
currency.short-name.LTL = Lt
currency.short-name.CUP = $
currency.short-name.GTQ = Q
currency.short-name.TND = د.ت
currency.short-name.BAM = KM
currency.short-name.ZAR = R
currency.short-name.AOA = Kz
currency.short-name.HUF = Ft
currency.short-name.PAB = B/.
currency.short-name.RON = RON
currency.short-name.AFN = ؋
currency.short-name.EEK = KR
currency.short-name.BIF = Fr
currency.short-name.WST = T
currency.short-name.DJF = Fr
currency.short-name.MOP = P
currency.short-name.KMF = Fr
currency.short-name.BRL = R$
currency.short-name.TZS = Sh
currency.short-name.SEK = kr
currency.short-name.HKD = $
currency.short-name.XAF = Fr
currency.short-name.GNF = Fr
currency.short-name.MTL = ₤
currency.short-name.CVE = $, Esc
currency.short-name.NOK = kr
currency.short-name.ETB = ETB
currency.short-name.IDR = Rp
currency.short-name.SLL = Le
currency.short-name.BWP = P
currency.short-name.DKK = kr
currency.short-name.CNY = ¥
currency.short-name.CSD = CSD
currency.short-name.NGN = ₦
currency.short-name.VND = ₫
currency.short-name.VEB = Bs
currency.short-name.MZN = MZN
currency.short-name.BDT = ৳
currency.short-name.CYP = £
currency.short-name.ERN = ERN
currency.short-name.YER = ﷼
currency.short-name.GPD = £
currency.short-name.AUD = $
currency.short-name.FKP = £
currency.short-name.EUR = €
currency.short-name.SDD = SDD
currency.short-name.NAD = $
currency.short-name.KGS = KGS
currency.short-name.XCD = $
currency.short-name.USD = $
currency.short-name.SKK = Sk
currency.short-name.GHC = ₵
currency.short-name.XPF = Fr
currency.short-name.MVR = ރ.
currency.short-name.KHR = ៛
currency.short-name.LYD = ل.د
currency.short-name.AWG = ƒ
currency.short-name.AZN = AZN
currency.short-name.ZWD = $
currency.short-name.PEN = S/.
currency.short-name.DOP = $
currency.short-name.UGX = Sh
currency.short-name.TRY = ₤

Hi Marc !

Thanks for the information ! I was thinking of doing something similar, except that I'm not confident in the "largest population" trick..

Consider the case of some small city that is divided into sections, and that is near a larger city. (I think PPLX can apply to small cities, it is not necessarily an Arrondissement of Paris, it can be whatever part of any town). So, in that case, if you try to match the PPLX to this small city, it is going to find Paris, which is not what we want....

Another question.. What do you consider as a "city" ? My definition of a city is PPL, PPLA, PPLC, PPLG, PPPL, PPLR, PPLS, STLMT, out of which I remove all features that contain the word "(historical)". What is your opinion about that ?

Thanks for your help !
Sami Dalouche

Hi,

It looks like the zip codes are sometimes associated to Cities (PPL, PPLC, ..), and sometimes to sections of cities (PPLX..), like #6459135.

So, I'm wondering whether it is possible to find the city that a PPLX refers to.

Does anyone have an idea ?
Thanks,
Sami Dalouche

Just one question concerning the dump...

If the dump is meant to evolve, wouldn't it be easier if it used some XML format, that is both more readable and backward-compatible ?

This is purely a suggestion, the most important thing is that we have the data in whatever format

Sami Dalouche

Hi,

there's one of these weird escape characters(ESC) in alternate name id #1210278

1210278 2578103 AïneESC Djahfa

thanks

Sami

A 4 character-long code can also be "post", for postal codes

Hmm.. actually, I was wrong.. the file does contain everything...

So, please excuse my mistake

Sami

Hi,

I am wondering whether the alternate names dump is working correctly :
http://download.geonames.org/export/dump/alternateNames.zip

Indeed, the dump does not seem to contain :
- the "isOfficial" column
- the misc. additional information, such as the postcodes, that we can find in the incremental updates (http://download.geonames.org/export/dump/alternateNamesModifications-2007-04-21.txt)

Is there something I am missing ? or is it really the dump that is broken ?
Thanks,
Sami Dalouche

marc wrote:

Hi Sami

I have added a comment header to the file countryInfo.txt : http://download.geonames.org/export/dump/countryInfo.txt

A header with explanation is required anyhow and it could be sufficient. There are only a handful of countries with special currencies. I don't know how much sense it makes to automatically parse them as every application has to decide what to do with these special cases.

Marc

I agree this is currently the best thing to do.

Just one question : what is the difference between http://geonames.cvs.sourceforge.net/geonames/data/countries.txt?revision=1.7&view=markup
and http://download.geonames.org/export/dump/countryInfo.txt ?

The file on CVS seems to have more fields....

marc wrote:

Hi Isa
The number of alternate names per language is unlimited. For Paris we have alone four alternate names in French : Paris, Lutece, Pantruche and Paname. Only the number of 'isOfficial/isPreferred' is limited to one.

For the postal codes in Paris it is a little bit more complicated, because we have an entry in the geonames database for each of the 20 Arrondissements. The postal codes 75001-75020 are assigned to the corresponding Arrondissement.

Regards

Marc

Hi,

is it possible to easily query for all arrondissements of Paris, for instance ?

Thanks,
Sami

the advantage I see for the additional column is that it can be automatically processed, whereas the comments need to be processed by someone, etc...

On the other hand, I agree that these columns (equivalentFipsCode and this one) are not generic enough to be there....

An example of where comments can be problematic is for your incremental updates, for instance... for deletions, comments are written in english (duplicate of #..), which means that is is impossible to take any automatic action regarding the deletion. I would tend to think we should not have that kind of stuff everywhere...

So, something different that could be possible would be to prefix the iso codes by something that would describe if it is ISO or not :
iso:GGP
noniso:JEP

What do you think ?

You mean "currency code" instead of "country code", right ?

I'm not really sure of the best approach... because saying that guernsay uses GBP is not 100% true since they issue their own notes, and banks seem to consider GGP (and JEP, since jersey is in the same case) as different currencies... But at the same time, entering a non ISO 4217 currency code is kind of awkward and error-prone...

BTW, in the file, it looks like Jersey is associated to "GPD", which doesn't seem to exist.. the british pound is GBP, and Jersey Pound non-official code is JEP..

So, basically, we have 6 countries that are in the same case, and whatever we choose, we must be consistent... So we can :
1] put the official iso code for these 6 territories,
2] set no currency for these countries
3] add the non ISO code as a separate column.

I would tend to think solution 3) would the best, but what do you think ?

----------------
http://en.wikipedia.org/wiki/ISO_4217 :
A number of territories are not included in ISO 4217, because their currencies are not per se an independent currency, but a variant of another currency. These currencies are:

1. Faroese króna (1:1 pegged to the Danish krone)
2. Guernsey pound (1:1 pegged to the pound sterling)
3. Jersey pound (1:1 pegged to the pound sterling)
4. Isle of Man pound (1:1 pegged to the pound sterling)
5. Tuvaluan dollar (1:1 pegged to the Australian dollar).
6. Cook Islands dollar (1:1 pegged to the New Zealand dollar).

The following non-ISO codes are, however, sometimes used: "GGP" for the Guernsey pound", "JEP" for the Jersey pound and "IMP" for the Isle of Man pound [1].

And yet another correction :

http://www.iso.org/iso/en/prods-services/popstds/currencycodeslist.html
Mozambique's currency is MZN, not MZM.

corrected

I also forgot :

Serbia => RSD and not CSD
Serbia and Montenegro => RSD
Montenegro => EUR

(http://en.wikipedia.org/wiki/Serbia_and_Montenegro ,

http://www.iso.org/iso/en/prods-services/popstds/currencycodeslist.html
)

These are also corrected in the file

Oh, and another correction I added in the file is for Slovenia.

Slovenia doesn't use the Tholar anymore, since they adopted the Euro since 2007.. (http://en.wikipedia.org/wiki/Slovenia)

Here is a modified version of your countries files, with a few corrections :
http://www.sirika.com/data/geonames/geonamesCountries.20070407.txt

Corrections :
- French Southern Territories

http://fr.wikipedia.org/wiki/Terres_australes_et_antarctiques_fran%C3%A7aises
> La monnaie officielle des TAAF est l'euro (et non le franc Pacifique utilisé dans > les collectivités d'outre-mer du Pacifique, bien que la Terre Adélie soit plus
> proche de l'Australie et la Nouvelle Calédonie que de la Réunion) ;
> c'était le franc français avant 1999.

The currency was not set, so it's now set to EUR

Guernsey currency :
http://en.wikipedia.org/wiki/Guernsey_pound
GPD => GGP

Regards,
Sami Dalouche

Ok, another problem.. this time, it's the alternate Name #1210278 : AïneESC Djahfa that has this weird ESC character...

Hopefully, this is the last one I'll discover

Regards,
Sami Dalouche

Oh, Another feature that has a weird character : 4818789

this one contains the Ctrl-C sequence

Regards,
Sami Dalouche

Thanks Marc !

Sami