[GRASS-dev] [GRASS GIS] #2300: v.out.ogr: spatialite support not working

[GRASS GIS]

#2300: v.out.ogr: spatialite support not working
-----------------------+-----------------------------------
  Reporter:  hamish    |      Owner:  grass-dev@…
      Type:  defect    |     Status:  new
  Priority:  critical  |  Milestone:  7.0.3
 Component:  Vector    |    Version:  svn-trunk
Resolution:            |   Keywords:  v.out.ogr, spatialite
       CPU:  x86-64    |   Platform:  Linux
-----------------------+-----------------------------------

Comment (by mlennert):

 Replying to [comment:6 neteler]:
 > Testing again, the "GEOMETRY violates Geometry constraint" error is gone

 With a completely fresh release70 checkout, I still get the error:


 {{{
 v.out.ogr input=usgsgages output=usgsgages.sqlite format=SQLite type=point
 dsco='SPATIALITE=yes'
 Exporting 433 features...
 ERROR 1: sqlite3_step() failed:
   usgsgages.GEOMETRY violates Geometry constraint [geom-type or SRID not
 allowed] (19)
 ERROR 1: sqlite3_step() failed:
   usgsgages.GEOMETRY violates Geometry constraint [geom-type or SRID not
 allowed] (19)
 [...]
 }}}

 Did you apply Hamish' patch locally ?

 Or maybe a question of spatialite version ? I have 4.3.0. with SQLite
 version 3.9.2.

 The 'POINTZ' error is weird, as AFAIK POINTZ is a response to the specific
 shapefile driver option 'SHPT=type' and I don't know how this gets chosen
 for the SQLite format.

--
Ticket URL: <https://trac.osgeo.org/grass/ticket/2300#comment:7>
GRASS GIS <https://grass.osgeo.org>