GeoNames Forum

Importing data into MySQL.
We are only interested in a subset of the information in countryInfo.txt with the alternate names for countries.

Either we can follow the information in this forum post: http://forum.geonames.org/gforum/posts/list/732.page and just modify the LOAD DATA INFILE statements to include only the columns we need into our Country table. Then load the full alternateNames file into the table and later delete the rows which doesn't have a corresponding geonamesid in the Country table.

Is there any plans from the geonames crew to dump a file with alternate names only for countries? Or is there a way to strip out all the entries from alternateNames.txt that don't belong to a country?

We can of course easily create a small program to parse the files exactly as we want, but that might be a waste of time.

It is not planned to add additional convenience file as we consider it counter productive. Finding the right file would become more are more difficult if we have thousands of files with some subsets.

Best

Marc