Using geonames service locally

Question

I was planning to use geonames API but actually it seems far more sensible to use the geonames locally and not use their web API. So my question is, does anyone know how to interface with the geonames data locally?

Do I need to manually import it into a database and then reference it like a normal DB?

Answer 1

Yes you will have to import the database manually if you want to query the database locally.

1 - If you plan to use MySQL you can follow the explanations from this post Importing data from geonames.org database into MySQL DB

2 - If the table structure is not up to date you can also refer to the GeoNames forum: http://forum.geonames.org/gforum/posts/list/732.page

3 - Once you have created your tables following the given structure you can use LOAD DATA INFILE or LOAD DATA LOCAL INFILE to bulk import the data from the CSV files.

4 - The importation of the allcountries table can take more than 10 minutes locally. It might be better to create your indexes before you import the data.

(A shell Script is also available if you are familiar with the command)