GeoNames Forum

why it has as much repeated?

(geonameid is different)
i.e: (geonameid, name)

L 3452016 Quilombo
L 3452018 Quilombo
L 3452019 Quilombo
L 3452020 Quilombo
L 3452021 Quilombo
L 3452022 Quilombo
L 3452023 Quilombo

L 3451582 Retiro
L 3451583 Retiro
L 3451584 Retiro
L 3451585 Retiro
L 3451586 Retiro
L 3451588 Retiro
L 3451589 Retiro
L 3451590 Retiro
L 3451591 Retiro
L 3451599 Retiro

L 3451374 Ribeirão
L 3451375 Ribeirão
L 3451376 Ribeirão
L 3451377 Ribeirão
L 3451378 Ribeirão
L 3451379 Ribeirão
L 3451380 Ribeirão
L 3451353 Ribeirão

L 3450317 Santa Cruz
L 3450318 Santa Cruz
L 3450321 Santa Cruz
L 3450324 Santa Cruz
L 3450326 Santa Cruz
L 3450327 Santa Cruz
L 3450331 Santa Cruz
L 3450332 Santa Cruz
L 3450333 Santa Cruz
L 3450336 Santa Cruz
L 3450337 Santa Cruz

L 3450143 Santa Luzia
L 3450144 Santa Luzia
L 3450145 Santa Luzia
L 3450147 Santa Luzia
L 3450148 Santa Luzia
L 3450150 Santa Luzia
L 3450151 Santa Luzia
L 3450152 Santa Luzia
L 3476917 Santa Luzia

L 3449888 Santa Rita
L 3449892 Santa Rita
L 3449893 Santa Rita
L 3449894 Santa Rita
L 3449896 Santa Rita
L 3449897 Santa Rita
L 3449899 Santa Rita
L 3449901 Santa Rita
L 3449904 Santa Rita

L 3449638 Santo Antônio
L 3449639 Santo Antônio
L 3449647 Santo Antônio
L 3449649 Santo Antônio
L 3449650 Santo Antônio
L 3449651 Santo Antônio
L 3449653 Santo Antônio
L 3449654 Santo Antônio
L 3449655 Santo Antônio
L 3449656 Santo Antônio
L 3449658 Santo Antônio
L 3449659 Santo Antônio
L 3449662 Santo Antônio
L 3449663 Santo Antônio
L 3449664 Santo Antônio
L 3449665 Santo Antônio
L 3476922 Santo Antônio

look this http://201.86.7.131/geonames/lista.php

look this

http://201.86.7.131/geonames/lista.php

We did not invent these names. It is normal that villages have the same name in different areas and regions.
Brazil is large, it could make sense for you to also include ADM2 in the hierarchy.

Marc

marc wrote:

We did not invent these names. It is normal that villages have the same name in different areas and regions.
Brazil is large, it could make sense for you to also include ADM2 in the hierarchy.

Hi Mark,

You're right on large countries having multiple cities with the same name, but it is not the case here. The cities I listed are within the same state and if you notice the geonameid , they are pretty much sequencial.

Just to make sure, I did some tests with France, which is much smaller than Brazil. I found repeated entries as well. For instance:

L PPL 3033366 Bergouey ( population: 0 - alternatenames: 40250)
L PPL 3033367 Bergouey ( population: 120 - alternatenames: Bergouey,Burgue)

Note that their geonameid is sequencial and one of them has a popúlation of zero and a strange alternate name...

Do you think there might be a problem with the database?

The problem about using ADM2 is that different countries have different ADM levels. In our project we only need a second level hierarchy and we list all the cities right in. No need for extensive subdivisions.

I really appreciate your comments and help on this.

Nei

Hi Nei

The sequential number has todo with the way we loaded the data the first time and assigned the geonameId.

The places Bergouey in France do exist and the 'strange' alternate name is Spanish since the second village is at the Spanish border where places may have two different names in Spanish and French.

You will find places with the same name even in tiny Switzerland

Marc