GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
How to get cityname with region name  XML
Forum Index -> General
Author Message
pascal1324



Joined: 08/05/2019 16:55:02
Messages: 2
Offline

Hello to all !
Thanks a lot for all cities databases.
I just have one difficulties....
I want to get the same as this link : http://www.geonames.org/CM/largest-cities-in-cameroon.html

It's the cities in Cameroon but i want the same for other country...

So i need the city name with the region name : Here some example :
Montréal, Québec
Paris, Ile-de-France,
Los Angeles, California...

so : city name, region name.

Is it possible to get that ? I can't figure how to do this !!!

Thanks a lot, and have a great day !

Pascal
marc



Joined: 08/12/2005 07:39:47
Messages: 4154
Offline

the admin division is encoded in the admincode1 column. You need to find the feature with the same country code and admincode1 and featurecode=ADM1.
The you find the name in the desired language in the alternatenames file.

Marc

[WWW]
pascal1324



Joined: 08/05/2019 16:55:02
Messages: 2
Offline

Hello Marc !

That's perfect! I really appreciate !
Do you have an example of a query that i can use to get it ?

Have a great day !
Pascal
 
Forum Index -> General
Go to:   
Powered by JForum 2.1.5 © JForum Team