GeoNames Home | Postal Codes | Download / Webservice | About 

GeoNames Forum
  [Search] Search   [Recent Topics] Recent Topics   [Groups] Back to home page 
[Register] Register / 
[Login] Login 
Extracting Province/State information for the cities15000.zip  XML
Forum Index -> Administrative Divisions
Author Message
davida5



Joined: 02/05/2014 13:52:14
Messages: 1
Offline

Hi guys,

This may sound very basic, but I'm trying to find a way to add Province/State information to US/Canadian/Australian cities and can't figure out an easy way to do so.

For example: I'd like to add ON to the record that has Toronto, Canada. or add CA to Los Angeles, US

Any pointers?

Thank you,

David
srebu



Joined: 13/09/2022 23:44:56
Messages: 3
Location: Switzerland
Offline

Hi,

I realize you may have found a solution by now, but I was facing the same issue and wrote a simple query to get exactly what you asked for.

Code:
SELECT
 	*
 FROM
     geoname g
 JOIN
 	cities15000
 USING (geonameid)


Hope it helps!
 
Forum Index -> Administrative Divisions
Go to:   
Powered by JForum 2.1.5 © JForum Team