sql / txt with locations world

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
giliat
Forum Commoner
Posts: 28
Joined: Sun May 20, 2007 2:00 pm

sql / txt with locations world

Post by giliat »

Hello

Im looking for sql or txt with all locations in the world :city state country

can someone help me find 1

thanks

gil
GeXus
Forum Regular
Posts: 631
Joined: Sat Mar 11, 2006 8:59 am

Post by GeXus »

User avatar
Kieran Huggins
DevNet Master
Posts: 3635
Joined: Wed Dec 06, 2006 4:14 pm
Location: Toronto, Canada
Contact:

Post by Kieran Huggins »

Careful: worldwide addresses aren't all as simple as that.

I recommend taking free-form user input and running it through a parsing engine like the Google Maps API.
User avatar
aaronhall
DevNet Resident
Posts: 1040
Joined: Tue Aug 13, 2002 5:10 pm
Location: Back in Phoenix, missing the microbrews
Contact:

Post by aaronhall »

Kieran Huggins wrote:Careful: worldwide addresses aren't all as simple as that.

I recommend taking free-form user input and running it through a parsing engine like the Google Maps API.
Except for China, England and a couple others (unless that changed recently (and yes, I did get burned (and yes, it <span style='color:blue' title='I'm naughty, are you naughty?'>smurf</span> me off (a lot))))
Post Reply