T_VERTEX/CONSTRUCTORS [ Modules ]

[ Top ] [ Modules ]

NAME

    A collection of T_VERTEX Constructors.

SOURCE

  Constructor Function T_Vertex
       Return Self As Result,
  Constructor Function T_Vertex( p_vertex In &&INSTALL_SCHEMA..T_vertex )
       Return Self As Result,
  Constructor Function T_Vertex( p_point in mdsys.sdo_geometry )
       Return Self As Result,
  Constructor Function T_Vertex( p_sdo_gtype in integer,
                                 p_sdo_srid  in integer)
       Return Self as result,
  Constructor Function T_Vertex( p_x         In number,
                                 p_y         In number,
                                 p_id        In integer,
                                 p_sdo_gtype in integer,
                                 p_sdo_srid  in integer)
       Return Self As Result,

  Constructor Function T_Vertex( p_x         In number,
                                 p_y         In number,
                                 p_z         In number,
                                 p_w         In number,
                                 p_id        In integer,
                                 p_sdo_gtype in integer,
                                 p_sdo_srid  in integer)
       Return Self As Result,
  Constructor Function T_Vertex( p_vertex    In mdsys.vertex_type,
                                 p_sdo_gtype in integer default 2001,
                                 p_sdo_srid  in integer default null)
       Return Self As Result,
  Constructor Function T_Vertex( p_vertex    In mdsys.vertex_type,
                                 p_id        In integer,
                                 p_sdo_gtype in integer default 2001,
                                 p_sdo_srid  in integer default null)
       Return Self As Result,
  Constructor Function T_Vertex( p_point     in mdsys.sdo_point_type,
                                 p_sdo_gtype in integer default 2001,
                                 p_sdo_srid  in integer default null)
       Return Self as result,

T_VERTEX/Degrees [ Functions ]

[ Top ] [ Functions ]

NAME

    Degrees -- Converts input radians to whole circle bearing (0 North).

SYNOPSIS

    Static Function Degrees(p_radians in number) 
             Return Number deterministic

INPUTS

    p_radians (NUMBER) - Angle in radians (clockwise from north)

DESCRIPTION

    This function converts supplied radians value to whole circle bearing clockwise from 0 as North.

EXAMPLE

    SELECT Round(T_Vertex.Degrees(0.789491),4) as degrees 
      FROM dual;

       DEGREES
    ----------
       45.2345

RESULT

    degrees (NUMBER) - 0 to 360 degrees

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_VERTEX/INSPECTORS [ Methods ]

[ Top ] [ Methods ]

NAME

    A collection of T_VERTEX variable inspectors.

SOURCE

  Member Function ST_X  Return Number  Deterministic,
  Member Function ST_Y  Return Number  Deterministic,
  Member Function ST_Z  Return Number  Deterministic,
  Member Function ST_W  Return Number  Deterministic,
  Member Function ST_ID Return INTEGER Deterministic,

T_VERTEX/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_vertex in &&INSTALL_SCHEMA..T_Vertex)
             Return Number deterministic

INPUTS

    p_vertex (T_VERTEX) - 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 uses all ordinates: X, Y, Z and W.

EXAMPLE

    With vertices as (
    select 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) as vertex
      from dual
      connect by level < 10
    )
    select a.vertex.st_astext(2) as vertex
      from vertices a
      order by a.vertex;

    VERTEX
    -----------------------------------------
    T_Vertex(.33,.26,NULL,NULL,1,2001,NULL)
    T_Vertex(.85,.63,NULL,NULL,1,2001,NULL)
    T_Vertex(1.96,.16,NULL,NULL,1,2001,NULL)
    T_Vertex(2.02,3.45,NULL,NULL,1,2001,NULL)
    T_Vertex(2.39,1.16,NULL,NULL,1,2001,NULL)
    T_Vertex(2.64,2.15,NULL,NULL,1,2001,NULL)
    T_Vertex(4.5,4.47,NULL,NULL,1,2001,NULL)
    T_Vertex(4.9,3.72,NULL,NULL,1,2001,NULL)
    T_Vertex(6.78,2.54,NULL,NULL,1,2001,NULL)
    
     9 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-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_VERTEX/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_VERTEX.PI()
      FROM DUAL;

                               T_VERTEX.PI()
    ---------------------------------------
    3.1415926535897932384626433832795028842

RESULT

    PI (NUMBER) - eg 3.14....

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_VERTEX/Radians [ Functions ]

[ Top ] [ Functions ]

NAME

    Radians -- Converts input whole circle bearing (0 North) to radians.

SYNOPSIS

    Static Function Radians(p_radians in number) 
             Return Number deterministic

INPUTS

    p_degrees (NUMBER) - Angle in degrees,  clockwise from North.

DESCRIPTION

    This function converts supplied decimal degree value to radians. 

