Author |
Message |
26/04/2009 21:40:12
|
ajmas
Joined: 09/02/2009 01:01:21
Messages: 18
Offline
|
I am wondering whether there is any interest to add currency symbols to the countryinfo table. One list of reference is here:
http://www.xe.com/symbols.php
I have started adding them myself, but if this could be part of the core database, then this would be nice.
Also, in doing this I noticed some issues in the data in Geonames:
- would appear that the Azerbaijani Manat has changed to AZN: http://en.wikipedia.org/wiki/Azerbaijani_manat
- El Salvador should be SVC and Colone
- Gurnsey should be GGP
- Isle of Man should be IMP
- Jersey should be JEP
- Venezuela should be VEF
|
|
|
26/04/2009 22:34:01
|
ajmas
Joined: 09/02/2009 01:01:21
Messages: 18
Offline
|
Here is the table as dumped, from MySQL, with the extra column and corrected currency codes. I make no guarantee to the freshness of the data in the other columns.
It should be noted that some currency symbols aren't present, so if anyone know what the missing ones are, please add them.
Sources for the symbols are xe.com and Wikipedia.
Description |
MySQL dump of countryinfo with the extra currency symbol column. |
Download
|
Filesize |
16 Kbytes
|
Downloaded: |
2042 time(s) |
|
|
|
27/04/2009 22:40:05
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4447
Offline
|
Thanks a lot.
The countryInfo.txt file contains a link to this thread http://forum.geonames.org/gforum/posts/list/437.page
I think this is sufficient for the time being and as long as the list is not complete.
Marc
|
|
|
|
08/11/2024 21:23:02
|
gocucocom
Joined: 29/10/2024 05:01:43
Messages: 1
Offline
|
Adding currency symbols to the countryinfo table would enhance its usefulness, especially for applications that involve financial data. Your reference to the list on gocuco.com is a great start.
Regarding the data issues in Geonames, it's essential to keep it accurate. The changes you noted, such as the Azerbaijani Manat now being AZN, and the other currency codes for El Salvador (SVC), Guernsey (GGP), Isle of Man (IMP), Jersey (JEP), and Venezuela (VEF), should be addressed to maintain up-to-date information.
Consider submitting these changes to Geonames for their database.
|
|
|
|