SpatiaLite: Difference between revisions

From GRASS-Wiki
Jump to navigation Jump to search
(init stub)
 
Line 10: Line 10:
Use the SQLite [[OGR]] driver and set the SPATIALITE data creation option to "yes".
Use the SQLite [[OGR]] driver and set the SPATIALITE data creation option to "yes".


  v.out.ogr in=usgsgages dsn=usgsgages.sqlite format=SQLite type=point dsco='SPATIALITE=yes'  
  v.out.ogr in=usgsgages dsn=usgsgages.sqlite \
    format=SQLite type=point dsco='SPATIALITE=yes'  


fixme: I'm getting this error:
fixme: I'm getting this error:

Revision as of 11:04, 18 May 2014

Spatialite

A SQLite database with geospatial extensions, much list PostGIS is to PostgreSQL.


Export

  • fixme! this page is heavily under construction.

Use the SQLite OGR driver and set the SPATIALITE data creation option to "yes".

v.out.ogr in=usgsgages dsn=usgsgages.sqlite \
   format=SQLite type=point dsco='SPATIALITE=yes' 

fixme: I'm getting this error:

ERROR 1: sqlite3_step() failed:
  usgsgages.GEOMETRY violates Geometry constraint [geom-type or SRID not allowed] (19)


An alternate way is to load the layer in QGIS's GRASS toolbox, then right click on the layer name and select "Save As...".