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_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/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-2016 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-2016 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,

T_VERTEX/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-2016 by TheSpatialDBAdvisor/Simon Greener
    LICENSE
      Creative Commons Attribution-Share Alike 2.5 Australia License.
      http://creativecommons.org/licenses/by-sa/2.5/au/