SDO_GEOM.SDO_WIDTH_LINE
Note: This feature is available starting with Oracle Database 12c Release 1 (12.1.0.2).
Format
SDO_GEOM.SDO_WIDTH(_LINE
geom IN SDO_GEOMETRY,
dim IN SDO_DIM_ARRAY
) RETURN NUMBER;or
SDO_GEOM.SDO_WIDTH_LINE(
geom IN SDO_GEOMETRY,
tol IN NUMBER
) RETURN NUMBER;Description
Returns a line string geometry reflecting the width of a geometry object.
Parameters
geom
Geometry object.
dim
Dimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views (described in Geometry Metadata Views).
tol
Tolerance value (see Tolerance).
Usage Notes
For a convex polygon, the width is the minimum distance between parallel lines of support.
For a non-convex geometry, this function determines its convex geometry and returns the width of that convex geometry.
The input geometry can have no more than two dimensions.
If a point geometry is specified, the function returns 0 (zero).
Examples
The following example returns line strings reflecting width of each geometry object stored in the COLA_MARKETS table. (The example uses the definitions and data from Simple Example: Inserting_ Indexing_ and Querying Spatial Data.)
SELECT name, SDO_GEOM.SDO_WIDTH_LINE(shape, 0.005)
FROM cola_markets;
NAME
--------------------------------
SDO_GEOM.SDO_WIDTH_LINE(SHAPE,0.005)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y, Z), SD
--------------------------------------------------------------------------------
cola_a
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
5, 7, 1, 7))
cola_b
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
8, 7, 5, 7))
cola_c
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
3, 5, 3, 3))
cola_d
SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1), SDO_ORDINATE_ARRAY(
10, 11, 6, 11))