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