21.3 SDO_AGGR_CONCAVEHULL
Format
SDO_AGGR_CONCAVEHULL( AggregateGeometry SDOAGGRTYPE ) RETURN SDO_GEOMETRY;
Description
Returns a geometry object that is the concave hull of the specified geometry objects.
Parameters
- AggregateGeometry
-
An object of type SDOAGGRTYPE (see SDOAGGRTYPE Object Type) that specifies the geometry column and dimensional array.
Usage Notes
See also the information about the SDO_GEOM.SDO_CONCAVEHULL function in SDO_GEOM Package (Geometry).
Examples
The following example returns the concave hull of the geometry objects in the COLA_MARKETS table. (The example uses the definitions and data from Simple Example: Inserting_ Indexing_ and Querying Spatial Data.)
SELECT SDO_AGGR_CONCAVEHULL(SDOAGGRTYPE(shape, 0.005)) FROM cola_markets; SDO_AGGR_CONCAVEHULL(SDOAGGRTYPE(SHAPE,0.005))(SDO_GTYPE, SDO_SRID, SDO_POINT(X, -------------------------------------------------------------------------------- SDO_GEOMETRY(2003, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 1003, 1), SDO_ORDINATE_ARR AY(3, 3, 5, 1, 8, 1, 10, 1, 12, 1, 14, 1, 14, 5, 13, 9, 14, 10, 14, 13, 12, 15, 10, 14, 10, 13, 8, 11, 6, 12, 5, 13, 2, 11, 6, 10, 6, 9, 5, 7, 4, 5, 2, 4, 3, 3) )
Parent topic: Spatial Aggregate Functions