[mapserver-users] postgis to spatile-ogr

[Fawcett, David (MPCA)]

I looks like with gdal 1.7, spatialite support has improved.  If you need to support layers based on queries that link geometry tables with attribute tables, spatialite could still potentially work.  I haven't tested out a spatialite layer yet though.

http://www.gdal.org/ogr/drv_sqlite.html

there is also a new QGIS plugin that allows you to check data out of a PostGIS db and put it into a spatialite db.  It looks like it requires the trunk version of QGIS.  http://www.sourcepole.com/2010/9/29/offline-editing-plugin-for-qgis

David.

From: mapserver-users-bounces at lists.osgeo.org [mailto:mapserver-users-bounces at lists.osgeo.org] On Behalf Of Sebastian E. Ovide
Sent: Thursday, October 21, 2010 5:35 PM
To: nikos at maich.gr
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] postgis to spatile-ogr

if you need only to display geometries with mapserver u can simply use shapes files... anything that can be read by gdal can be read by mapserver
On Thu, Oct 21, 2010 at 2:38 PM, <nikos at maich.gr<mailto:nikos at maich.gr>> wrote:
Hello,

Was wondering if an application that is currently set up with postgis data
sources can work directly by changing only the data source, e.g change the
DATA string to "ogr" in the mapfile.

Have to setup a demo remotely and don't really want to drag pgsql along
only for the demo.

If, so, would ogr2ogr be the most direct way to dump the postgis tables
into sqlite?

regards,

nicolas boretos

_______________________________________________
mapserver-users mailing list
mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/mapserver-users



--
Sebastian E. Ovide



-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20101021/1973251a/attachment-0001.html