GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
alternate-country-code with trailing comma  XML
Forum Index -> Discussion of GeoNames Toponyms
Author Message
[Post New]05/11/2022 09:52:11
    Subject: alternate-country-code with trailing comma
[Up]
femalepressure



Joined: 14/10/2022 20:38:27
Messages: 19
Offline
3 Switzerland entries have a trailing comma in their alternate country code (CH,):
2661349 Buchs
7285374 Buchs (SG)
7303718 Guscha

Can the comma be eliminated? Ignoring it makes the import to postgres as array (embed in {}) a little complicated.

Dealing with the alternate country codes I was wondering why about 200 thousand entries exist with their alternate country code being exactly their normal country code, while all other entries (except those with a different or with multiple alternate codes) just have a null value? Just in case there is a special reason for that I would like to know!

All the best
Andreas
Have fun
Cheers Andreas
[Post New]05/11/2022 21:15:32
    Subject: Re:alternate-country-code with trailing comma
[Up]
marc



Joined: 08/12/2005 07:39:47
Messages: 4432
Offline
I have removed the commas, set the equal countrycodes to null and added a processing step in the modify function to do this for updates.

Best Regards

Marc
[WWW]
[Post New]07/11/2022 09:33:18
    Subject: alternate-country-code with trailing comma
[Up]
femalepressure



Joined: 14/10/2022 20:38:27
Messages: 19
Offline
Thank you very much Marc!
Have fun
Cheers Andreas
 
Forum Index -> Discussion of GeoNames Toponyms
Go to:   
Powered by JForum 2.1.5 © JForum Team