Select to view content in your preferred language

GetVertices() function in ST_Geometry

676
0
09-18-2021 09:19 PM
Status: Open
Bud
by
Esteemed Contributor

Oracle: 

It would be really helpful if we could get a function in ST_Geometry that would let us select the vertices of a feature as rows.

Oracle’s SDO_Geometry has a function called GetVertices. It is extremely handy.

https://docs.oracle.com/en/database/oracle/oracle-database/21/spatl/SDO_UTIL-reference.html#GUID-9CF...

We need to be able to easily access ST_Geometry feature vertices using SQL -- without using clunky workarounds like cross joins or custom types/functions.

Tags (1)