<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
Hi Michaela,
<div class="moz-cite-prefix"><br>
just an idea as a starting point, it is not a solution: as I
understand the oriented points in ORACLE consists of the point
with its coordinates (x,y,z) and a second virtual point - the two
coordinates marked in your example - and both are building a
vector, so there is no angle stored so far. A possible solution
could be, to use an Oracle VIEW and convert the
MDSYS.SDO_ORDINATE_ARRAY object in a WKT-Object and an angle. With
both you can plot the point and rotate it. You can use SDO_UTIL to
convert the SDO_GEOMETRY object. Something like<br>
<br>
ATAN2(SDO_UTIL.GET_COORDINATE(mySDO_Geometry_Object,
2).SDO_POINT.Y , SDO_UTIL.GET_COORDINATE(mySDO_Geometry_Object,
2).SDO_POINT.X)<br>
<br>
will return the angle in radians<br>
<br>
Best regards<br>
Stefan<br>
<br>
</div>
<div class="moz-cite-prefix"><br>
</div>
<div class="moz-cite-prefix">Am 02.08.2024 um 12:58 schrieb
Huesmann, Michaela via QGIS-User:<br>
</div>
<blockquote type="cite"
cite="mid:51f50aead47541879e5b142b82d04d91@Stadt-Steinfurt.de">
<!-- 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-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;}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;}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">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=""
moz-do-not-send="true"><img style="border: 0px Solid ; "
src="cid:part1.vvxeT4UT.u0ixE7Eq@wheregroup.com"
alt="Kreisstadt Steinfurt" class="" width="228"
height="98"></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;"
moz-do-not-send="true"><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;"
moz-do-not-send="true"><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 size="1" face="Arial" color="#a5a5a5"><font color="#7d7d7d"><font
color="#7d7d7d"><br>
Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail
ausdrucken.</font><br>
</font></font><br>
<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">--
Mit freundlichen Grüßen
Stefan Giese
Projektleiter/Consultant
***********************************************************
FOSS Academy Sommerschule: Kompaktkurs zum Aufbau einer GDI
02.-06. September 2024, Präsenzveranstaltung in Bonn
<a class="moz-txt-link-freetext" href="https://www.foss-academy.com/kompaktkurse">https://www.foss-academy.com/kompaktkurse</a>
***********************************************************
WhereGroup GmbH
Schwimmbadstr. 2
79100 Freiburg
Germany
Tel.: +49 (0)761 / 519 102 - 61
Fax: +49 (0)761 / 519 102 - 11
<a class="moz-txt-link-abbreviated" href="mailto:stefan.giese@wheregroup.com">stefan.giese@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>