|Version 24 (modified by 12 years ago) ( diff ),|
Blueprint for GIS Import/Export
We need to be able to Import & Export these XML formats to/from the Database:
- GeoRSS (URL fetch/publish)
- GPX (File upload/download)
- KML (File upload/download & URL fetch/publish)
- OSM (File upload/download)
- GML (? Low priority, not used much in real world)
Other formats which may be useful are Shapefiles, PostGIS & JSON.
These should be representations added to the RESTlike controller.
Rather than reinventing the wheel, we could consider wrapping FeatureServer to do a lot of this work for us (like Web2Py uses CherryPy) since it is WSGI-based.
Alternatively we could look to borrow code from it.
The XML conversion is probably best-done using XSL stylesheets:
KML export from Web2Py:
CSV to KML Converter:
- Useful to extend to handle images (multiple images => Tabs)
XML export from Web2Py:
We are choosing to use lxml for XML Import/Export:
- lxml: http://codespeak.net/lxml/index.html#introduction
Other options are available:
- PyRXP: http://www.reportlab.org/pyrxp.html
- Faster & optionally validating (DTD, XSD?), but requires compiling into Python so less portable (unless using pyexpat wrapper)
- XSD->DTD conversion (our schema are in XSD format)
- cElementTree - included in Python 2.5, strict & fast: http://effbot.org/zone/celementtree.htm
- sgmlop (supported by xmlrpclib): http://effbot.org/zone/sgmlop-index.htm
- pyexpat (non-validating & slower, but built-in to Python 2)
- Pyfo (example with Web2Py): http://michaelangela.wordpress.com/2008/04/10/simple-xml-creation-with-python/
- SAX: http://www.devshed.com/c/a/Python/Parsing-XML-with-SAX-and-Python/
This is another option for Import (via Python structures):
We should also be able to import Geotagged Photos & have these display on the Map.
Feature Metadata already includes an Image - so the work needed is just in terms of reading the Lat/Lon from the Tag & providing a UI:
Most developed OSS tools are:
- Exiv2 - C++ with pyexiv2 binding (still experimental)
- ExifTool - Perl (extra dependencies & needs to be run as system call)
- Comparison: http://www.picurl.org/development/wiki/Exiv2vsExifTool
Python works-in-progress here:
- http://www.ivan-herman.net/cgi-bin/blosxom.cgi/WorkRelated/SemanticWeb/xmpextract.html XMP-only
- http://code.google.com/p/python-xmp-toolkit/ XMP-only