GeoNames Home
|
Postal Codes
|
Download / Webservice
|
About
GeoNames Forum
Search
Recent Topics
Back to home page
Register
/
Login
How to get cityname with region name
Forum Index
->
General
Author
Message
08/05/2019 17:10:38
Subject:
How to get cityname with region name
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
09/05/2019 22:28:28
Subject:
Re:How to get cityname with region name
marc
Joined: 08/12/2005 07:39:47
Messages: 4416
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
10/05/2019 09:57:10
Subject:
Re:How to get cityname with region name
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:
Select a forum
Forum in English
-------------
General
Administrative Divisions
FAQ - frequently asked questions
Postal Codes
Discussion of GeoNames Toponyms
Forum in other language
-------------
Forum in Deutsch
Powered by
JForum 2.1.5
©
JForum Team
info@geonames.org
GeoNames Home
Postal Codes
Download / Webservice
Forum
About