[prev in list] [next in list] [prev in thread] [next in thread]
List: qgis-user
Subject: Re: [Qgis-user] Transform some records in an SQL Server table
From: "Reetz, Michael \(NLPVW\) via QGIS-User" <qgis-user () lists ! osgeo ! org>
Date: 2023-01-24 9:52:56
Message-ID: d96ddcc09d914cad90e81a005df75d97 () nlpvw ! niedersachsen ! de
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
[Attachment #4 (text/plain)]
Moin Hannes,
that is exactly what I needed. Thank you very much.
Grüße zurück
Michael
Von: Johannes Kröger (WhereGroup) <johannes.kroeger@wheregroup.com>
Gesendet: Dienstag, 24. Januar 2023 09:58
An: Reetz, Michael (NLPVW) <Michael.Reetz@nlpvw.niedersachsen.de>; \
qgis-user@lists.osgeo.org
Betreff: Re: [Qgis-user] Transform some records in an SQL Server table
ACHTUNG!! Diese E-Mail erreicht Sie von einem Absender außerhalb der \
niedersächsischen Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung. Bitte \
klicken Sie auf keine Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den \
Absender nicht kennen und nicht wissen, ob der Inhalt sicher ist.
Moin Michael,
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.
Some untested pseudocode:
if(
(x(@geometry) > 30000000),transform($geometry, 'EPSG:4647', 'EPSG:25832'), \
$geometry)
Grüße an die Nordsee
Hannes
PS: For older QGIS use $geometry
Am 24.01.23 um 09:02 schrieb Reetz, Michael (NLPVW) via QGIS-User:
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@nlpvw.niedersachsen.de<mailto:michael.reetz@nlpv-wattenmeer.niedersachsen.de>
Web: https://www.<https://www./>nationalpark-wattenmeer.de
[cid:image001.png@01D92FE2.03F17350]
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org<mailto:QGIS-User@lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--
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:
https://wheregroup.com/blog/
---------------------------------------------
WhereGroup GmbH
Grevenweg 89
20537 Hamburg
Germany
Tel: +49 (0)228 / 90 90 38 - 36
Fax: +49 (0)228 / 90 90 38 - 11
johannes.kroeger@wheregroup.com<mailto:johannes.kroeger@wheregroup.com>
www.wheregroup.com<http://www.wheregroup.com>
Geschäftsführer:
Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
-------------------------------
[Attachment #5 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<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 Definitions */
@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:"Time new Roman";
panose-1:0 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Vorformatiert Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-language:DE;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-fareast-language:DE;}
span.E-MailFormatvorlage19
{mso-style-type:personal;
font-family:"Tahoma",sans-serif;
color:windowtext;}
span.HTMLVorformatiertZchn
{mso-style-name:"HTML Vorformatiert Zchn";
mso-style-priority:99;
mso-style-link:"HTML Vorformatiert";
font-family:Consolas;
mso-fareast-language:EN-US;}
span.E-MailFormatvorlage22
{mso-style-type:personal-reply;
font-family:"Tahoma",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
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]-->
</head>
<body lang="DE" link="#0563C1" vlink="#954F72">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Moin \
Hannes,<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 lang="EN-US" \
style="font-family:"Tahoma",sans-serif">that is exactly what I needed. \
Thank you very much.<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">Grüße \
zurück<o:p></o:p></span></p> <p class="MsoNormal"><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif"><o:p> </o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">Michael<o:p></o:p></span></p> <p \
class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p> <div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="mso-fareast-language:DE">Von:</span></b><span \
style="mso-fareast-language:DE"> Johannes Kröger (WhereGroup) \
<johannes.kroeger@wheregroup.com> <br>
<b>Gesendet:</b> Dienstag, 24. Januar 2023 09:58<br>
<b>An:</b> Reetz, Michael (NLPVW) <Michael.Reetz@nlpvw.niedersachsen.de>; \
qgis-user@lists.osgeo.org<br> <b>Betreff:</b> Re: [Qgis-user] Transform some records \
in an SQL Server table<o:p></o:p></span></p> </div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div style="border:solid #003333 1.0pt;padding:2.0pt 2.0pt 2.0pt 2.0pt">
<p style="line-height:10.0pt;background:#D5EAFF"><span \
style="font-size:10.0pt;font-family:"Time new \
Roman",serif;color:red">ACHTUNG!!</span><span \
style="font-size:10.0pt;font-family:"Time new Roman",serif"> Diese E-Mail \
erreicht Sie von einem Absender außerhalb der niedersächsischen \
Landesverwaltungs-Infrastruktur mit TLS-Verschlüsselung. Bitte klicken Sie auf keine \
Links oder öffnen Sie keine E-Mail-Anhänge, falls Sie den Absender nicht kennen und \
nicht wissen, ob der Inhalt sicher ist.</span><span \
style="font-size:10.0pt;font-family:"Time new \
Roman",serif;mso-fareast-language:DE"><o:p></o:p></span></p> </div>
<div>
<p>Moin Michael,<o:p></o:p></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.<o:p></o:p></p> <p>Some untested pseudocode:<o:p></o:p></p>
<p>if(<br>
(x(@geometry) > 30000000),<span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">transform($geometry, 'EPSG:4647', \
'EPSG:25832'), $geometry)</span><o:p></o:p></p> <p><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">Grüße an die Nordsee<br> \
Hannes</span><o:p></o:p></p> <p><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">PS: For older QGIS use \
$geometry</span><o:p></o:p></p> <p><o:p> </o:p></p>
<div>
<p class="MsoNormal">Am 24.01.23 um 09:02 schrieb Reetz, Michael (NLPVW) via \
QGIS-User:<o:p></o:p></p> </div>
<blockquote style="margin-top:5.0pt;margin-bottom:5.0pt">
<p class="MsoNormal"><span style="font-family:"Tahoma",sans-serif">Hello \
list,</span><o:p></o:p></p> <p class="MsoNormal"><span \
style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p> <p \
class="MsoNormal"><span lang="EN-US" \
style="font-family:"Tahoma",sans-serif">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?</span><o:p></o:p></p> <p class="MsoNormal"><span \
lang="EN-US" style="font-family:"Tahoma",sans-serif"> </span><o:p></o:p></p>
<p class="MsoNormal"><span \
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Best \
regards</span><o:p></o:p></p> <p class="MsoNormal"><span \
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Michael</span><o:p></o:p></p>
<p class="MsoNormal"><span \
style="font-family:"Tahoma",sans-serif;mso-fareast-language:DE"> </span><o:p></o:p></p>
<p class="MsoNormal"><span \
style="font-size:9.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:DE">*****************************************
</span><o:p></o:p></p>
<p class="MsoNormal"><span \
style="font-size:9.0pt;font-family:"Tahoma",sans-serif;mso-fareast-language:DE">Michael \
Reetz</span><o:p></o:p></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"><span \
style="color:blue">michael.reetz@nlpvw.niedersachsen.de</span></a> <br>
Web: <a href="https://www./"><span style="color:blue">https://www.</span></a><u><span \
style="color:blue">nationalpark-wattenmeer.de</span></u> </span><o:p></o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:DE"><img border="0" \
width="219" height="118" style="width:2.2812in;height:1.2291in" id="Grafik_x0020_1" \
src="cid:image001.png@01D92FE2.03F17350"></span><o:p></o:p></p> <p \
class="MsoNormal"> <o:p></o:p></p> <p class="MsoNormal"><span \
style="mso-fareast-language:DE"><br> <br>
<o:p></o:p></span></p>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>QGIS-User mailing list<o:p></o:p></pre>
<pre><a href="mailto:QGIS-User@lists.osgeo.org">QGIS-User@lists.osgeo.org</a><o:p></o:p></pre>
<pre>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
<pre>Unsubscribe: <a \
href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre>
</blockquote>
<pre>-- <o:p></o:p></pre>
<pre>Johannes Kröger / GIS-Entwickler/-Berater<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>---------------------------------------------<o:p></o:p></pre>
<pre>Schon gewusst?<span \
style="font-family:"Tahoma",sans-serif">
</span><o:p></o:p></pre> \
<pre><o:p> </o:p></pre> <pre>In unserem Blog geben wir Tipps & Tricks \
zu<o:p></o:p></pre> <pre>Open-Source-GIS-Software und berichten \
aus <o:p></o:p></pre> <pre>unserem Experten-Alltag:<o:p></o:p></pre>
<pre><a href="https://wheregroup.com/blog/">https://wheregroup.com/blog/</a><o:p></o:p></pre>
<pre>---------------------------------------------<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>WhereGroup GmbH<o:p></o:p></pre>
<pre>Grevenweg 89<o:p></o:p></pre>
<pre>20537 Hamburg<o:p></o:p></pre>
<pre>Germany<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre>Tel: +49 (0)228 / 90 90 38 - 36<o:p></o:p></pre>
<pre>Fax: +49 (0)228 / 90 90 38 - 11<o:p></o:p></pre>
<pre><o:p> </o:p></pre>
<pre><a href="mailto:johannes.kroeger@wheregroup.com">johannes.kroeger@wheregroup.com</a><o:p></o:p></pre>
<pre><a href="http://www.wheregroup.com">www.wheregroup.com</a><o:p></o:p></pre>
<pre>Geschäftsführer:<o:p></o:p></pre>
<pre>Olaf Knopp, Peter Stamm <o:p></o:p></pre>
<pre>Amtsgericht Bonn, HRB 9885<o:p></o:p></pre>
<pre>-------------------------------<o:p></o:p></pre>
</div>
</div>
</body>
</html>
["image001.png" (image/png)]
_______________________________________________
QGIS-User mailing list
QGIS-User@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
--===============5367563771993987972==--
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic