Changes between Initial Version and Version 1 of SpatiaLite


Ignore:
Timestamp:
Jul 24, 2010, 12:16:34 PM (14 years ago)
Author:
Mike Taves
Comment:

start article

Legend:

Unmodified
Added
Removed
Modified

  • SpatiaLite

    v1 v1  
     1[http://www.gaia-gis.it/spatialite/ SpatiaLite] is a relatively new GIS file format based on [http://www.sqlite.org/ SQLite], which uses a single file to store multiple layers and data tables.
     2
     3== Exporting from PostGIS to SpatiaLite ==
     4
     5Use [http://www.gdal.org/ogr2ogr.html ogr2ogr] built with [http://www.gdal.org/ogr/drv_sqlite.html SpatiaLite options].
     6
     7To create the SpatiaLite file export the first layer:
     8{{{
     9$ ogr2ogr -f SQLite -dsco SPATIALITE=yes myfile.sqlite PG:"dbname=mydb user=myuser password=mypass" myschema.mytable
     10}}}
     11And for additional layer/tables:
     12{{{
     13$ ogr2ogr -f SQLite -update myfile.sqlite b PG:"dbname=mydb user=myuser password=mypass" myschema.my2ndtable
     14}}}