[postgis-users] PostGIS to SpatiaLite
ricardo.bayley at gmail.com
Sat Jul 24 16:28:15 PDT 2010
I havent tried it much, but I know QGIS has this option.
The OGR module does this. It is very good.
Hope it works for you
On Sat, Jul 24, 2010 at 4:26 PM, Mike Toews <mwtoews at gmail.com> wrote:
> Ok ok, I've finally tamed ogr2ogr to a working state. When configuring
> GDAL, use "--with-spatialite=/usr/local" (for a locally installed
> SpatiaLite library), then make and install GDAL (note my build attempt
> with Ubuntu 10.04 was unsuccessful for reasons I don't have time to
> care for, but my build with 9.04 works).
> To create the SpatiaLite file export the first layer:
> $ ogr2ogr -f SQLite -dsco SPATIALITE=yes myfile.sqlite PG:"dbname=mydb
> user=myuser password=mypass" myschema.mytable
> And for additional layer/tables:
> $ ogr2ogr -f SQLite -update myfile.db PG:"dbname=mydb user=myuser
> password=mypass" myschema.my2ndtable
> The resulting file work with viewers, including SpatiaLite GUI/GIS, Quantum
> I've started http://trac.osgeo.org/postgis/wiki/SpatiaLite
> On 24 July 2010 10:43, Mike Toews <mwtoews at gmail.com> wrote:
> > Hi all,
> > I need to copy several PostGIS tables to a SpatiaLite file, so it can
> > be used on field laptops. A similar question appeared a year ago,
> > but there were no solutions.
> > I understand that ogr2ogr has support for SpatiaLite using GDAL 1.7.x,
> > however I cannot seem to configure the GDAL source to enable
> > SpatiaLite. Yet another option is FME, but I don't have time/budget
> > for this. FDO doe
> > Are there any other freely available server-side tools to do the
> > conversion? Thanks.
> > -Mike
> > 
> >  http://lists.osgeo.org/pipermail/gdal-dev/2010-July/025448.html
> postgis-users mailing list
> postgis-users at postgis.refractions.net
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the postgis-users