[Qgis-user] Oriented points in Oracle Database

[Huesmann, Michaela]

Hello all,

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?
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.


My geometries in Oracle look like these examples::

oriented Point in Oracle DB with rotation
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, -0.958224533235959, 0.286017034291192, 0))

oriented Point in Oracle DB without rotation
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, 1, 0, 0))


Best regards,
Michaela




[Kreisstadt Steinfurt]<http://www.steinfurt.de>

 - 48565 Steinfurt
www.steinfurt.de<http://www.steinfurt.de>

Mit freundlichen Grüßen
im Auftrag
Michaela Huesmann
Geodaten
Fachdienst Tiefbau

Tel.: +49 2552 925 219
Fax:
E-Mail: michaela.huesmann at Stadt-Steinfurt.de<mailto:michaela.huesmann at Stadt-Steinfurt.de>

Bitte denken Sie an die Umwelt, bevor Sie diese E-Mail ausdrucken.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240802/1208dac8/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: imageaae07f.JPG
Type: image/jpeg
Size: 10418 bytes
Desc: imageaae07f.JPG
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20240802/1208dac8/attachment.jpe>