About

Nodes of an object

Articles Related

Example

• X,Y for two-dimensional objects

Function

• Oracle Spatial: SDO_UTIL.GETVERTICES Table Function

SELECT c.gid, t.X, t.Y, t.id
FROM HI_VERBLIJFSOBJECT c,
TABLE(SDO_UTIL.GETVERTICES(c.geometry)) t
ORDER BY c.gid, t.id;

GID	X	Y	ID
8	231675.128778746	583491.401516593	1
10	232767.789937693	581447.10954301	1
14	232767.789937693	581447.10954301	1