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

Adjusting coordinate dimensions

Some software products can create 3D SDO_GEOMETRY objects where the Z ordinate is NULL or 0. To use some of the Oracle Spatial processing functionality, the Z ordinate must be removed. While basic functions to do this are covered in the book Pro Oracle Spatial, variations are often needed. The following are introduced here:

Create Or Replace Type Body T_Geometry [...] /* Dimensional Adjustment */ Member Function ST_To2D Return T_Geometry Deterministic, Member Function ST_To3D(p_zordtokeep In Integer) Return T_Geometry Deterministic, Member Function ST_To3D(p_start_z In Number, p_end_z In Number, p_unit In varchar2 default null) Return T_Geometry Deterministic, Member Function ST_FixZ(p_default_z In Number := -9999 ...

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