Latest posts for the topic "Errors in countryInfo.txt"

Errors in countryInfo.txt

broesch — GMT

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.

Re:Errors in countryInfo.txt

marc — GMT

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

Re:Errors in countryInfo.txt

broesch — GMT

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

Re:Errors in countryInfo.txt

marc — GMT

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

Re:Errors in countryInfo.txt

david masclet — GMT

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

Re:Errors in countryInfo.txt

marc — GMT

You are right, it was not properly deployed. Marc

Re:Errors in countryInfo.txt

bwakkie — GMT

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