SDO_PC_PKG.GENERATE_CROSS_SECTION_AS

Format

SDO_PC_PKG.GENERATE_CROSS_SECTION_AS_GEOMS(
    pc_table             IN VARCHAR2,
    pc_column            IN VARCHAR2,
    id_column            IN VARCHAR2,
    id                   IN VARCHAR2,
    cross_section_line2d IN MDSYS.SDO_GEOMETRY,
    buffer               IN NUMBER,
    false_x              IN NUMBER,
    result_table_2d      IN VARCHAR2,
    result_table_2d_mp   IN VARCHAR2,
    result_table_3d      IN VARCHAR2
);

Description

Computes a cross section of a point cloud in 3D and on a vertical 2D plane.

Parameters

pc_table: Name of the table that has the SDO_POINT_CLOUD column and ID column defined.
pc_column: Column name of the SDO_POINT_CLOUD object in the table provided for pc_table parameter.
id_column: Column name for the ID column in the table provided for pc_table parameter.
id: ID value.
cross_section_line2d: A 2D line string, with only two vertices, representing a vertical cross section.
buffer: A buffer width in the unit of length of the SRID.
false_x: Value assigned to the starting point of the 2D cross section in the SRID of the 2D representation of the cross section.
result_table_2d: Output table name for the 2D representation of the point set.
result_table_2d_mp: Output table name for the 2D multipoint representation of the point set.
result_table_3d: Output table name for the 3D representation of the point set.

Usage Notes

The SDO_PC_PKG.GENERATE_CROSS_SECTION_AS_GEOMS procedure clips the input point cloud with the cross_section_line2d parameter string and projects the resulting point set onto a vertical plane. The following outputs are generated for the cross section:

A 2D point set on a vertical plane with columns VAL_Di for x, y. Note that the 2D point set has no explicit SRID as the coordinate reference system is understood to be the vertical plane.
Alternatively, a cross section may also be represented as a multipoint of the same 2D set on the plane as it tends to only involve limited number of points.
A 3D point set in the same coordinate reference system as the input point cloud. The 3D point set is stored in a simple table with columns VAL_Di for x, y, z.

Examples

The following example computes the cross section of a point cloud as shown:

CALL SDO_PC_PKG.generate_cross_section_as_geoms(
    pc_table             => 'PCS',
    pc_column            => 'PC',
    id_column            => 'ID',
    id                   => '12345',
    cross_section_line2d => mdsys.sdo_geometry(
                              2003,
                              27700,
                              null,
                              mdsys.sdo_elem_info_array(1, 2, 1),
                              mdsys.sdo_ordinate_array(
                                 1,  1,
                                10, 10)),
    buffer               => 0.5,
    false_x              => 100,
    result_table_2d      => 'CROSS_SECTION_2D',
    result_table_2d_mp   => 'CROSS_SECTION_2D_MP',
    result_table_3d      => 'CROSS_SECTION_3D');