This content has been marked as final. Show 2 replies
The sdo_gtype of your sample geometry is 3002 which suggests you are storing x, y, z values. i.e. heights in the z.
Based on your explanation of the data, it sounds like you should be using Linear Referencing - read about it here (
Note that use of Linear Referencing requires an Oracle Spatial license - Locator is not enough.
SDO_LRS has a variety of functions/operators which will help you achieve your goal.