Changes between Version 20 and Version 21 of UserGuidelines/GIS/Data

Timestamp:

08/20/10 07:04:02 (15 years ago)

Author:

Dominic König

Comment:

--

UserGuidelines/GIS/Data

@@ -6 +6 @@
  1. Unzip the downloaded country file (a TAB-separated list) from http://download.geonames.org/export/dump/
   * e.g. PK.txt
- 2. Turn each line into XML by regular expression:
+ 2. Transform each line in this file into XML by regular expression:
 {{{
-^(\d*)\t([^\t]*)\t([^\t]*)\t([^\t]*)\t([0-9\.]*)\t([0-9\.]*).*
+
+^(\d*)\t([^\t]*)\t([^\t]*)\t([^\t]*)\t([0-9\.]*)\t([0-9\.]*)\t[^\t]*\t([A-Z]*).*
+
 into:
+
 <location>
        <id>$1</id>
@@ -17 +20 @@
        <lat>$5</lat>
        <lon>$6</lon>
+       <featureClass>$7</featureClass>
 </location>
+
 }}}
- 3. Replace & with &amp;, remove any invalid characters
- 4. Transform into S3XRC using XSLT
+
+This can be done using an RE-capable editor (e.g. Kate), Perl or even Python.
+Note: Need to replace & with &amp; and to remove any invalid characters
+
+ 3. Transform into S3XRC-XML using XSLT, stylesheet is available at
+   * [http://pub.nursix.org/eden/geonames/geonames.xsl]
 
 To Do:
- * ADM1 -> ADM4 to Levels L1->L4
+ * ~~ADM1->ADM4, PPLx to Levels L1->L4~~ (done)
  * Link to L1 -> L0
  * Use hierarchy.txt to link L2->L1