[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
-----------------------+-----------------------------------
Changes (by neteler):

 * milestone:  6.4.4 => 7.0.3


Comment:

 Testing again, the "GEOMETRY violates Geometry constraint" error is gone
 but there is still an issue:

 {{{
 GRASS 7.0.3svn (nc_spm_08_grass7):~ >

 v.info usgsgages | grep 3D
  |   Map is 3D:              No |

 v.out.ogr input=usgsgages output=usgsgages.sqlite format=SQLite type=point
 dsco='SPATIALITE=yes'
 Exporting 433 features...
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 ...
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
  100%
 ERROR 1: Cannot insert feature with geometry of type POINTZ in column
 GEOMETRY. Type POINT expected
 v.out.ogr complete. 433 features (Point type) written to <usgsgages>
 (SQLite format).
 }}}

 While the resulting file is of 5.8MB, it does not contain geometry, likely
 due to above error:
 {{{
 ogrinfo -so usgsgages.sqlite usgsgages
 INFO: Open of `usgsgages.sqlite'
       using driver `SQLite' successful.

 Layer name: usgsgages
 Geometry: Point
 Feature Count: 0
 Layer SRS WKT:
 PROJCS["Lambert Conformal Conic",
     GEOGCS["grs80",
         DATUM["North_American_Datum_1983",
 SPHEROID["Geodetic_Reference_System_1980",6378137,298.257222101]],
         PRIMEM["Greenwich",0],
         UNIT["degree",0.0174532925199433],
         AUTHORITY["EPSG","4269"]],
     PROJECTION["Lambert_Conformal_Conic_2SP"],
     PARAMETER["standard_parallel_1",36.16666666666666],
     PARAMETER["standard_parallel_2",34.33333333333334],
     PARAMETER["latitude_of_origin",33.75],
     PARAMETER["central_meridian",-79],
     PARAMETER["false_easting",609601.22],
     PARAMETER["false_northing",0],
     UNIT["Meter",1]]
 FID Column = ogc_fid
 Geometry Column = GEOMETRY
 cat: Integer (0.0)
 objectid: Integer (0.0)
 site_id: String (0.0)
 site_name: String (0.0)
 telemetry: String (0.0)
 stream_flo: String (0.0)
 stage_only: String (0.0)
 qw_samples: String (0.0)
 wq_monitor: String (0.0)
 rainfall: String (0.0)
 met: String (0.0)
 office: String (0.0)
 hucode: String (0.0)
 county: String (0.0)
 }}}

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