SpatiaLite

From GRASS-Wiki
Revision as of 11:04, 18 May 2014 by ⚠️HamishBowman (talk | contribs) (init stub)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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