Idea/enhancement:
Could Oracle add a function to sdo_geometry/Spatial that would return the midpoint coordinates of polylines? (including multipart polylines)
While it might be possible to cobble together a string of existing functions to get the midpoint, I feel it would be better if there were an OOTB function:
OOTB functions are simple to use.
The use case is quite common. GIS practitioners often need to get the midpoints of lines.
An OOTB function would be more performant and less error prone -- compared to homemade solutions.
Thanks.