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!

Idea: Function to remove Z, but not M, from SDO_GEOMETRY

User_1871Apr 22 2022

For scenarios where we have an SDO_GEOMETRY that has Z and M coordinates:
I can remove M's, but not Z's using SDO_LRS.CONVERT_TO_STD_GEOM
And I can remove both M's and Z's using SDO_CS.MAKE_2D
Idea: Could Oracle add a function for removing the Z's, but not the M's?
Related:
https://community.oracle.com/tech/apps-infra/discussion/4497490/how-to-remove-z-but-not-m-from-sdo-geometry#latest

Comments
Post Details
Added on Apr 22 2022
2 comments
154 views