[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 neteler):

 Replying to [comment:9 mlennert]:
 > I've just attached a patch that implements Hamish' solution for
 release70. With this I can export the points without error.

 Success!

 {{{
 GRASS 7.0.3svn (nc_spm_08_grass7):~ > v.out.ogr input=usgsgages
 output=usgsgages.sqlite format=SQLite type=point dsco='SPATIALITE=yes'
 Exporting 433 features...
  100%
 v.out.ogr complete. 433 features (Point type) written to <usgsgages>
 (SQLite format).
 GRASS 7.0.3svn (nc_spm_08_grass7):~ > ogrinfo -so usgsgages.sqlite
 usgsgages
 INFO: Open of `usgsgages.sqlite'
       using driver `SQLite' successful.

 Layer name: usgsgages
 Geometry: Point
 Feature Count: 433
 Extent: (153611.375000, 38448.441406) - (898629.937500, 407620.562500)
 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)
 }}}

 > But as Hamish mentioned, this is only a partial solution and the module
 probably needs similar fixes for other geometry types.

 At least one would be fixed...

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