#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>