Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Convert vertices-as-rows to SDO_GEOMETRY (multi-part, M-enabled)

User_1871Apr 14 2022

I have multi-part polyline vertices stored as individual rows in an 18c table. The vertices have M-values:

ASSET_ID     PART_NUM VERTEX_NUM          X          Y          M
---------- ---------- ---------- ---------- ---------- ----------
001                 1          1          0          5          0
001                 1          2         10         10      11.18
001                 1          3         30          0      33.54
001                 2          1         50         10      33.54
001                 2          2         60         10      43.54

image.pngI want to convert the vertices to a multi-part SDO_GEOMETRY polyline, with the M-values included.
Is it possible to do that in Oracle?
Thanks.

Comments

Post Details

Added on Apr 14 2022
4 comments
139 views