[Qgis-user] Transform some records in an SQL Server table

[Reetz, Michael (NLPVW)]

Hello list,

I have an SQL Server table with a geometry attribute. Most of the records are in EPSG 25832 but some are in EPSG 4647. Is it possible to transform these records to EPSG 25832? I've tried to do this with "geom_to_wkt(transform($geometry, 'EPSG:4647', 'EPSG:25832'))" in the field calculator. But since QGIS assumes that all coordinates are already in this crs, this doesn't work. Any other idea?

Best regards
Michael

*****************************************
Michael Reetz
Datenbanken und Anwendungsentwicklung
Nationalpark-Verwaltung Niedersächsisches Wattenmeer
Virchowstr. 1 | 26382 Wilhelmshaven
Tel.: +49 (0) 4421 911 291
e-mail: michael.reetz at nlpvw.niedersachsen.de<mailto:michael.reetz at nlpv-wattenmeer.niedersachsen.de>
Web: https://www.<https://www./>nationalpark-wattenmeer.de
[cid:image003.png at 01D92FD2.8B933BA0]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230124/e5ac351a/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.png
Type: image/png
Size: 6513 bytes
Desc: image003.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20230124/e5ac351a/attachment.png>