[GRASS-user] trouble exporting to spatialite

[Hamish]

Hi,

I'm have trouble exporting in spatialite format in GRASS 6, wondering
if anyone else has been able to have it work? Seems like a common
task.

using the SQLite driver with v.out.ogr works ok, but when I
add the spatialite option as described in the OGR format page
it gives an error for every data point:

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

the error message is:

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

and looking inside the resulting file with sqlitebrowser it seems no
points are uploaded to the table.


Installed GDAL is 1.9.0 so should be new enough. (debian/wheezy)


On the same system with self-compiled qgis 2.2* I can use the GRASS
toolbox to load in the grass map and right click it in the layer list
to 'Save As..' a seemingly-good copy.

any ideas?

[*] if anyone wants qgis 2.2 packages for amd64 deb/stable, just ask.


Ben had trouble with sqlite3_step() a while ago, but it's not quite
the same error:
 http://thread.gmane.org/gmane.comp.gis.grass.devel/35027/



regards,

-- 
Hamish <hamish.webmail at gmail.com>