[mapserver-users] postgis to spatile-ogr

[nikos at maich.gr]

Hi,

Thanx for the replies...

I need as David says, to support layers and queries where I join geom
tables with user generated external attribute tables (postgres).

Eons ago I was doing this on shapefiles, using a modified dbflib that
would overwrite columns in the dbf... Worked well, but needless to say it
was not multi-user and kinda roundabout...

OGR seems to join shp/dbf's with external attributes, but is
excruciatingly slow....
OGR is much faster when using sqlite db's, prolly because the sql is
pumped to the native, sqlite engine...

MS supports postgis joins directly in the mapfile, and this is what I'm
currently using, but need to go to temporary solution w/ less overhead...

will see....

regards,

nikos




> 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
>
>
>
>