| Author |
Message |
![[Post New]](/gforum/templates/default/images/icon_minipost_new.gif) 19/02/2009 22:48:14
|
AFKYBD
Joined: 19/02/2009 02:10:03
Messages: 6
Offline
|
I ran the following query on the GeoNames table and got 3616 results, meaning that all the data in the geonames table is duplicated for 3616 unique items with feature_code PPL, and up to 4 duplicates. I'm wondering what the purpose of having these duplication is. I've tried reading documentation but have not found anything. Can you let me know why?
SELECT name, asciiname, alternatenames, latitude, longitude, feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, admin3_code, admin4_code,
population, elevation, gtopo30, timezone, COUNT(name) AS Expr1
FROM GeoNames
WHERE (feature_code = 'PPL')
GROUP BY name, asciiname, alternatenames, latitude, longitude, feature_class, feature_code, country_code, cc2, admin1_code, admin2_code, admin3_code, admin4_code,
population, elevation, gtopo30, timezone
HAVING (COUNT(name) > 1)
|
|
|
 |
30/03/2009 06:54:56
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
You are right there are duplicates. I will delete them.
Marc
|
 |
|
|
|
13/04/2009 19:22:33
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
The duplicates have been deleted.
Marc
|
|
|
|
|
15/04/2009 03:09:41
|
razz
Joined: 15/04/2009 02:21:14
Messages: 3
Offline
|
I have found some duplication that I do not understand (using allCountries.txt from 14042009)
There are a lot of cities that have multiple P - PPL entries. For example, there are 24 entries for Midway, TX. Only one of them (the row that includes population data) has what I think is the correct admin2 /county (313 - Madison).
There are many examples of duplication like this in the US and other countries (many times it occurs with consecutive geonameid numbers). My goal is to extract a unique list of cities.
Can someone please explain why this duplication occurs and what it means?
Thanks very much.
The geonameid numbers for the 24 Midway, TX P-PPL entries:
4046402,4711160,4711161,4711162,4711163,4711164,4711165,4711166,4711167,4711168,4711169,4711170,4711171,4711172,4711173,4711174,
4711175,4711176,4711177,5526357,5526358,5526359,5526360,5526361
|
|
|
|
15/04/2009 06:10:41
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
What makes you think they are duplicates? They have completely different lat/lng.
Best
Marc
|
|
|
|
|
15/04/2009 06:53:39
|
razz
Joined: 15/04/2009 02:21:14
Messages: 3
Offline
|
This is exactly the issue I think. I would contend that there is only 1 "Midway, Texas". I believe the 'real' one is the one in Madison County (admin2 = 313) id: 4711171
http://en.wikipedia.org/wiki/Midway,_Texas
There are very, very few examples of states in the US with city names appearing legitimately in two different places in the same state. (This duplication is not limited to the US though - it's just easiest for me to check these since I have multiple sources...)
Let's take one example: geonameid 4711175 Midway, TX in the county of Titus (449). I can find no record of any place called Midway existing in this location.
Some of the lat / lon differences of the entries for Midway, TX are more than 400KM apart. I think there is only 1 Midway, TX in the US. I think the 2000 census reported 288 people living there and I think that the 'real' and 'only' Midway, TX is near coordinates: 31.023176, -95.751081.
So, this might be the part that I don't understand. Are entries like 4711175 historical and no longer exist or is there some other explanation?
I hope this helps. Thank s very much for your help.
|
|
|
|
15/04/2009 07:47:41
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
razz wrote:
I would contend that there is only 1 "Midway, Texas". I believe the 'real' one is the ...
I don't think the people living in the other locations called Midway, Texas agree with this. All these entries are from an official US source (USGS) and there is so far no evidence that these locations do not exist. Even when I click on the gmaps mashup then I see a label 'Midway' at many of these locations.
If you are only interested in large cities, then you can take only those places with a population > x, or if you only care about places with their own zip code then use the postal code dump.
Best
Marc
|
|
|
|
15/04/2009 16:35:49
|
razz
Joined: 15/04/2009 02:21:14
Messages: 3
Offline
|
Thanks Marc. I looked at a couple of the examples from Texas. I see the labels for places called "Midway" on sources like Google Maps. In one case for example there was a road near there called "Midway Rd".
In the example that I used before in Titus county, I think if you go to the coordinates 33.2673, -94.945 and ask the first 10 people you can find "where do you live?" My guess is that their answer would be "Mt. Pleasant, Texas" rather than Midway.
However, I don't really care. You answered my question. The USGS data is way more detailed than I am interested in. I want a unique list of cities for several countries and using pop and/or postal code data seems like the way to do that.
Thanks for your very quick replies.
|
|
|
|
11/04/2010 11:55:41
|
matzipan
Joined: 11/04/2010 11:29:07
Messages: 1
Offline
|
Indeed there are lots of duplication, includin similar phonetic names, in georgraphic neighbourhood, like Quchi and Qochi, Ab-e Barik and Ab-e Barik-e Qowdi `Alam Kheyl and Alam Kheyl, `Ala' od Din and `Ala od Din, `Ali Za`i and `Aliza'i
Other duplicates: Qaryeh-ye Farari, Damaki
By the way what's with things like Jalaier (1), Jalaier (2), all the way to ( , Aqsay `Arab Three, Aqsay `Arab Two
These are only just a few of them.
|
|
|
|
01/09/2010 01:10:19
|
whyme953
Joined: 13/08/2010 22:53:09
Messages: 3
Offline
|
I don't know, it seems to me that there are many duplicates. (the info is not exactly the same but they seem to be referring to the same city)
The following is what I came across in the first 125 or so records returned from a join with NY Zip codes:
Code:
7257916 Accord Accord 41.79714 -74.23195 P PPL US NY 111 0 102 91 America/New_York 2010-02-07
5106719 Accord Accord 41.78565 -74.22904 P PPL US NY 111 632 77 73 America/New_York 2006-01-17
5106738 Adams Center Adams Center 43.86006 -76.00548 P PPL US NY 045 1413 195 188 America/New_York 2006-01-17
7257917 Adams Center Adams Center 43.86162 -76.0001 P PPL US NY 045 0 198 188 America/New_York 2010-02-07
5107082 Altona Altona 44.88837 -73.6557 P PPL US NY 019 1073 194 190 America/New_York 2006-01-17
7257928 Altona Altona 44.8901 -73.65956 P PPL US NY 019 0 198 201 America/New_York 2010-02-07
5107257 Apalachin Apalachin 42.06952 -76.15465 P PPL US NY 107 1081 257 254 America/New_York 2006-01-17
7257940 Apalachin Apalachin 42.0712 -76.16275 P PPL US NY 107 0 322 305 America/New_York 2010-02-07
5107273 Aquebogue Aquebogue 40.94454 -72.62704 P PPL US NY 103 2333 11 9 America/New_York 2010-02-16
7257941 Aquebogue Aquebogue 40.9405 -72.6133 P PPL US NY 103 0 6 1 America/New_York 2010-02-07
it seems one record is the center of town and one is a random spot outside of town.
|
|
|
|
05/09/2010 08:25:37
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
whyme953, you are right those are duplicates. it will need some cleanup process to find and eliminate them.
Marc
|
|
|
|
|
29/10/2011 14:13:57
|
HermesTrismegistus
Joined: 13/10/2011 14:06:50
Messages: 3
Offline
|
Marc, could you tell me how i could remove duplicate entry's myself? Or could you tell me what query's you use, to do this?
|
|
|
|
30/10/2011 18:36:26
|
marc
Joined: 08/12/2005 07:39:47
Messages: 4501
Offline
|
I think those duplicates have already been removed.
Marc
|
|
|
|
|
03/09/2025 07:41:33
|
amerun
Joined: 16/08/2025 11:56:40
Messages: 1
Offline
|
Hi,
here is a list of French places which I suspect are duplicates.
I am not sure this will be very easy to read so I have also attached a log file containing the same list.
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
11646 2978773 Saint-Léopardin-d'Augy Saint-Leopardin-d'Augy Augy,Saint-Leopardin,Saint-Leopardin-d'Augy,Saint-Léopardin,Saint-Léopardin-d'Augy,Vivier 46.68301 3.10389 PPL FR 84 03 032 03241 0.0
11647 2978774 Saint-Léopardin Saint-Leopardin Saint-Leopardin,Saint-Leopardin-d'Augy,Saint-Léopardin,Saint-Léopardin-d'Augy 46.69178 3.13814 PPL FR 84 03 032 03241 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
66939 3034273 Beaulieu Beaulieu Beaulieu,Union-Bel-Air 44.36086 4.23370 PPL FR 84 07 071 07028 421.0
143825 11811452 Beaulieu Beaulieu 44.38298 4.24356 PPL FR 84 07 071 07028 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
64175 3031496 Bozas Bozas Bosas,Bozas 45.0551 4.65091 PPL FR 84 07 073 07039 0.0
115857 6620022 Bozas Bozas 45.0549 4.65110 PPL FR 84 07 073 07039 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
37566 3004783 Le Chambon Le Chambon Chambon 44.83710 4.30640 PPL FR 84 07 073 07049 0.0
37567 3004784 Le Chambon Le Chambon 44.86667 4.28333 PPLA4 FR 84 07 073 07049 55.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
42337 3009565 Lafarre Lafarre Lafarre 45.08333 4.35000 PPL FR 84 07 073 07124 59.0
173315 13445756 Lafarre Lafarre Lafarre 45.07937 4.50942 PPL FR 84 07 073 07124 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
50979 3018251 Flize Flize Fliz,Flize,fu li ci,Флиз,Фліз,弗利兹 49.69875 4.77171 PPL FR 44 08 081 08173 1272.0
53031 3020311 Élan Elan AElg,Alce,Alces alces,Alko,Briedis,Elan,Eland,Elg,Flize,Hirvi,Los evropsky,Los evropský,Los',Oringna,Orîngna,herajika,Älg,Élan,Лось,אייל קורא,ヘラジカ 49.66256 4.75731 PPL FR 44 08 081 08173 76.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
40232 3007456 La Palme La Palme La Palme,Lapalme 42.97516 2.99237 PPL FR 76 11 113 11188 0.0
109913 6545038 La Palme La Palme 42.97518 2.99243 PPL FR 76 11 113 11188 1517.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
23432 2990596 Neussargues Neussargues Neussargues,Neussargues-Moissac 45.12826 2.97627 PPL FR 84 15 153 15141 1049.0
168255 12501317 Neussargues-Moissac Neussargues-Moissac 45.13406 2.98122 PPL FR 84 15 153 15141 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
19241 2986390 Arnac-Pompadour Arnac-Pompadour Arnac,Arnac-Pompadour,Pompadour 45.39635 1.38103 PPL FR 75 19 191 19011 0.0
69529 3036878 Arnac-Pompadour Arnac-Pompadour Arnac,Arnac e Pompador,Arnac-Pompadour,Arnac-la-Prairie,Arnak Pompadur,Arnak-Pompadur,a er na ke peng pa du,arunakku=ponpadouru,Арнак Помпадур,Арнак-Помпадур,アルナック＝ポンパドゥール,阿尔纳克蓬帕杜 45.40975 1.36993 PPL FR 75 19 191 19011 1273.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
21560 2988717 Palisse-Haut Palisse-Haut Palisse,Palisse-Haut 45.43333 2.20000 PPL FR 75 19 193 19157 0.0
21562 2988719 Palisse Palisse Palisse 45.41881 2.20601 PPL FR 75 19 193 19157 231.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
11922 2979050 Saint-Julien-Maumont Saint-Julien-Maumont Saint-Julien-Maumont 45.03333 1.78333 PPL FR 75 19 191 19217 164.0
173307 13445563 Saint-Julien-Maumont Saint-Julien-Maumont Saint-Julien-Maumont 45.03793 1.70580 PPL FR 75 19 191 19217 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
19172 2986321 Pont Pont Pont 47.17634 5.31581 PPL FR 27 21 212 21495 93.0
19173 2986322 Pont Pont 47.17720 5.31670 PPL FR 27 21 212 21495 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
20958 2988114 Penguily Penguily Penguily 48.04372 -2.50086 PPL FR 53 22 224 22165 436.0
20959 2988115 Penguily Penguily Pengilli,Penguilly,Penguily 48.37305 -2.49537 PPL FR 53 22 224 22165 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
67802 3035141 Banize Banize Banhesa,Banisa,Baniz,Banize,ba ni ci,Баниз,Баніз,巴尼兹 45.93131 1.99754 PPL FR 75 23 232 23016 0.0
67803 3035142 Banize Banize 45.87479 2.06168 PPLA4 FR 75 23 232 23016 164.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
54964 3022252 Croze Croze Croze 46.20618 1.91919 PPL FR 75 23 231 23071 212.0
149191 12306305 Croze Croze Croze 45.81975 2.16938 PPL FR 75 23 231 23071 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
3814 2970912 Vallière Valliere Valliere,Vallieres,Vallière,Vallières 45.90637 2.03472 PPL FR 75 23 231 23257 0.0
3817 2970915 Vallière Valliere Valliere,Vallière 46.26275 2.44495 PPL FR 75 23 231 23257 782.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
63858 3031179 Boulazac Boulazac Bolasac,Boulazac,Bulazak,bu la zha ke,Булазак,布拉扎克 45.17166 0.77305 PPL FR 75 24 243 24053 0.0
63859 3031180 Boulazac Boulazac 45.11667 0.75000 PPLA4 FR 75 24 243 24053 6680.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
63580 3030901 Bourniquel Bourniquel Borniquel,Borniquèl,Bourniquel,Burnikel,Burnikel',bu er ni qu ai,Бурникел,Бурникель,Бурнікель,布尔尼屈埃 44.80000 0.85000 PPL FR 75 24 241 24060 63.0
173374 13447640 Bourniquel Bourniquel Bourniquel 44.80916 0.77488 PPL FR 75 24 241 24060 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
55477 3022766 Le Coux Le Coux Coux-et-Bigaroque,Ku-e-Bigarok,Kuks et Bigarok,Le Coux,Lo Cos e Bigaroca,Lo Cos e Bigaròca,ku he bi jia luo qu ai,Ку-е-Бигарок,Ку-е-Бігарок,Кукс ет Бигарок,库和比加罗屈埃 44.83387 0.97287 PPL FR 75 24 244 24142 865.0
169503 12535143 Coux-et-Bigaroque Coux-et-Bigaroque 44.83511 0.97185 PPL FR 75 24 244 24142 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
49583 3016844 Gageac-et-Rouillac Gageac-et-Rouillac Gageac,Gageac-et-Rouillac 44.80000 0.78333 PPL FR 75 24 241 24193 461.0
173373 13447639 Gageac-et-Rouillac Gageac-et-Rouillac Gageac-et-Rouillac 44.79942 0.34446 PPL FR 75 24 241 24193 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
15131 2982265 Rudeau-Ladosse Rudeau-Ladosse Ladosse,Rjudo-Lados,Rjudo-Ladoss,Rudeau-Ladosse,Rudeu e Ladaussa,lu duo la duo si,Рюдо-Ладос,Рюдо-Ладосс,吕多拉多斯 45.48609 0.50471 PPL FR 75 24 242 24221 164.0
15133 2982267 Rudeau-Ladosse Rudeau-Ladosse Rudaud,Rudeau,Rudeau-Ladosse 45.48058 0.55031 PPL FR 75 24 242 24221 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
11260 2978387 Saint-Martin-de-Gurson Saint-Martin-de-Gurson Saint-Martin,Saint-Martin-de-Gurcon,Saint-Martin-de-Gurson,Saint-Martin-de-Gurçon 44.95230 0.10680 PPL FR 75 24 241 24454 0.0
112896 6615524 Saint-Martin-de-Gurson Saint-Martin-de-Gurson Sen-Marten-de-Gjurson,Sent Martin de Gurcon,Sent Martin de Gurçon,sheng ma dan de ju er song,Сен-Мартен-де-Гюрсон,سینٹ-مارٹن-دے-گرسوں,圣马丹德居尔松 44.95333 0.10778 PPL FR 75 24 241 24454 555.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
32029 2999235 Temple-Laguyon Temple-Laguyon Le Temple,Le Temple-Laguyon,Temple-Laguyon 45.2335 1.09933 PPL FR 75 24 244 24546 46.0
115887 6620053 Temple-Laguyon Temple-Laguyon 45.2340 1.10060 PPL FR 75 24 244 24546 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
3761 2970859 Valojoulx Valojoulx Valojoulx 45.11667 1.15000 PPL FR 75 24 244 24563 242.0
173372 13447638 Valojoulx Valojoulx Valojoulx 45.01857 1.14302 PPL FR 75 24 244 24563 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
59344 3026651 Charens Charens Charens,Haut Charens 44.5384 5.51056 PPL FR 84 26 261 26076 35.0
67420 3034755 Bas Charens Bas Charens Bas Charens,Charens 44.5403 5.50903 PPL FR 84 26 261 26076 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
58447 3025752 Chavannes Chavannes Chavannes 45.08333 4.850 PPL FR 84 26 263 26092 426.0
173318 13446134 Chavannes Chavannes Chavannes 45.10569 4.928 PPL FR 84 26 263 26092 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
68039 3035380 Baigneaux Baigneaux Baigneaux 48.18409 1.60872 PPL FR 24 28 282 28019 0.0
68040 3035381 Baigneaux Baigneaux 48.13333 1.81667 PPLA4 FR 24 28 282 28019 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
27567 2994750 Meilars Meilars Meilars,Meillars 48.04431 -4.42813 PPL FR 53 29 294 29145 0.0
56619 3023915 Confort-Meilars Confort-Meilars Konfor-Mejar,Konforzh-Meilar,Koñforzh-Meilar,Meilars,konforu=meraru,kong fu er mei la er,Конфор-Меяр,コンフォール＝メラール,孔福尔梅拉尔 48.05000 -4.43333 PPL FR 53 29 294 29145 754.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
40749 3007974 Lampaul Lampaul Enez Eusa,OUI,Ouessant,Uehssan,Ushant,Уэссан 48.45761 -5.09615 PPL FR 53 29 291 29155 0.0
115915 6620083 Ouessant Ouessant 48.45969 -5.08615 PPL FR 53 29 291 29155 883.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
15069 2982203 Plonévez-Porzay Plonevez-Porzay Ploneve-Porze,Plonevez-Porzhe,pu luo nei wei bo er ze,puronevue=poruze,Плоневе-Порзе,プロネヴェ＝ポルゼ,普洛内韦波尔泽 48.12425 -4.21873 PPL FR 53 29 292 29176 0.0
19557 2986706 Plonévez-Porzay Plonevez-Porzay Ploneve-Porze,Plonevez-Porsay,Plonevez-Porzay,Plonevez-Porzhe,Plonévez-Porsay,Plonévez-Porzay,pu luo nei wei bo er ze,puronevue=poruze,Плоневе-Порзе,プロネヴェ＝ポルゼ,普洛内韦波尔泽 48.12538 -4.22023 PPL FR 53 29 292 29176 1687.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
5415 2972527 Figari Figari Figari,Tivanello,Tivarello 41.48792 9.13013 PPL FR 94 2A 2A4 2A114 1438.0
116039 6620210 Figari Figari FSC,Figari (Korsika) 41.48820 9.12950 PPL FR 94 2A 2A4 2A114 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
61148 3028459 Casevecchie Casevecchie Casevecchie,Casevocchie 42.14292 9.3617 PPL FR 94 2B 2B3 2B075 0.0
61149 3028460 Casevecchie Casevecchie Casevechje,Kazevekije,Kazevekk'e,Kazevekke,Казевекије,Казевеккье,Казевеккє 42.13333 9.3500 PPLA4 FR 94 2B 2B3 2B075 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
2045 2969140 Vignale Vignale Vignale 42.53890 9.38220 PPL FR 94 2B 2B2 2B350 0.0
2046 2969141 Vignale Vignale Vignale 42.47045 9.32598 PPLA4 FR 94 2B 2B2 2B350 180.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
46345 3013596 Hédé-Bazouges Hede-Bazouges Ede,Hazhou,Hazhou-Bazeleg,Hazhoù,Hazhoù-Bazeleg,Hede-Bazouges,Hédé-Bazouges,ai dai,Еде,埃代 48.3000 -1.80000 PPL FR 53 35 354 35130 2076.0
67078 3034412 Bazouges-sous-Hédé Bazouges-sous-Hede Bazouges,Bazouges sous Hed,Bazouges sous Héd,Bazouges-sous-Hede,Bazouges-sous-Hédé 48.3129 -1.77176 PPL FR 53 35 354 35130 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
36427 3003639 Le Lys-Saint-Georges Le Lys-Saint-Georges Le Lys,Le Lys-Saint-Georges,Lys-Saint-Georges,Lys-le-Peletier 46.64323 1.82304 PPL FR 24 36 363 36108 218.0
115929 6620098 Lys-Saint-Georges Lys-Saint-Georges 46.64160 1.82420 PPL FR 24 36 363 36108 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
62891 3030211 Bueil-en-Touraine Bueil-en-Touraine Bueil,Bueil-en-Touraine 47.64508 0.5510 PPL FR 24 37 371 37041 0.0
115930 6620099 Bueil-en-Touraine Bueil-en-Touraine 47.64510 0.5507 PPL FR 24 37 371 37041 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
63639 3030960 Bourgoin Bourgoin Bourgoin,Bourgoin-Jallieu,Jallieu 45.59889 5.27236 PPLX FR 84 38 382 38053 0.0
112905 6615539 Bourgoin-Jallieu Bourgoin-Jallieu Bourgoin-Jallieu,Burgoan Zhalije,Burguen-Zhal'e,Burguin-Zhall'jo,bu er guan ya li e,buleugoangjallioe,burugowan=jaiyu,bwrghwan-jalyw,bwrgwan zhlyw,bwrgwan-zhlyw,Бургоан Жалије,Бургуен-Жальє,Бургуин-Жалльё,بورغوان-جاليو,بورگوآن ژلیو,بورگوآن-ژلیو,ブルゴワン＝ジャイユー,布尔关雅利厄,부르고앙잘리외 45.58611 5.27361 PPLA4 FR 84 38 382 38053 23517.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
23588 2990754 Nerpol-et-Serres Nerpol-et-Serres Nerpol-et-Serres,Serre-Nerpol,Serres-Nerpol 45.26447 5.37914 PPL FR 84 38 381 38275 0.0
115933 6620102 Serre-Nerpol Serre-Nerpol 45.25830 5.37560 PPL FR 84 38 381 38275 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
14324 2981456 Saint-Barthélemy Saint-Barthelemy Saint-Barthelemy,Saint-Barthelemy-de-Beaurepaire,Saint-Barthélemy,Saint-Barthélemy-de-Beaurepaire 45.34449 5.06961 PPL FR 84 38 383 38363 0.0
14336 2981468 Saint-Barthélemy Saint-Barthelemy Saint-Barthelemy,Saint-Barthélemy 44.99975 5.62941 PPL FR 84 38 383 38363 875.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
8434 2975556 Savigneux Savigneux Savigneux 45.61670 4.08330 PPL FR 84 42 421 42299 2623.0
8435 2975557 Savigneux Savigneux Savigneux 45.60119 4.40895 PPL FR 84 42 421 42299 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
61410 3028723 Capdenac Capdenac Capdenac,Capdenac-le-Haut,Capendac,Capendac-Village 44.58126 2.06992 PPL FR 76 46 462 46055 1112.0
61425 3028738 Capdenac Capdenac Capdenac-le-Haut,Kadnak,Kapdenak,ka pu de na ke,Каднак,Капденак,卡普德纳克 44.58333 2.06667 PPL FR 76 46 462 46055 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
52564 3019840 Escamps Escamps Escamps 44.40000 1.58333 PPL FR 76 46 461 46091 123.0
173513 13448539 Escamps Escamps Escamps 44.36613 1.63394 PPL FR 76 46 461 46091 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
52302 3019577 Estal Estal Estal 44.91667 1.85000 PPL FR 76 46 462 46097 117.0
173510 13448533 Estal Estal Estal 44.91855 1.92092 PPL FR 76 46 462 46097 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
2320 2969416 Viazac Viazac Viazac 44.67305 1.82244 PPL FR 76 46 462 46332 0.0
2321 2969417 Viazac Viazac Viazac 44.64220 2.07580 PPL FR 76 46 462 46332 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
21184 2988341 Paulhac-en-Margeride Paulhac-en-Margeride Paulhac,Paulhac-en-Margeride 44.86667 3.38333 PPL FR 76 48 482 48110 127.0
173527 13448556 Paulhac-en-Margeride Paulhac-en-Margeride Paulhac-en-Margeride 44.94692 3.38075 PPL FR 76 48 482 48110 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
68768 3036111 Auménancourt-le-Petit Aumenancourt-le-Petit Aumenancourt,Auménancourt 49.37628 4.05962 PPL FR 44 51 513 51025 703.0
68769 3036112 Auménancourt Aumenancourt Aumenancourt-le-Grand,Auménancourt-le-Grand 49.38333 4.06667 PPL FR 44 51 513 51025 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
27360 2994541 Choloy-Ménillot Choloy-Menillot Choloy,Choloy-Menillot,Choloy-Ménillot,Menillot,Ménillot 48.66301 5.81671 PPL FR 44 54 544 54128 0.0
57748 3025050 Choloy-Ménillot Choloy-Menillot 48.66667 5.81667 PPL FR 44 54 544 54128 708.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
2135 2969230 Vieux Bourg Vieux Bourg Treal,Tréal,Vieux Bourg 47.84472 -2.20785 PPL FR 53 56 563 56253 0.0
4920 2972023 Tréal Treal La Villio-Treal,La Villio-Tréal,Treal,Tréal 47.83872 -2.22377 PPL FR 53 56 563 56253 710.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
37984 3005202 Bono Bono Ar Bonou,Ar Bonoù,Bono,Le Bono 47.6404 -2.94986 PPL FR 53 56 563 56262 1994.0
64329 3031652 Bono Bono 47.6406 -2.94940 PPL FR 53 56 563 56262 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
27178 2994359 Merlebach Merlebach Freyming-Merlebach,Merlebach 49.1498 6.81882 PPL FR 44 57 573 57240 0.0
49797 3017059 Freyming-Merlebach Freyming-Merlebach Freyming,Merlebach 49.1500 6.78333 PPL FR 44 57 573 57240 14507.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
46450 3013701 Yutz Yutz Jeutz,Jjus,Juc,Yutz Haute,yi yu te,ywts,Йюс,Юц,یوتس,یوٹز,伊于特 49.35571 6.1926 PPL FR 44 57 577 57757 15659.0
67338 3034673 Yutz Yutz Basse-Yutz,Niederjentz,Niederjeutz,Yutz,Yutz-Basse 49.35628 6.1891 PPL FR 44 57 577 57757 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
69037 3036380 Aube-sur-Rîle Aube-sur-Rile Aube,Aube-sur-Rile,Aube-sur-Rîle 48.7392 0.55161 PPL FR 28 61 613 61008 1628.0
115981 6620150 Aube Aube Ob,Об 48.7395 0.54710 PPL FR 28 61 613 61008 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
16513 2983655 Richebourg Richebourg Richebourg-Saint-Vaast 50.58333 2.73333 PPL FR 32 62 622 62706 2407.0
16514 2983656 Richebourg-l'Avoué Richebourg-l'Avoue Richebourg,Richebourg-l'Avoue,Richebourg-l'Avoué 50.56999 2.74884 PPL FR 32 62 622 62706 2560.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
52298 3019573 Estampures Estampures Estampures 43.36667 0.20000 PPL FR 76 65 653 65170 82.0
173457 13448228 Estampures Estampures Estampures 43.37119 0.28246 PPL FR 76 65 653 65170 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
15751 2982887 Roppenheim Roppenheim 48.84167 8.05315 PPLA4 FR 44 67 672 67409 0.0
15752 2982888 Roppenheim Roppenheim 48.84325 8.05538 PPL FR 44 67 672 67409 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
24070 2991237 Muespach Muespach Moyen-Muespach,Muespach,Muespach-Moyen,Muespach-le-Bas 47.54907 7.37803 PPL FR 44 68 681 68221 0.0
24103 2991270 Muespach Muespach Moyen-Muespach,Muespach-Moyen 47.55000 7.38333 PPL FR 44 68 681 68221 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
5673 2972786 Thizy-les-Bourgs Thizy-les-Bourgs Thizy 46.02995 4.31299 PPL FR 84 69 692 69248 2718.0
168625 12514019 Thizy Thizy 46.02858 4.31395 PPL FR 84 69 692 69248 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
30211 2997405 Louplande Louplande Louplande 47.9500 -0.05000 PPL FR 52 72 721 72169 1247.0
173556 13449180 Louplande Louplande Louplande 47.9438 0.04146 PPL FR 52 72 721 72169 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
60112 3027420 Chambéry-le-Vieux Chambery-le-Vieux Chambery,Chambery-le-Vieux,Chambéry,Chambéry-le-Vieux 45.59293 5.91132 PPL FR 84 73 732 73065 0.0
60114 3027422 Chambéry Chambery CMF,Camberiacum,Chamberi,Chambery,Chambery-le-Vieux,Chamberí,Chambèri,Chambéry,Chambéry-le-Vieux,Samberi,Shamberi,Shambery,shambry,shambyry,shanberi,shang bei li,syangbeli,Šamberi,Шамбери,Шамберы,Шамбері,שאמברי,شامبری,شامبيري,شامبیری,シャンベリ,尚贝里,샹베리 45.56628 5.92079 PPLA2 FR 84 73 732 73065 61640.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
64406 3031729 Bonne Bonne Bonne,Bonne-sur-Menoge,Bonne-sur-Ménoge 46.17207 6.32443 PPL FR 84 74 743 74040 2481.0
116005 6620176 Bonne Bonne 46.16820 6.32150 PPL FR 84 74 743 74040 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
1867 2968962 Villard Villard Villard,Villard-les-Crozats,Villard-sur-Boege,Villard-sur-Boëge 46.21764 6.44025 PPL FR 84 74 744 74301 0.0
1902 2968997 Villard Villard Villar,Villard 45.76673 6.25015 PPL FR 84 74 744 74301 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
43721 3010956 La Borde La Borde Chatillon-la-Borde,Châtillon-la-Borde,La Borde 48.53084 2.83491 PPL FR 11 77 772 77103 0.0
58762 3026068 Châtillon-la-Borde Chatillon-la-Borde Chatillon,Chatillon-la-Borde,Châtillon,Châtillon-la-Borde 48.54263 2.80893 PPL FR 11 77 772 77103 222.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
37962 3005180 Le Bosquel Le Bosquel Bosquel,Le Bosquel 49.73932 2.21774 PPL FR 32 80 802 80114 290.0
116012 6620183 Bosquel Bosquel 49.73940 2.21840 PPL FR 32 80 802 80114 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
69235 3036579 Aslonnes Aslonnes Alon,Aslonn,Aslonnes,a si luo na,Алон,Аслонн,阿斯洛纳 46.40000 0.33333 PPL FR 75 86 863 86010 931.0
173355 13447185 Aslonnes Aslonnes Aslonnes 46.44376 0.33559 PPL FR 75 86 863 86010 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
62047 3029365 Buxerolles Buxerolles Buxerolles 46.61667 0.48333 PPL FR 75 86 863 86041 9415.0
173354 13447184 Buxerolles Buxerolles Buxerolles 46.59807 0.34933 PPL FR 75 86 863 86041 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
52062 3019336 Étueffont Etueffont Etueffont,Etueffont-Bas,Etueffont-Haut,Étueffont,Étueffont-Bas,Étueffont-Haut 47.71992 6.92162 PPL FR 27 90 901 90041 0.0
52063 3019337 Étueffont Etueffont Etijefon,Etjueffon,Etueffont,ai di ai feng,Етијефон,Етюеффон,埃蒂埃丰 47.71667 6.91667 PPL FR 27 90 901 90041 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
19 3578275 Village Village Bouillante,Bouillante-Village,Village 16.13012 -61.76864 PPL GP GP 971 9711 97106 0.0
1226 3579642 Bouillante Bouillante Bouillante,Bujant,bwyant,Буянт,بويانت 16.13043 -61.76895 PPL GP GP 971 9711 97106 7540.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
112 3569886 Schoelcher Schoelcher Burg de Case Navire,Case Navire,La case des Navires,Schoelcher,Schœlcher 14.61774 -61.0990 PPLA4 MQ MQ 972 9721 97229 0.0
1149 3570929 Schœlcher Schoelcher Case Navire 14.61867 -61.0966 PPL MQ MQ 972 9721 97229 0.0
geonameid name asciiname alternatenames latitude longitude featurecode countrycode admin1code admin2code admin3code admin4code population
2163 3382225 Camopi Camopi 3.21147 -52.46063 PPL GF GF 973 9731 97356 0.0
2164 3382226 Camopi Camopi Camopi,Kamopi,OYC,kamwby,Камопи,Камопі,كاموبي 3.16887 -52.33525 PPL GF GF 973 9731 97356 1295.0
|
|
|
|
|
|
|
|
![[Search]](/gforum/templates/default/images/icon_mini_search.gif){kind=icon}
![[Recent Topics]](/gforum/templates/default/images/icon_mini_recentTopics.gif){kind=icon}
![[Groups]](/gforum/templates/default/images/icon_mini_groups.gif){kind=icon}
![[Register]](/gforum/templates/default/images/icon_mini_register.gif){kind=icon}
Register![[Login]](/gforum/templates/default/images/icon_mini_login.gif){kind=icon}
Login
![[Up]](/gforum/templates/default/images/icon_up.gif){kind=icon}
![[WWW]](/gforum/templates/default/images/icon_www.gif){kind=icon}