GeoNames Forum

I have found two inconsistencies in countryInfo.txt

Line 106, Row 16 list the language do, no such Iso exists, I think it should be fo (faroese), makes sense for Faroe Islands

Line 229, Row 16 lists language se and sme, both stand for swedish, its the only time two codes are given for one language, normally when there is a Iso1 code no other is given.

I just thought I let you know.

you are right, this will be fixed (se and sme stand for "Northern Sami", "sv" stands for Swedish).

Marc

my bad,
but my point was that they both stand for the same language.

Nice that they will be fixed cos they cause trouble with one of my import scripts.

Thanks

Jens has found two more errors (name of Swedish currency and a column shift for United States Minor Outlying Islands).
All these fixes will be available with the next dump.

Cheers

Marc

hi Marc

I can't see the changes and neither those : http://forum.geonames.org/gforum/posts/list/910.page. are those errors already fixed ?

Thanks in advance
David

You are right, it was not properly deployed.

Marc

First the countryInfo table has changed.

in PostgreSQL I do the following:
Code:

 CREATE TABLE countryinfo (
 	iso_alpha2 char(2),
 	iso_alpha3 char(3),
 	iso_numeric integer,
 	fips_code character varying(3),
 	name character varying(200),
 	capital character varying(200),
 	areainsqkm double precision,
 	population integer,
 	continent char(2),
 	tld character varying(200),
 	currency char(3),
 	curranceName char(10),
 	phone char(10),
 	postal char(60),
 	postalRegex char(250),
 	languages char(130),
 	equivalentFipsCode integer,
 	neighbours char(50)
 );

Code:

 grep -v '^#' countryInfo.txt |sed 's/\t$//g'| tail -n +2 > countryInfo.txt.tmp;

...before populating the countryinfo table in psql ...
Code:

 copy countryinfo (iso_alpha2,iso_alpha3,iso_numeric,fips_code,name,capital,areaInSqKm,population,continent,tld,currency,curranceName,phone,postal,postalRegex,languages,equivalentFipsCode,neighbours) from '${WORKPATH}/${TMPPATH}/countryInfo.txt.tmp' null as '';

grep removes all comments
sed removes the tab at the end of each line
and tail removes the column names

see also my importing script here (that will be updates shortly

):
http://forum.geonames.org/gforum/posts/list/926.page

Cheers,
Bastiaan