Format
SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES(
pc IN SDO_PC,
sampling_resolution IN NUMBER,
elevations IN SDO_ORDINATE_ARRAY,
region IN SDO_GEOMETRY
) RETURN SDO_GEOMETRY_ARRAY;Description
Generates contour lines for a point cloud.
Parameters
Point cloud for which to generate contour lines.
A numeric value that determines the grid cell height and width in the coordinate reference system of the point cloud. The process of the contour generation is grid-based. The points within a grid cell get averaged. This means:
Two slightly different point clouds may result in the same contours, as long as the grid cells yield the same averages.
The number of vertices and smoothness of the contour lines is a direct function of the resolution.
An array of elevations for which contours should be generated.
A window (within the extent of the point cloud) further restricting the region within which the contour lines should be generated.
Usage Notes
This function returns an array of SDO_GEOMETRY contours. The sequence of contours within the array is the same as the sequence in the elevations input parameter. Each contour is a multiline string.
Contours enclosing higher elevations are oriented counterclockwise (like outer rings). Contours enclosing lower elevations are oriented clockwise (like inner rings).
Modeling Solids describes how to use point clouds to model solids.
Examples
The following example creates contour lines from a point cloud.
SELECT sdo_pc_pkg.create_contour_geometries( (SELECT pc FROM pcs WHERE pc_id = 1), sampling_resolution => 50, elevations => sdo_ordinate_array(100, 101), region => mdsys.sdo_geometry(2003, null, null, mdsys.sdo_elem_info_array(1, 1003, 3), mdsys.sdo_ordinate_array(-1000, 0, 999, 100))) FROM DUAL; SDO_PC_PKG.CREATE_CONTOUR_GEOMETRIES((SELECTPCFROMPCSWHEREPC_ID=1),SAMPLING_RESO -------------------------------------------------------------------------------- SDO_GEOMETRY_ARRAY(SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1, 5 , 2, 1), SDO_ORDINATE_ARRAY(-75.5, 24.5, -25.5, 74.5, 25.5, 74.5, 74.5, 25.5, 75 .5, 24.5)), SDO_GEOMETRY(2002, NULL, NULL, SDO_ELEM_INFO_ARRAY(1, 2, 1, 7, 2, 1) , SDO_ORDINATE_ARRAY(-76.5, 24.5, -75.5, 25.5, -26.5, 74.5, 26.5, 74.5, 74.5, 26 .5, 76.5, 24.5))) 1 row selected.