T_VECTOR/CONSTRUCTORS [ Modules ]

[ Top ] [ Modules ]

NAME

    A collection of T_VECTOR Constructors.

SOURCE

  Constructor Function T_Vector
  Return Self As Result,

  Constructor Function T_Vector( p_vector in &INSTALL_SCHEMA..T_Vector)
  Return Self As Result,

  Constructor Function T_Vector( p_line in mdsys.sdo_geometry)
  Return Self As Result,

  Constructor Function T_Vector(p_sdo_gtype In Integer,
                                p_sdo_srid  In Integer)
  Return Self As Result,

  Constructor Function T_Vector( p_vector_id  In Integer,
                                 p_startCoord In &INSTALL_SCHEMA..T_Vertex,
                                 p_endCoord   In &INSTALL_SCHEMA..T_Vertex,
                                 p_sdo_gtype  In Integer default null,
                                 p_sdo_srid   In Integer default null)
  Return Self As Result,

  Constructor Function T_Vector( p_vector_id  In Integer,
                                 p_startCoord In &INSTALL_SCHEMA..T_Vertex,
                                 p_midCoord   In &INSTALL_SCHEMA..T_Vertex,
                                 p_endCoord   In &INSTALL_SCHEMA..T_Vertex,
                                 p_sdo_gtype  In Integer default null,
                                 p_sdo_srid   In Integer default null)
  Return Self As Result,

  Constructor Function T_Vector( p_element_id    In Integer,
                                 p_subelement_id In Integer,
                                 p_vector_id     In Integer,
                                 p_startCoord    In &INSTALL_SCHEMA..T_Vertex,
                                 p_endCoord      In &INSTALL_SCHEMA..T_Vertex,
                                 p_sdo_gtype     In Integer default null,
                                 p_sdo_srid      In Integer default null)
  Return Self As Result,

  Constructor Function T_Vector( p_element_id    In Integer,
                                 p_subelement_id In Integer,
                                 p_vector_id     In Integer,
                                 p_startCoord    In &INSTALL_SCHEMA..T_Vertex,
                                 p_midCoord      In &INSTALL_SCHEMA..T_Vertex,
                                 p_endCoord      In &INSTALL_SCHEMA..T_Vertex,
                                 p_sdo_gtype     In Integer default null,
                                 p_sdo_srid      In Integer default null)
  Return Self As Result,

  Constructor Function T_Vector( p_vector_id  In Integer,
                                 p_startCoord In mdsys.vertex_type,
                                 p_endCoord   In mdsys.vertex_type,
                                 p_sdo_gtype  In Integer default null,
                                 p_sdo_srid   In Integer default null)
  Return Self As Result,

  Constructor Function T_Vector( p_vector_id  In Integer,
                                 p_startCoord In mdsys.vertex_type,
                                 p_midCoord   In mdsys.vertex_type,
                                 p_endCoord   In mdsys.vertex_type,
                                 p_sdo_gtype  In Integer default null,
                                 p_sdo_srid   In Integer default null)
  Return Self As Result,

T_VECTOR/orderBy [ Methods ]

[ Top ] [ Methods ]

NAME

    orderBy -- Implements ordering function that can be used to sort a collection of T_Vertex objects.

SYNOPSIS

    Static Function orderBy(p_vector in &INSTALL_SCHEMA..T_Vector)
             Return Number deterministic

INPUTS

    p_vector (T_VECTOR) - Order pair

DESCRIPTION

    This order by function allows a collection of T_Vertex objects to be sorted.
    For example in the ORDER BY clause of a SELECT statement. 
    Comparison only uses ordinates: X, Y, Z and W.
    If precision is an issue, the two vectors have to be rounded before this method can be used.

EXAMPLE

  With vectors as (
    select t_vector( p_vector_id => LEVEL,
                     p_startCoord=>t_vertex(p_x=>dbms_random.value(0,level),
                                            p_y=>dbms_random.value(0,level),
                                            p_id=>1,
                                            p_sdo_gtype=>2001,
                                            p_sdo_srid=>null),
                       p_endCoord=>t_vertex(p_x=>dbms_random.value(0,level),
                                            p_y=>dbms_random.value(0,level),
                                            p_id=>2,
                                            p_sdo_gtype=>2001,
                                            p_sdo_srid=>null),
                       p_sdo_gtype=>3002,
                       p_sdo_srid=>null
           ) as vector
        from dual
        connect by level < 5
      )
      select a.vector.st_astext(2) as vector
        from vectors a
        order by a.vector;
  VECTOR
  ---------------------------------------------------------------------------------------------------------------------------
  Vector(NULL,NULL,1,Start(.51,.86,NULL,NULL,1,2001,NULL),End(.2,.43,NULL,NULL,2,2001,NULL),SDO_GTYPE=3002,SDO_SRID=NULL)
  Vector(NULL,NULL,2,Start(1.3,1.31,NULL,NULL,1,2001,NULL),End(.96,1.56,NULL,NULL,2,2001,NULL),SDO_GTYPE=3002,SDO_SRID=NULL)
  Vector(NULL,NULL,3,Start(.84,2.03,NULL,NULL,1,2001,NULL),End(.55,.23,NULL,NULL,2,2001,NULL),SDO_GTYPE=3002,SDO_SRID=NULL)
  Vector(NULL,NULL,4,Start(2.69,1.34,NULL,NULL,1,2001,NULL),End(2.65,1.37,NULL,NULL,2,2001,NULL),SDO_GTYPE=3002,SDO_SRID=NULL)

  4 rows selected

