<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:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<!-- Kreisstadt Steinfurt IT Signatur (c) 12:58:13 Freitag, 2 August 2024 S. Hanke -->
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<style type="text/css">P.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
LI.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
DIV.ImprintUniqueID {
MARGIN: 0cm 0cm 0pt
}
TABLE.ImprintUniqueIDTable {
MARGIN: 0cm 0cm 0pt
}
DIV.Section1 {
page: Section1
}
</style>
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<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;}
/* 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;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;
mso-fareast-language:EN-US;}
@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">Hello all,<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">in an Oracle DB I have a table with oriented points. In the GIS program GeoMedia and GeoMedia Smart Client the points are visualised correct with rotation but not so in QGIS. Is there a way in QGIS to use the rotation saved within the
SDO_GEOMETRY?<o:p></o:p></p>
<p class="MsoNormal">Also my points with rotation where already existing in the table. Now I added some more points in QGIS but without rotation. How can I rotate them later? I hope there is a way without adding an extra data field and inserting a value for
each rotation.<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">My geometries in Oracle look like these examples::<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">oriented Point in Oracle DB with rotation<o:p></o:p></p>
<p class="MsoNormal">MDSYS.SDO_GEOMETRY(3001, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1, 1, 4, 1, 0), MDSYS.SDO_ORDINATE_ARRAY(391055.730698232, 5776970.49374646, 0<span style="background:yellow;mso-highlight:yellow">, -0.958224533235959, 0.286017034291192</span>,
0))<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">oriented Point in Oracle DB without rotation<o:p></o:p></p>
<p class="MsoNormal">MDSYS.SDO_GEOMETRY(3001, NULL, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1, 1, 1, 4, 1, 0), MDSYS.SDO_ORDINATE_ARRAY(391052.320592445, 5776971.48062262, 0,
<span style="background:yellow;mso-highlight:yellow">1, 0,</span> 0))<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Best regards,<o:p></o:p></p>
<p class="MsoNormal">Michaela<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<table class="ImprintUniqueIDTable" style="HEIGHT: 185px; WIDTH: 556px; BORDER-COLLAPSE: collapse" cellspacing="0" cellpadding="0" border="0">
<tbody>
<tr>
<td style="WIDTH: 260px" width="175"><a href="http://www.steinfurt.de" target=""><img width="228" height="98" style="border: 0px Solid ; " src="cid:imageaae07f.JPG@8fcc8109.46a61258" alt="Kreisstadt Steinfurt"></a><br>
<br>
- <font style="font-family:Arial;font-size:10pt;color:#7D7D7D;">48565</font> <font style="font-family:Arial;font-size:10pt;color:#7D7D7D;">Steinfurt</font><br>
<font size="2" face="Arial"><span style="color:#7D7D7D;text-decoration:none;"><a href="http://www.steinfurt.de" title="" target="" style="color:#7D7D7D;text-decoration:none;"><span style="color:#7D7D7D; text-decoration:none;">www.steinfurt.de</span></a></span></font></td>
<td style="WIDTH: 295px" valign="top"><font face="Arial"><font size="2"><br>
<br>
Mit freundlichen Grüßen</font><br>
</font><font size="2" face="Arial">im Auftrag<br>
</font><font style="font-family:Arial;font-size:13.5pt;color:#000000;font-weight:bold;">Michaela<font style="font-family:Arial;font-size:13.5pt;color:#000000;font-weight:bold;">
</font>Huesmann</font><span style="FONT-SIZE: 5pt"><font face="Arial"> </font></span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: Arial; COLOR: #000000"><br>
<font style="font-family:Arial;font-size:10pt;font-style:italic;">Geodaten</font><br>
<font style="font-family:Arial;font-size:10pt;">Fachdienst Tiefbau</font><br>
</span><font face="Arial"><span style="FONT-SIZE: 5pt"> </span><br>
</font><font style="font-family:Arial;font-size:10pt;color:#000000;"><font style="font-family:Arial;font-size:10pt;color:#000000;">Tel.:
</font>+49 2552 925 219</font><br>
<span style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; COLOR: #000000"><font size="1"><font size="2">Fax:</font>
</font><br>
</span><span style="FONT-SIZE: 9pt; FONT-FAMILY: Arial; COLOR: #000000"><font style="font-family:Arial;font-size:10pt;color:#000000;text-decoration:none;">E-Mail:
</font><span style="font-family:Arial;font-size:10pt;color:#000000;text-decoration:none;"><a href="mailto:michaela.huesmann@Stadt-Steinfurt.de" title="Click to send email to Huesmann, Michaela" target="" style="font-family:Arial;font-size:10pt;color:#000000;text-decoration:none;"><span style="font-family:Arial; font-size:10pt; color:#000000; text-decoration:none;">michaela.huesmann@Stadt-Steinfurt.de</span></a></span></span></td>
</tr>
</tbody>
</table>
<font color="#a5a5a5" size="1" face="Arial"><font color="#7d7d7d"><font color="#7d7d7d"><br>
Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.</font><br>
</font></font><br>
</body>
</html>