Duplicated UN/LOCODEs

[salim-b]

There are various geographical locations that have multiple UN/LOCODEs assigned. One example is the Swiss municipality Schönenbuch that has two entries in locodes/CH.csv that only differ in the change date and the LOCODE itself (SBC vs. SOH).

This raises the following questions:

1. Why are there multiple UN/LOCODEs per entity in the first place? Are those "coding errors"?

2. Is there a "best practice" on how to handle such duplicates? Should we e.g. always take the entry with the most recent change date¹?

Footnotes

1. Although that particular heuristic wouldn't suffice to resolve all duplicates since there are entries that don't even differ in the change date but only the LOCODE. ↩

[cristan]

Other instances I've found:

AOVPE (Ongiva) should be deleted in favor of AONGV (Ondjiva)
ARPNL (Puerto Nacional/Bahia Blanca) should be deleted in favor of ARBHI (Bahía Blanca)
ATWDD (Weissenstein ob der Drau) should be deleted in favor of ATWSS (Weissenstein)
AUCAL (Caloundra Head) should be deleted in favor of AUCUD (Caloundra)
AUWEH (Wetherhill) should be deleted in favor of AUWPA (Wetherill Park)
BGGOV (Gorna Oryahovica) should be deleted in favor of BGGOZ (Gorna Oryakhovitsa)
BGIPR (Isperikh) should be deleted in favor of BGISP (Isperih)
CZRPR (Roznov pod Radhosthem) should be deleted in favor of CZRVR (Roznov pod Radhostem)
ECSDO (Santo Domingo de los Colorados) should be deleted in favor of ECSGO (Santo Domingo)
ESBAZ (Bazalote) should be deleted in favor of ESBLZ (Balazote)
ESCBB (Castilbisbal) should be deleted in favor of ESCLL (Castellbisbal)
ESCRI (Cierbena) should be deleted in favor of ESZBA (Zierbena)
ESEGD (El Gador) should be deleted in favor of ESGAO (Gádor)
ESFJN (Fuentejalon) should be deleted in favor of ESFUZ (Fuendejalón)
ESYAN (Gayanes) should be deleted in favor of ESGIS (Gaianes)
ESGJI (Granja de San Idelfonso) should be deleted in favor of ESG9F (La Granja de San Idelfonso)
ESGDX (Guadasuar) should be deleted in favor of ES3SS (Guadassuar)
ESLJM (La Ametlla del Vall) should be deleted in favor of ESZBV (L'Ametlla del Vallès)
ESLSF (Les Franquesese) should be deleted in favor of ESFQV (Les Franqueses del Vallès)
ESLJQ (Les Presses) should be deleted in favor of ESZGT (Les Preses)
ESLHP (Llombay) should be deleted in favor of ESYOM (Llombai)
ESMXX (Maraleda) should be deleted in favor of ESM8Z (Moraleda de Zafayona)
ESMXH (Maraleja) should be deleted in favor of ESMRL (Moraleja)
ESMDB (Massies de Voltregà) should be deleted in favor of ESVOL (Las Masías de Voltregá)
ESMFH (Menjibar) should be deleted in favor of ESGIB (Mengibar)
ESMBC (Mollerusa) should be deleted in favor of ESMOE (Mollerussa)
ESMJU (Muelva) should be deleted in favor of ESHUV (Huelva)
ESPDZ (Pedraneras) should be deleted in favor of ESLPD (Las Pedroñeras)
ESPNR (Penarrolla) should be deleted in favor of ESPVO (Peñarroya Pueblonuevo)
ESPBN (Pueblo Nuevo del Guadian) should be deleted in favor of ESPBG (Pueblonuevo del Guadiana)
ESPSM (Puerto de Santa Maria) should be deleted in favor of ESESM (El Puerto de Santa María)
ESRDP (Renedo de Pielago) should be deleted in favor of ESPGO (Pielagos)
ESSDB (San Andreas de La Barca) should be deleted in favor of ESADQ (San Andrés de la Barca)
ESSBG (San Bartolome D/Grau) should be deleted in favor of ESZLU (Sant Bartomeu del Grau)
ESSJM (San Juan D Moro) should be deleted in favor of ESJDM (Sant Joan De Moró)
ESSJN (San Juan de Nivea) should be deleted in favor of ESSJX (San Juan de Nieva)
ESSJF (San Juan Le Fonts) should be deleted in favor of ESSJL (Sant Joan Les Fonts)
ESSQU (San Quirico Del Vall) should be deleted in favor of ESSQV (Sant Quirze del Valles)
ESSSR (San Sebastian D/L Reyes) should be deleted in favor of ESZLT (San Sebastian de los Reyes)
ESSXX (Sangenjo) should be deleted in favor of ESHVC (Sanxenxo)
ESZLR (Sant Quirze Valles) should be deleted in favor of ESSQV (Sant Quirze del Valles)
ESSPB (Santa Perpetua de Bogota) should be deleted in favor of ESSPM (Santa Perpètua de Mogoda)
ESVAR (Valderubio) should be deleted in favor of ESVXB (Valderrubio)
ESVCP (Valencia de la Concepcion) should be deleted in favor of ESZMX (Valencina de la Concepcion)
ESDGS (Villandangos) should be deleted in favor of ESVPR (Villadangos del Páramo)
ESVAK (Visos Del Alcor) should be deleted in favor of ESEVI (El Viso del Alcor)
GAMYB (Mayoumba) should be deleted in favor of GAMBA (Mayumba)
GBLEW (Edgeware) should be deleted in favor of GBEDG (Edgware)
GBGDF (Great Driffield) should be deleted in favor of GBDRF (Driffield)
GBKRA (Kilkardy) should be deleted in favor of GBKKD (Kirkcaldy)
GBOAK (Oakhamness) should be deleted in favor of GBOKM (Oakham)
GBMBN (Wimeborne) should be deleted in favor of GBWIM (Wimborne Minster)
GRSOR (Soupri) should be deleted in favor of GRTSS (Soúrpi)
GRSTY (Stylinda) should be deleted in favor of GRSYS (Stylída (Stylis))
GUAGA (Agana) should be deleted in favor of GUHGT (Hagatna)
IDBJU (Banjuwangi, Java) should be deleted in favor of IDBNI (Banyuwangi)
IDSOC (Solo City) should be deleted in favor of IDSKT (Surakarta)
INDAE (Daparizo) should be deleted in favor of INDEP (Deparizo)
INGGA (Gogha) should be deleted in favor of INGHA (Ghogha)
INTRZ (Tiruchirapalli) should be deleted in favor of INTRI (Tiruchirappalli)
INUMB (Umbergoan) should be deleted in favor of INUMG (Umbergaon)
INVIG (Vizagapatanam) should be deleted in favor of INVTZ (Visakhapatnam)
INWGC (Warrangal) should be deleted in favor of INWRA (Warangal)
MASEK (Ksar Es Souk) should be deleted in favor of MAERH (Errachidia)
MYLPK (Northport/Pt Klang) should be deleted in favor of MYPKG (Port Klang (Pelabuhan Klang))
PKHRU (Haripur Hazara) should be deleted in favor of PKHPR (Haripur)
PKJHC (Jhang City) should be deleted in favor of PKJNG (Jhang)
PKQCT (Qasim International Container Terminal/Karachi) should be deleted in favor of PKBQM (Muhammad Bin Qasim/Karachi)
PLOAI (Omianki) should be deleted in favor of PLLOK (Lomianki)
RUKDT (Kronshtadt) should be deleted in favor of RUOKR (Kronstadt)
SAEAM (Nejran) should be deleted in favor of SANJN (Najran)
SKJAO (Jasova) should be deleted in favor of SKJSV (Jasová)
TMCRZ (Tchardjou) should be deleted in favor of TMTK5 (Turkmenabat)
USDFN (De Funiak Springs) should be deleted in favor of USDU5 (De Funiak Springs)
USLMW (Lakemills) should be deleted in favor of USXHQ (Lake Mills)