GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Bulk delete alternate names for counties in French  XML
Forum Index -> Discussion of GeoNames Toponyms
Author Message
geojan



Joined: 15/02/2021 19:31:41
Messages: 2
Offline

There are a lot of county names where the French version seems like an import error occurred, dropping the apostrophe.

For instance: « Comté d'Union » has become « Comté dUnion », or « Comté d'Huntington » has become « Comté dHuntington ». There are 224 such mistakes according to:

Code:
SELECT
 	id, geoNameId, lang, name
 FROM
 	geo_alternateNames
 WHERE
 	lang = 'fr'
     AND name LIKE 'Comté d%'
     AND NOT name LIKE 'Comté de %'
     AND NOT name LIKE 'Comté du %'
     AND NOT name LIKE 'Comté d''%'
 


I tried deleting a few, but this would be faster to automate.
 
Forum Index -> Discussion of GeoNames Toponyms
Go to:   
Powered by JForum 2.1.5 © JForum Team