GeoNames Forum

It seems that the allCountries.txt file probably has a few lines at the top which get in the way. As the file is over 700mb big I cannot seem to find a powerful enough editor to modify it. I tried the copy with a country file in which I removed the first few lines (including the columns) which worked well. But I hope there is a better way than importing them one by one

I added a spatial field as well and was able to fill the geometry with the coordinates from the latitude longitude field. The country dataset loads up fine in QGIS, although the geonameid does seem to have become 0 (it has a value when I look at it through pg3admin?!). Generating the primary and foreign keys seems to cause some difficulties...but slowly moving ahead.

BTW, does anyone know of a (semi) automated way of updating the database?!

Thanks!

Mark

Hi there,

I am trying to fill an empty pgsql database based on the instructions here. I basically want to create a database which I can use to match populated places with in order to geocode them.
I am getting an error when trying to copy the countryInfo.txt file. It complains about the column "geonamei" of relation "countryinfo" not existing. The column is there though is empty.
Can someone point me in the right direction?! I am quite new to postgresql/postgis but eager to get fully acquainted.
Is there a sql dump of a full database by any chance?! That would make things quite easy.

Thanks ahead for any help.

cheers,
Mark de Blois