[GRASS-user] trouble exporting to spatialite

[Markus Neteler]

On Mon, May 19, 2014 at 7:50 AM, Hamish <hamish.webmail at gmail.com> wrote:
> 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.

See
http://lists.osgeo.org/pipermail/gdal-dev/2013-May/036148.html
http://lists.osgeo.org/pipermail/gdal-dev/2013-May/036152.html

...perhaps a pointer.

Markus