Changes between Version 77 and Version 78 of GIS/Data

Timestamp:

10/15/14 14:53:42 (10 years ago)

Author:

Fran Boon

Comment:

+SL

GIS/Data

@@ -82 +82 @@
 #resource.import_xml(File, format="csv", stylesheet=stylesheet)
 #db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
+
+=== Sierra Leone ===
+Admin Boundaries:
+* [http://eden.sahanafoundation.org/downloads/SL_Lx.7z SL_Lx.7z]
+
+These have come originally from [http://cod.humanitarianresponse.info COD] including PCodes & UNMIL 'Health' codes. PCodes have been made full where incomplete. Missing Western Urban L3s recreated from dissolved L4s.
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d SL_Lx.7z
+python web2py.py -S eden -M
+
+auth.override = True
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "gis", "location.xsl")
+resource = s3db.resource("gis_location")
+filename = "SL_L0.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "SL_L1.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "SL_L2.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "SL_L3.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+filename = "SL_L4.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
 gis.update_location_tree()
 db.commit()