.TH v.in.geonames 1grass "" "GRASS 6.4.4" "Grass User's Manual" .SH NAME \fI\fBv.in.geonames\fR\fR - Imports geonames.org country files into a GRASS vector points map. .SH KEYWORDS vector, import, gazetteer .SH SYNOPSIS \fBv.in.geonames\fR .br \fBv.in.geonames help\fR .br \fBv.in.geonames input\fR=\fIname\fR \fBoutput\fR=\fIname\fR [\-\-\fBoverwrite\fR] [\-\-\fBverbose\fR] [\-\-\fBquiet\fR] .SS Flags: .IP "\fB\-\-overwrite\fR" 4m .br Allow output files to overwrite existing files .IP "\fB\-\-verbose\fR" 4m .br Verbose module output .IP "\fB\-\-quiet\fR" 4m .br Quiet module output .PP .SS Parameters: .IP "\fBinput\fR=\fIname\fR" 4m .br Uncompressed geonames file from (with .txt extension) .IP "\fBoutput\fR=\fIname\fR" 4m .br Name for output vector map .PP .SH DESCRIPTION \fIv.in.geonames\fR imports Geonames.org country files (Gazetteer data) into a GRASS vector points map. The country files can be downloaded from the GeoNames Data Dump Server. The script generates a vector point map. Only original files can be processed (unzip compressed file first). These Geonames files are encoded in UTF-8 which is maintained in the GRASS database. .SH NOTES The current DB connection is used to write the database table. .PP If importing into a DBF database, the original column names longer that 10 characters are shortened to 10 characters to meet the DBF column name restrictions. If this is a problem consider choosing another database driver with \fIdb.connect\fR. The main 'geoname' table has the following fields \fC .DS .br geonameid : integer id of record in geonames database .br name : name of geographical point (utf8) varchar(200) .br asciiname : name of geographical point in plain ascii characters, varchar(200) .br alternatenames : alternatenames, comma separated varchar(4000) .br latitude : latitude in decimal degrees (wgs84) .br longitude : longitude in decimal degrees (wgs84) .br feature class : see http://www.geonames.org/export/codes.html, char(1) .br feature code : see http://www.geonames.org/export/codes.html, varchar(10) .br country code : ISO-3166 2-letter country code, 2 characters .br cc2 : alternate country codes, comma separated, ISO-3166 2-letter country code, 60 characters .br admin1 code : fipscode (subject to change to iso code), isocode for the us and ch, see file admin1Codes.txt for display names of this code; varchar(20) .br admin2 code : code for the second administrative division, a county in the US, see file admin2Codes.txt; varchar(80) .br admin3 code : code for third level administrative division, varchar(20) .br admin4 code : code for fourth level administrative division, varchar(20) .br population : integer .br elevation : in meters, integer .br gtopo30 : average elevation of 30'x30' (ca 900mx900m) area in meters, integer .br timezone : the timezone id (see file http://download.geonames.org/export/dump/timeZones.txt) .br modification date : date of last modification in yyyy-MM-dd format .br .DE \fR .SH SEE ALSO \fI db.connect, v.select \fR .SH REFERENCES GeoNames Web site .br GeoNames Data Dump Server .SH AUTHOR Markus Neteler .PP \fILast changed: $Date: 2011-11-08 10:42:51 +0100 (Tue, 08 Nov 2011) $\fR .PP Full index .PP © 2003-2014 GRASS Development Team