Spatialite as a Datasource

[Adam Estrada]

All,

GeoREST looks pretty good but before I go too far down the rabbit
hole, I need to know if anyone has tested it with Spatialite. I see
that SQLIte is supported but that could mean anything. Your feedback
on this would be great!!!

Adam

[Jason Birch]

Hey Adam,

GeoREST supports (and is by far most performant with) the FDO SQLite format which is shared with OGR (though recent versions of OGR have added full Spatialite support).  You can see details on this format here:

http://trac.osgeo.org/fdo/wiki/FDORfc16

Unfortunately, the FDO provider for SQLite doesn't support Spatialite format natively.

There is a workaround, but it's a bit convoluted.  If the SQLite file is created by FDO, Spatialite can bring it in as a virtual table and work with it as usual.  I believe that you can use FDO Toolbox to create an FDO SQLite database.

Hope this helps.  One of my personal desires is to see native Spatialite support in the FDO Sqlite provider, but it just hasn't happened yet.

Jason

[Jason Birch]

To follow up on this, GeoREST works with the new SpatiaLite FDO provider:

http://www.sl-king.com/FdoSpatiaLite/fdospatialite.html

--
View this message in context: http://georest.99228.n3.nabble.com/Spatialite-as-a-Datasource-tp920284p1414396.html
Sent from the GeoREST Users mailing list archive at Nabble.com.