Only real cities

lolka_bolka — GMT

Hi! I am sure, there are question like this, I just not found it. I'd like to create a table with only Capitols, cities and villages. I tried this: Code:

INSERT INTO cities (`name`, `asciiname`, `alternateNames`, `lat`, `lng`, `country`, `elevation`, `timezone`) SELECT `name`, `asciiname`, `alternatenames`, `latitude`, `longitude`, `country`, `elevation`, `timezone`  FROM `geoname` AND `fcode` = 'PPL'

The problem is, for Hungary it gives me back 9000+ records, while this country has about 3200+ cities, villages. I've tried PPLS but for that there are no entrie for Hungary. How can I get this list for all countries?

Latest posts for the topic "Only real cities"

Only real cities