<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Moin Michael,</p>
<p>yay for the zone prefix "32" for the easting because you use
those huge numbers to determine which of the two CRS they belong
to. If the easting (x) value is > 30000000, then you have to
transform the coordinates to EPSG:25832, otherwise you don't.</p>
<p>Some untested pseudocode:</p>
<p>if(<br>
(x(@geometry) > 30000000),<span
style="font-family:"Tahoma",sans-serif" lang="EN-US">transform($geometry,
'EPSG:4647', 'EPSG:25832'), $geometry)</span></p>
<p><span style="font-family:"Tahoma",sans-serif"
lang="EN-US">Grüße an die Nordsee<br>
Hannes<br>
</span></p>
<p><span style="font-family:"Tahoma",sans-serif"
lang="EN-US">PS: For older QGIS use $geometry<br>
</span></p>
<p><br>
</p>
<div class="moz-cite-prefix">Am 24.01.23 um 09:02 schrieb Reetz,
Michael (NLPVW) via QGIS-User:<br>
</div>
<blockquote type="cite"
cite="mid:5da26f9140fe43f99396e7c5e39f2781@nlpvw.niedersachsen.de">
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style>@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:#954F72;
text-decoration:underline;}span.E-MailFormatvorlage17
{mso-style-type:personal;
font-family:"Tahoma",sans-serif;
color:windowtext;}.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}div.WordSection1
{page:WordSection1;}</style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif">Hello
list,<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif"
lang="EN-US">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?<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif"
lang="EN-US"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Best
regards<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Michael<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE"><o:p> </o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:DE">*****************************************
<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Michael
Reetz<o:p></o:p></span></p>
<p class="MsoNormal"><span
style="font-size:9.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Datenbanken
und Anwendungsentwicklung<br>
Nationalpark-Verwaltung Niedersächsisches Wattenmeer <br>
Virchowstr. 1 | 26382 Wilhelmshaven <br>
Tel.: +49 (0) 4421 911 291 <br>
e-mail: <a
href="mailto:michael.reetz@nlpv-wattenmeer.niedersachsen.de"
moz-do-not-send="true"><span style="color:blue">michael.reetz@nlpvw.niedersachsen.de</span></a>
<br>
Web: <a href="https://www./" moz-do-not-send="true"><span
style="color:blue">https://www.</span></a><u><span
style="color:blue">nationalpark-wattenmeer.de</span></u>
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE"><img
style="width:2.2812in;height:1.2291in" id="Grafik_x0020_1"
src="cid:part1.5TAg5xfI.ftjZjnlB@wheregroup.com" class=""
width="219" height="118" border="0"><o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="moz-mime-attachment-header"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
QGIS-User mailing list
<a class="moz-txt-link-abbreviated" href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Johannes Kröger / GIS-Entwickler/-Berater
---------------------------------------------
Schon gewusst?
In unserem Blog geben wir Tipps & Tricks zu
Open-Source-GIS-Software und berichten aus
unserem Experten-Alltag:
<a class="moz-txt-link-freetext" href="https://wheregroup.com/blog/">https://wheregroup.com/blog/</a>
---------------------------------------------
WhereGroup GmbH
Grevenweg 89
20537 Hamburg
Germany
Tel: +49 (0)228 / 90 90 38 - 36
Fax: +49 (0)228 / 90 90 38 - 11
<a class="moz-txt-link-abbreviated" href="mailto:johannes.kroeger@wheregroup.com">johannes.kroeger@wheregroup.com</a>
<a class="moz-txt-link-abbreviated" href="http://www.wheregroup.com">www.wheregroup.com</a>
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
</pre>
</body>
</html>