Changes between Version 52 and Version 53 of UserGuidelines/GIS/Data

Timestamp:

09/04/10 08:49:28 (14 years ago)

Author:

Fran Boon

Comment:

Geonames update to use S3GIS

UserGuidelines/GIS/Data

@@ -5 +5 @@
 == Import Data ==
 === Geonames ===
- 1. Unzip the downloaded country file (a TAB-separated list) from http://download.geonames.org/export/dump/
-  * e.g. PK.txt
- 2. Transform each line in this file into XML by regular expression:
+There is an import_geonames() function in S3GIS which downloads/unzips the country file (a TAB-separated list) from http://download.geonames.org/export/dump/
+
+It should be run for the different level sof hierarchy that you wish to import (generally just the lowest level as Geonames just has Point data, so it's best to use other sources for the Polygons 1st, that way the Geonames importer can locate these Points within the correct Polygons of the hierarchy)
+
+NB It takes some time to do this import! Pakistan imports 95000 locations!
+
+In Web2py CLI:
+{{{
+gis.import_geonames('PK', 'L5')
+db.commit()
+}}}
+
+Alternate approach:
+ 1. Transform each line in this file into XML by regular expression:
 {{{
 
@@ -29 +40 @@
 Note: Need to replace & with & and to remove any invalid characters
 
- 3. Transform into S3XRC-XML using XSLT, stylesheet is available at
+ 2. Transform into S3XRC-XML using XSLT, stylesheet is available at
    * [http://pub.nursix.org/eden/geonames/geonames.xsl]
-
-To Do:
- * ~~ADM1->ADM4, PPLx to Levels L1->L4~~ ([http://pub.nursix.org/eden/geonames/pakistan.zip done])
- * Link to L1 -> L0
- * Use hierarchy.txt to link L2->L1
-  * unfortunately no data for L3/L4 :/
- * Remove L2->L4 for unaffected areas
 === !OpenStreetMap ===
 We have an XSLT [http://eden.sahanafoundation.org/browser/static/xslt/import/osm.xsl stylesheet] to import .osm files, but this needs work to understand the admin hierarchy properly.