EXAMPLE

    SELECT Round(T_Vertex.Radians(45.2345),6) as radians 
      FROM dual;

       RADIANS
    ----------
       .789491

RESULT

    radians (NUMBER) - 0 to 2 x PI radians.

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_VERTEX/ST_AsText [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_AsText -- Returns text Description of Vertex 

SYNOPSIS

    Member Function ST_AsText(p_dec_places_x in integer default 8,
                              p_dec_places_y in integer default 8,
                              p_dec_places_z in integer default 3,
                              p_dec_places_w in integer default 3)
             Return Varchar2 Deterministic,

DESCRIPTION

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

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

    vertex (T_VERTEX) 

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_VERTEX/ST_Bearing [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Bearing -- Returns bearing from SELF to supplied T_Vertex. 

SYNOPSIS

    Member Function ST_Bearing(p_vertex in &&INSTALL_SCHEMA..T_Vertex)
             Return Number Deterministic

INPUTS

    p_vertex (T_VERTEX) - A Vertex to which a bearing is calculated. 

DESCRIPTION

    This function computes a bearing from the current object point (SELF) to the supplied T_Vertex.
    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-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_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/

T_VERTEX/ST_Distance [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_Distance -- Returns distance from current vertex (SELF) to supplied T_Vertex. 

SYNOPSIS

    Member Function ST_Distance(p_vertex    in &&INSTALL_SCHEMA..T_Vertex,
                                p_tolerance in number   default 0.05,
                                p_unit      in varchar2 default NULL)
             Return Number Deterministic

INPUTS

    p_vertex  (T_VERTEX) - A Vertex to which a bearing is calculated. 
    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 distance from the current object point (SELF) to the supplied T_Vertex.
    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-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_VERTEX/ST_Equals [ Methods ]

[ Top ] [ Methods ]

NAME

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

SYNOPSIS

    Member Function ST_Equals(p_vertex    in &&INSTALL_SCHEMA..T_Vertex,
                              p_precision in number default 3)
             Return Integer deterministic

INPUTS

    p_vertex (T_VERTEX) - Vertex that is to be compared to current object (SELF).
    p_round   (INTEGER) - Decimal digits of precision for all ordinates.

DESCRIPTION

    This function compares current object vertex (SELF) to supplied vertex (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.

RESULT

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

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_VERTEX/ST_FromBearingAndDistance [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_FromBearingAndDistance -- Returns new T_Vertex given bearing and distance.

SYNOPSIS

    Member Function ST_FromBearingAndDistance(p_bearing  in number,
                                              p_distance in number)
             Return &&INSTALL_SCHEMA..T_Vertex Deterministic

INPUTS

    p_bearing  (NUMBER) - A whole circle bearing in radians.
    p_distance (NUMBER) - Distance expressed in Oracle Unit of Measure eg METER.

DESCRIPTION

    This function computes a new T_VERTEX computed from current object point (SELF)
    the supplied bearing and distance.

RESULT

    vertexx (T_VERTEX) -- New vertex computed using bearing and distance from current object.

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_VERTEX/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-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_VERTEX/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-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_VERTEX/ST_isNull [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_isNull -- Checks if Vertex data exists or not.

SYNOPSIS

    Member Function ST_isNull 
             Return Integer Deterministic,

DESCRIPTION

    If vertex object data are not null returns 1(True) else 0 (False).

RESULT

    BOOLEAN (INTEGER) -- 1 if vertex has not 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_VERTEX/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-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_VERTEX/ST_RoundOrdinates [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_RoundOrdinates -- Rounds X,Y,Z and w ordinates to passed in precision.

SYNOPSIS

    Member Function ST_RoundOrdinates(p_dec_places_x in integer default 8,
                                      p_dec_places_y in integer default 8,
                                      p_dec_places_z in integer default 3,
                                      p_dec_places_w in integer default 3)
             Return &&INSTALL_SCHEMA..T_Vertex 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

    vertex (T_VERTEX) 

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_VERTEX/ST_SdoGeometry [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_SdoGeometry -- Returns Vertex as a suitably encoded MDSYS.SDO_GEOMETRY object.

INPUTS

    p_dims in integer default null - A dimension value that will override any internal dimension eg return 2D from a 3D vertex.

SYNOPSIS

    Member Function ST_SdoGeometry 
             Return MDSYS.SDO_POINT_TYPE Deterministic,

RESULT

    point (MDSYS.SDO_GEOMETRY) -- Type of Point geometry depends on what the vertex represents.

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/

DESCRIPTION

    The encoding of the returned SDO_GEOMETRY object depends on the dimension of the vertex.
    This can be best seen in the following piece of source code from the type body.

SOURCE

  --   v_dims integer := NVL(p_dims,SELF.ST_Dims());
  -- Begin
  --   If ( SELF.sdo_gtype is null ) Then
  --      Return null;
  --   ElsIf ( SELF.sdo_gtype = 2001 or v_dims = 2) Then
  --      Return mdsys.sdo_geometry(SELF.sdo_gtype,SELF.sdo_SRID,mdsys.sdo_point_type(self.x,self.y,NULL),null,null);
  --   ElsIf ( v_dims = 3 ) Then
  --      -- 3001, 3301, 4001, 4301 and 4401 all stop with Z. GetVertices places M in 4401 in Z spot not W
  --      Return mdsys.sdo_geometry(SELF.sdo_gtype,SELF.sdo_SRID,mdsys.sdo_point_type(self.x,self.y,self.z),null,null);
  --   ElsIf ( v_dims = 4 ) Then
  --      If ( SELF.ST_Dims() = 3 ) Then
  --         Return mdsys.sdo_geometry(SELF.sdo_gtype,SELF.sdo_SRID,mdsys.sdo_point_type(self.x,self.y,self.z),null,null);
  --      Else
  --         Return mdsys.sdo_geometry(SELF.sdo_gtype,SELF.sdo_SRID,NULL,mdsys.sdo_elem_info_array(1,1,1),mdsys.sdo_ordinate_array(self.x,self.y,self.z,self.w));
  --      End If;
  --   End If;

T_VERTEX/ST_SdoPointType [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_SdoPointType -- Returns vertex X,Y and Z ordinates as a MDSYS.SDO_POINT_TYPE object.

SYNOPSIS

    Member Function ST_SdoPointType 
             Return MDSYS.SDO_POINT_TYPE Deterministic,

DESCRIPTION

    Constructs a MDSYS.SDO_POINT_TYPE object from the X, Y and Z ordinate variables of the type and returns it.
    If Vertex is 2D Z value will be NULL; if vertex dimension is > 3 only the X Y and Z ordinates are returned.

RESULT

    vertex (MDSYS.SDO_POINT_TYPE) -- eg MDSYS.SDO_POINT_TYPE(SELF.ST_X,SELF.ST_Y,SELF.ST_Z);

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_VERTEX/ST_SubtendedAngle [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_SubtendedAngle -- Returns angle subtended by p_start_vertex/SELF/p_end_vertex

SYNOPSIS

    Member Function ST_SubtendedAngle(p_start_vertex in &&INSTALL_SCHEMA..T_Vertex,
                                      p_end_vertex   in &&INSTALL_SCHEMA..T_Vertex)
             Return Number deterministic

INPUTS

    p_start_vertex (T_VERTEX) - Vertex that defines first point in angle.
    p_end_vertex   (T_VERTEX) - Vertex that defines last  point in angle.

DESCRIPTION

    This function computes the angle subtended by the three points:
    p_start_vertex ---> SELF ---> p_end_vertex

RESULT

    angle (NUMBER) - Subtended angle in radians.

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_VERTEX/ST_VertexType [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_VertexType -- Returns vertex ordinates as a MDSYS.VERTEX_TYPE object.

SYNOPSIS

    Member Function ST_VertexType 
             Return MDSYS.VERTEX_TYPE Deterministic,

DESCRIPTION

    Constructs a MDSYS.VERTEX_TYPE object from the ordinate variables of the type and returns it.

RESULT

    vertex (MDSYS.VERTEX_TYPE) -- eg MDSYS.VERTEX_TYPE(x=>SELF.ST_X,y=>SELF.ST_Y,z=>SELF.ST_Z,w=>SELF.ST_W,id=>SELF.ST_Id);

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_VERTEX/ST_WithinTolerance [ Methods ]

[ Top ] [ Methods ]

NAME

    ST_WithinTolerance -- Discovers whether supplied vertex is within tolerance of current object vertex (SELF).

SYNOPSIS

    Member Function ST_WithinTolerance(p_vertex    in &&INSTALL_SCHEMA..T_Vertex,
                                       p_tolerance in number default 0.005)
             Return Integer deterministic

INPUTS

    p_vertex  (T_VERTEX) - Vertex that is to be compared to current object (SELF).
    p_tolerance (NUMBER) - sdo_tolerance for use with sdo_geom.sdo_distance.

DESCRIPTION

    This function calculates distance from current object vertex (SELF) to supplied vertex (p_vertex)
    If distance <= supplied tolerance the function returns 1 (true) otherwise 0 (false).
    p_start_vertex ---> SELF ---> p_end_vertex

RESULT

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

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_VERTEX/VARIABLES [ Variables ]

[ Top ] [ Variables ]

NAME

    X         -- X Ordinate
    Y         -- Y Ordinate
    Z         -- Z Ordinate
    W         -- W Ordinate (Normally Measure)
    ID        -- Identifier
    sdo_gtype -- Geometry Type of Vertex
    sdo_srid  -- Spatial Reference ID of Vertex

SOURCE

  x         number,
  y         number,
  z         number,
  w         number,
  id        integer,
  sdo_gtype integer,
  sdo_srid  integer,