RESULT

    order value (NUMBER) - -1 less than; 0 equal; 1 greater than

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/PI [ Functions ]

[ Top ] [ Functions ]

NAME

    PI -- Returns constant PI value.

SYNOPSIS

    Static Function PI
             Return Number

DESCRIPTION

    This function exposes static constant PI.

EXAMPLE

    SELECT T_VECTOR.PI()
      FROM DUAL;

                              T_VECTOR.PI()
    ---------------------------------------
    3.1415926535897932384626433832795028842

RESULT

    PI (NUMBER) - 3.1415926535897932384626433832795028842

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_AsText [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_AsText -- Returns text Description of underlying vector

SYNOPSIS

    Member Function ST_AsText(p_X_dec_places in integer default 8,
                              p_Y_dec_places in integer default 8,
                              p_Z_dec_places in integer default 3,
                              p_M_dec_places in integer default 3)
             Return Varchar2 Deterministic,

DESCRIPTION

    Returns textual description of vector with optional rounding of X,Y,Z and w ordinates to passed in precision.

INPUTS

    p_X_dec_places (integer) - value applied to x Ordinate.
    p_Y_dec_places (integer) - value applied to y Ordinate.
    p_Z_dec_places (integer) - value applied to z Ordinate.
    p_M_Dec_places (integer) - value applied to w/m Ordinate.

RESULT

    String - T_Vector in text format.
 TOBEDONE
    Reverse ST_FromText()

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Bearing [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Bearing -- Returns Bearing, in radians, from start to end

SYNOPSIS

    Member Function ST_Bearing()
             Return Number Deterministic

DESCRIPTION

    This function computes a bearing from the current object point's startCoord to its EndCoord.
    Result is in radians. Use static function ST_Degrees to return as a whole circle bearing.

RESULT

    bearing (Number) -- Bearing in Radians.

SEE ALSO

    ST_Degrees.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Dims [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Dims -- Returns number of ordinate dimensions

SYNOPSIS

    Member Function ST_Dims
             Return INTEGER Deterministic,

DESCRIPTION

    Examines SDO_GTYPE (2XXX etc) and extracts coordinate dimensions.
    If SDO_GTYPE is null, examines ordinates eg XY not null, Z null -> 2.

RESULT

    BOOLEAN (INTEGER) -- 2 if data 2D; 3 if 3D; 4 if 4D

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Distance [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Distance -- Returns Distance from vector to first vertex in sdo_geometry

SYNOPSIS

    Member Function ST_Distance(p_geom      in mdsys.sdo_geometry,
                                p_tolerance in number   DEFAULT 0.05,
                                p_precision In Integer  DEFAULT 2,
                                p_unit      in varchar2 DEFAULT NULL)
             Return Number Deterministic

INPUTS

    p_geom     (sdo_geometry) - A geometry from whose first vertex a bearing is calculated.
    p_tolerance      (NUMBER) - SDO_Tolerance for use with sdo_geom.sdo_distance.
    p_precision      (NUMBER) - Decimal digits of precision for a generic ordinate.
    p_unit         (VARCHAR2) - Oracle Unit of Measure eg unit=M.

DESCRIPTION

    This function computes a distance from the input sdo_geometry objects first point to the underlying T_Vector.
    Result is in the distance units of the SDO_SRID, or in p_units where supplied.

RESULT

    distance (Number) -- Distance in SRID unit of measure or in supplied units (p_unit)

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Distance [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Distance -- Returns Distance from vector supplied t_vertex (Wrapper)

SYNOPSIS

    Member Function ST_Distance(p_vertex    in &INSTALL_SCHEMA..T_Vertex,
                                p_tolerance in Number   DEFAULT 0.05,
                                p_precision In Integer  DEFAULT 2,
                                p_unit      in varchar2 DEFAULT NULL)
             Return Number Deterministic

INPUTS

    p_geom      (T_VERTEX) - A single vertex from which a bearing to the vector is calculated.
    p_tolerance   (NUMBER) - SDO_Tolerance for use with sdo_geom.sdo_distance.
    p_precision   (NUMBER) - Decimal digits of precision for a generic ordinate.
    p_unit      (VARCHAR2) - Oracle Unit of Measure eg unit=M.

DESCRIPTION

    (Wrapper over sdo_geometry ST_Distance method).
    This function computes a distance from the input t_vertex object to the underlying T_Vector.
    Result is in the distance units of the SDO_SRID, or in p_units where supplied.

RESULT

    distance (Number) -- Distance in SRID unit of measure or in supplied units (p_unit)

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Equals [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Equals -- Compares current object (SELF) with supplied vector.

SYNOPSIS

    Member Function ST_Equals(p_vector    in &INSTALL_SCHEMA..T_Vector,
                              p_precision in number  default 3,
             Return Integer deterministic

INPUTS

    p_vector   (T_VECTOR) - Vertex that is to be compared to current object (SELF).
    p_precision (INTEGER) - Decimal digits of precision for all ordinates.
    p_coords    (Integer) - Boolean. If 1, only coordinates are compared; if 0, then all elements including vector_id etc are compared.

DESCRIPTION

    This function compares current vector object (SELF) to supplied vector (p_vertex).
    If all ordinates (to supplied precision) are equal, returns True (1) else False (0).
    SDO_GTYPE, SDO_SRID and ID are not compared uinless p_coords = 0

RESULT

    BOOLEAN (INTEGER) - 1 is True (Equal); 0 is False.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_hasZ [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_hasZ -- Tests vector to see if coordinates include a Z ordinate.

SYNOPSIS

    Member Function ST_hasZ
             Return Integer Deterministic,

DESCRIPTION

    Examines SDO_GTYPE (DLNN etc). If D position is 2 then vector does not have a Z ordinate.
    If D position is 3 and measure ordinate position (L) is 0 then vector has Z ordinate.
    If D position is 3 and measure ordinate position (L) is not equal to 0 then vector does not have a Z ordinate.
    If D position is 4 and measure ordinate position (L) is equal to 0 or equal to D (4) then vector has a Z ordinate.
    If D position is 4 and measure ordinate position (L) is equal to 3 then vector does not have a Z ordinate.
    If SDO_GTYPE is null, examines Z and W ordinates of the vector's coordinates to determine if vector has Z ordinate.

RESULT

    BOOLEAN (INTEGER) -- 1 is has Z ordinate, 0 otherwise.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_isEmpty [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_isEmpty -- Checks if Vector has any valid data.

SYNOPSIS

    Member Function ST_isEmpty
             Return INTEGER Deterministic,

DESCRIPTION

    If vector object data values are NULL returns 1 (TRUE) ie is Empty; else 0 (False)

RESULT

    BOOLEAN (INTEGER) -- 1 if vector has no non null values; 0 if has values

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_isLocator [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_isLocator -- Makes best effort to osee if database is a locator databases.

SYNOPSIS

    Member Function ST_isLocator
             Return INTEGER Deterministic,

DESCRIPTION

    A static method that attempts to determine if the host database is a Locator database or has Spatial objects.

RESULT

    BOOLEAN (INTEGER) -- 1 Is Locator else 0 (Spatial)

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2016 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_isMeasured [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_isMeasured -- Tests vector to see if coordinates include a measure.

SYNOPSIS

    Member Function ST_isMeasure
             Return Integer Deterministic,

DESCRIPTION

    Examines SDO_GTYPE (DLNN etc) to see if sdo_gtype has measure ordinate eg 3302 not 3002.
    If SDO_GTYPE is null, examines coordinates to see if W ordinate is not null.

RESULT

    BOOLEAN (INTEGER) -- 1 is measure ordinate exists, 0 otherwise.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Length [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Length -- Returns Length of the vector 

SYNOPSIS

    Member Function ST_Length(p_tolerance in Number   DEFAULT 0.005,
                              p_unit      in varchar2 DEFAULT NULL)
             Return Number Deterministic

INPUTS

    p_tolerance   (NUMBER) - SDO_Tolerance for use with sdo_geom.sdo_distance.
    p_unit      (VARCHAR2) - Oracle Unit of Measure eg unit=M.

DESCRIPTION

    This function computes a length from the underlying T_Vector.
    Result is in the distance units of the SDO_SRID, or in p_units where supplied.

RESULT

    distance (Number) -- Distance in SRID unit of measure or in supplied units (p_unit)

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Lrs_Dim [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Lrs_Dim -- Tests vector to see if coordinates include a measure ordinate and returns measure ordinate's position.

SYNOPSIS

    Member Function ST_Lrs_Dim
             Return Integer Deterministic,

DESCRIPTION

    Examines SDO_GTYPE (DLNN etc) measure ordinate position (L) and returns it.
    If SDO_GTYPE is null, examines coordinates to see if W ordinate is not null.

RESULT

    BOOLEAN (INTEGER) -- L from DLNN.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_MeasureLength [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_MeasureLength -- Returns difference between end measure and start measure of vector.

SYNOPSIS

    Member Function ST_MeasureLength(p_measure_dim In Integer default null)
             Return Number Deterministic

INPUTS

    p_measure_dim (NUMBER) - LRS Dimension ie 3 or 4 (3302/4402).
    p_unit      (VARCHAR2) - Oracle Unit of Measure eg unit=M.

DESCRIPTION

    This function computes length by subtracting end and start measure ordinates.
    If parameter p_measure_dim is NULL the function uses the value of SELF.ST_LRS_Dim()

RESULT

    distance (Number) -- Difference between end and start measure ordinates (delta).

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_Parallel (1.0) [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Parallel -- Moves vector parallel to imaginary line drawn from first to last vertex.

SYNOPSIS

    Member Function ST_Parallel(p_distance in number)
             Return &INSTALL_SCHEMA..T_GEOMETRY deterministic

DESCRIPTION

    Function that extracts the first and last vertex of a vector, 
    computes a single offset at right angles to an imaginary line from first to last vertex, 
    then applies offset to vector.

INPUTS

    p_distance (NUMBER)   - Value +/- integer value.

TODO

    Add support for SRID units of measure (ie parameter p_unit).

RESULT

    New vector (T_VECTOR) -- Input vector moved parallel by p_distance units

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - December 2008 - Original coding in GEOM package.
    Simon Greener - January 2013  - Port/Rewrite to T_GEOMETRY object function member.
    Simon Greener - January 2014  - Port/Rewrite to T_VECTOR object function member.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
  LICENSE
    Creative Commons Attribution-Share Alike 2.5 Australia License.
    http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_RoundOrdinates [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_RoundOrdinates -- Rounds X,Y,Z and w ordinates of vector's coordinates to passed in precision.

SYNOPSIS

    Member Function ST_RoundOrdinates(p_dec_places_x in integer default 8,
                                      p_dec_places_y in integer default NULL,
                                      p_dec_places_z in integer default 3,
                                      p_dec_places_w in integer default 3)
             Return &INSTALL_SCHEMA..T_VECTOR Deterministic,

DESCRIPTION

    Applies relevant decimal digits of precision value to ordinate.
    For example:
      SELF.x := ROUND(SELF.x,p_dec_places_x);

INPUTS

    p_dec_places_x (integer) - value applied to x Ordinate.
    p_dec_places_y (integer) - value applied to y Ordinate.
    p_dec_places_z (integer) - value applied to z Ordinate.
    p_dec_places_w (integer) - value applied to w Ordinate.

RESULT

    vector (T_VECTOR)

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/ST_SRID [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_SRID -- Returns the object's SDO_SRID attribute value.

SYNOPSIS

    Member Function ST_SRID
             Return INTEGER Deterministic,

DESCRIPTION

    Returns sdo_srid object attribute.

RESULT

    spatial reference id (INTEGER) -- eg 8311 etc.

AUTHOR

    Simon Greener

HISTORY

    Simon Greener - Jan 2013 - Original coding.

COPYRIGHT

    (c) 2012-2017 by TheSpatialDBAdvisor/Simon Greener
  LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/

T_VECTOR/TYPE OBJECT VARIABLES [ Variables ]

[ Top ] [ Variables ]

NAME

    element_id    -- Top level part identifier of multi-part geometry
                     eg multi-linestring composed of two lines generates element_ids 1 and 2.
    subelement_id -- Part id of any sub-elements of a single geometry part
                     eg inner ring of a single polygon; circular curve of single linestring.
    vector_id     -- Id of vectors in sequential order appears in original geometry
    startCoord    -- Ordinates of start point
    midCoord      -- Ordinates of mid point of circular arc
    endCoord      -- Ordinates of end point
    sdo_gtype     -- Geometry Type of Vector
    sdo_srid      -- Spatial Reference ID of Vector

SOURCE

  element_id     integer,
  subelement_id  integer,
  vector_Id      Integer,
  startCoord     &INSTALL_SCHEMA..T_Vertex,
  midCoord       &INSTALL_SCHEMA..T_Vertex, /* If circular arc */
  endCoord       &INSTALL_SCHEMA..T_Vertex,
  sdo_gtype      integer,
  sdo_srid       integer,