Changes between Version 166 and Version 167 of GIS/Data

Timestamp:

03/27/20 22:07:09 (5 years ago)

Author:

Fran Boon

Comment:

US Airports

GIS/Data

@@ -1026 +1026 @@
 }}}
 
+Airports & Heliports:
+* [http://eden.sahanafoundation.org/downloads/US_Transport.7z US_Transport.7z]
+
+These have come originally from [https://data.humdata.org/dataset/ourairports-usa HDX] with L1 fixed & L2 added
+
+Use [http://7zip.org 7-Zip] to extract to your web2py folder & then install like this:
+{{{
+cd /home/web2py
+p7zip -d US_Transport.7z
+python web2py.py -S eden -M
+
+auth.override = True
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "transport", "airport.xsl")
+resource = s3db.resource("transport_airport")
+filename = "airport.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+stylesheet = os.path.join(request.folder, "static", "formats", "s3csv", "transport", "heliport.xsl")
+resource = s3db.resource("transport_heliport")
+filename = "heliport.csv"
+File = open(filename, "r")
+resource.import_xml(File, format="csv", stylesheet=stylesheet)
+db.commit()
+gis.update_location_tree()
+db.commit()
+}}}
 == Asia ==