Countries & cities database files

[blumash]

I m looking for those 2 files in order to put them in a program as a pupup for the enduser to chose ountry & city , maybe someone can help me get those files if exsist at all.

Thank's

 

[alvechurchdata]

Surely you want a single file with "City" and "Country" fields. Otherwise you'll get users selecting the wrong country for the city they've picked.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[blumash]

Thank's alvechurchdata , u r rigth , I should have a files with all countries & cities in each country , my question is where can I find a file like this???

 

[TheRambler]

Hi,

You may want to review thread669-968989 world's countries and cities!, and tell us what you find...

 

[blumash]

Thank's TheRambler , I looked up this Thread , didn't find anything there anything that could help me......

 

[TheRambler]

I followed the link provided by Dimandja and found this download.

I created a table with the structure described in that page and appended records with:

APPEND FROM dataen.txt DELIMITED WITH TAB

I got a table with 100,167 cities and their parent countries.

 

[blumash]

Thank's The Rembler , I downloaded the file , what is the starcture of the DBF file u created ???

Thank's again

 

[TheRambler]

You are welcome. Before importing the file dataen.txt you may want to convert it from UTF-8 format to DOS format, I have used UltraEdit to do so.

The table structure I have used is this:

CREATE DBF CITY (cname c(60), popul n(10), gtype c(25), iname c(40), country c(40), addiv c(40), lat n(7,2), lng n(7,2))

 

[blumash]

Thank u very much TheRembler I have the table now , the only problem is that names of cities that have special unicode caracthers the caracther is looking different, for example a letter that should be " é " looks like " ? " , I m using win XP Pro English Version, do u think there is a solutaion for that ???

Thank u very much again

 

[TheRambler]

UltraEdit program mentioned above has an option to convert from UTF-8 to ASCII, but the resulting file is not properly captured by FPD. A workaround is to capture it from VFP and export it with:

COPY TO ... TYPE FOX2X

The result looks much better. If you need a complete FPD solution, I can't help you with that, sorry.