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
femalepressure



Joined: 14/10/2022 20:38:27
Messages: 7
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
marc



Joined: 08/12/2005 07:39:47
Messages: 4325
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]
femalepressure



Joined: 14/10/2022 20:38:27
Messages: 7
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