Assistanze in using 3D Geometries about geoalchemy2

[adrien-berchet]

Hi @FelixEickeler !
Thanks for this report. I made a few tests and it seems that the constructed query is incorrect in this case: surprisingly the query in this case should be INSERT INTO lake (name, geom) VALUES (Lake, GeomFromEWKT('SRID=-1;LINESTRING(0 0 0, 1 1 1)')); (no Z at the end of LINESTRING). I don't know why SpatiaLite works like this while other dialects keep the Z. I will add some tests in GeoAlchemy2 to confirm this behavior and fix it if.
Sorry for the inconvenience, unfortunately I can't see any temporary workaround for this so you will have to wait for the official fix :-/

[adrien-berchet]

@sdp5 I think the way to fix this issue should be to update the WKT given to this function: https://github.com/geoalchemy/geoalchemy2/blob/master/geoalchemy2%2Ftypes%2Fdialects%2Fsqlite.py#L9-L22

[sdp5]

I can reproduce the issue. thanks @FelixEickeler !

@adrien-berchet Yea, get to that point. Not sure, should we get srid from spatial_type? doing some more testing ..

[adrien-berchet]

Hi @FelixEickeler
The new version GeoAlchemy2 == 0.15.0 has just been released and should fix your issue.
Can you please check and confirm the result here?