O'Reilly logo

Applying and Extending Oracle Spatial by Siva Ravada, Simon Gerard Greener

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Vectorizing geometries with linestrings

This section shows you how to take any linestring or polygon geometry object and decompose it even further than ST_ExplodeGeometry; not just the extraction of individual elements and subelements, but right down to individual vectors. A vector is a directed two vertex linestring.

(X1,Y2) ---> (X2,Y2)
E.g. SDO_GEOMETRY(2002,NULL,NULL,
                  SDO_ELEM_INFO_ARRAY(1,2,1),
                  SDO_ORDINATE_ARRAY (1,1,2,1))

The only level lower than this is the individual vertex level!

Vectorization of an SDO_GEOMETRY object requires access to all the vertices of that object. The SDO_UTIL.GetVertices function can be used to return the vertices of an SDO_GEOMETRY object in a form that is easy and natural to work with. This function returns the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required