Changes between Version 8 and Version 9 of GIS/Data

Timestamp:

11/10/13 19:18:12 (11 years ago)

Author:

Fran Boon

Comment:

Philippines

GIS/Data

@@ -39 +39 @@
 db.commit()
 }}}
+
+=== Philippines ===
+Admin Boundaries:
+* [http://eden.sahanafoundation.org/downloads/PH_Lx.7z PH_Lx.7z]
+
+These have come originally from [http://gadm.org GADM] but have had L1s inserted by [http://www.philgis.org/freegisdata.htm PhilGIS] so their L1s become L2s, etc
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d PH_Lx.7z
+python web2py.py -S eden -M
+
+auth.override = True
+resource = s3db.resource("gis_location")
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
+import_file = "PH_L0.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "PH_L1.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "PH_L2.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "PH_L3.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+import_file = "PH_L4.csv"
+File = open(import_file, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
+
 
 === Vietnam ===