[Qgis-user] Copy / paste features to spatialite generates

[Josef K]

Hi Julian

I guess your problem is related to geometry types (
http://www.gaia-gis.it/spatialite-2.4.0-4/spatialite-cookbook/html/new-geom.html).
Try to define your spatialite geometries as multipoint, multilinestring and
multipolygons. Then they will be more compatible with shapefiles and you
may copy/paste in qgis.

Although I would recommend that you tried using spatialite-gui (or perahaps
qspatialite) instead. By those tools you can temporarily upload the
shapefile to your database file and then use sql syntax 'insert into ...
select ... ' the features you want into your db tables. Using sql syntax
will give you more control of fields, data types etc.

regards
Josef

Date: Sun, 16 Sep 2012 11:53:30 +0200
> From: Julian Bogdani <jbogdani at gmail.com>
> To: qgis-user <qgis-user at lists.osgeo.org>
> Subject: [Qgis-user] Copy / paste features to spatialite generates
>         error
> Message-ID: <A7512D49-0F85-4CB5-A3D2-85DA4919E24C at gmail.com>
> Content-Type: text/plain; charset=us-ascii
>
> Hello all,
> I've tried to add to an existing spatialite layer some features from
> another layer.
> The existing layer is a simple shapefile: I selected the features I wanted
> to copy and pasted to the spatialite layer. Everything was working file
> until I tried to save the changes. The following error appears:
>
> Could not commit changes to layer Plan_gen
>
> Errors: ERROR: 903 feature(s) not added.
> Provider errors:
> SQLite error: Plan_gen.Geometry violates Geometry constraint [geom-type or
> SRID not allowed]
> SQL: INSERT INTO "Plan_gen"("PKUID","Geometry","Layer","area") VALUES
> (NULL,GeomFromWKB(?, 32634),?,?)
>
>
> it states it might be a problem of geometry type or a SRID problem. All
> layers are in the same CRS (EPSG:32634), and all features, in both layers,
> are of type polyline.
>
> Is it a spatialite bug? a qgis bug? or Am I missing anything?
>
> I've had this issue with other data before. The solution I adopted to work
> around this was:
> 1) save the spatialite layer as shapefile
> 2) paste data into the newly created shapefile
> 3) delete the spatialite table
> 4) load in the spatialite DB the shapefile
>
> This works, but it is too tricky for everyday use. I tried to convert all
> my shapefiles to spatialite, but the limitation spatilite still have in
> data structure manipulation (adding/removing/renaming fields, etc, a sqlite
> limit in fact) and now in content editing make me think that that was not a
> good idea. I can not switch this archives to postGIS yet, because of the
> actual work-flow organization of the project.
>
> Any help or advice will be appreciated!
>
>
> -----
> Julian Bogdani
> jbogdani at gmail.com
> http://bradypus.net
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120917/427867ff/attachment.html>