GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register /  [Login] Login 
Some regions are duplicated ?  XML
Forum Index -> General
Author Message
[Post New]14/02/2015 21:45:05
    Subject: Some regions are duplicated ?
[Up]
pythdasch



Joined: 09/02/2015 12:30:58
Messages: 1
Offline
Hi

We are using Geonames, and we are facing some duplicates region so we would like to know if it's correct or if it's an issue.

Here are the duplicates regions/ countries we found :
[code]# select slug, count(*) from cities_region group by slug, country_id having count(*) > 1;
slug | count
---------------+-------
daugavpils | 2
lima | 2
ash-sharqiyah | 2
vientiane | 2
al-batinah | 2
(5 rows)
[Post New]31/03/2015 23:03:53
    Subject: Re:Some regions are duplicated ?
[Up]
m.arnold


[Avatar]

Joined: 25/02/2015 14:16:26
Messages: 1
Offline
There are some duplicates inside the admin1CodesASCII.txt:

Code:
grep -E '(Minsk|Vientiane|Daugavpils|Ash Sharqiyah|Al Batinah|Lima)' admin1CodesASCII.txt


BY.05 Minsk Minsk 625142
BY.04 Minsk Minsk 625143

LA.27 Vientiane Vientiane 1652238
LA.24 Vientiane Vientiane 1904618

LV.07 Daugavpils Daugavpils 460410
LV.06 Daugavpils Daugavpils 460414

OM.04 Ash Sharqīyah Ash Sharqiyah 411738
OM.12 Ash Sharqiyah Ash Sharqiyah 8394433

OM.02 Al Bāţinah Al Batinah 411736
OM.11 Al Batinah Al Batinah 8394434

PE.LMA Lima Lima 3936451
PE.15 Lima Lima 3936452
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team