SpatiaLite

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