Search Results clip_pc_flat
Overview
The MDSYS.SDO_PC_PKG package is an Oracle Spatial and Graph PL/SQL package that provides the primary programmatic interface for managing point cloud data within an Oracle database. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package is part of the underlying MDSYS schema shipped with the database tier and is not an EBS-owned object. It is classified under the ETRM documentation as an "OTHER" API, indicating that it is a database-supplied utility rather than a business-facing EBS module routine. The package enables storage, manipulation, and analysis of large volumes of point cloud data, which represents collections of three-dimensional coordinates typically produced by LiDAR, photogrammetry, or similar surveying technologies.
The package is documented as VALID and is referenced by SDO_TIN_PKG, reflecting its close relationship with the Triangular Irregular Network (TIN) functionality used in terrain modeling. Its presence in the EBS technology stack supports geospatial and asset-related use cases where three-dimensional spatial data must be processed alongside standard EBS transactions.
Key Procedures and Functions
The ETRM metadata identifies 25 documented procedures and functions. The most significant include:
- INIT — Initializes a point cloud object, preparing it for subsequent data ingestion or manipulation.
- CREATE_PC — Creates a point cloud entry in the spatial metadata catalog.
- ADD_TO_PC — Appends point data to an existing point cloud.
- HAS_PYRAMID / PRESERVES_LEVEL1 / CREATE_LIBLAS_PYRAMID — Manage and query the pyramid (hierarchical level-of-detail) structures used to accelerate point cloud rendering and querying.
- CLIP_PC, CLIP_PC_FLAT, CLIP_PC_FLAT_STRING, CLIP_PCATTRS, CLIP_PC_PTIDS, CLIP_PC_INTO_TIN — A family of clipping operations that extract subsets of point cloud data against spatial boundaries, supporting geometric filtering and conversion into TIN surfaces.
- TIN_TO_PC — Converts a TIN structure into a point cloud representation.
- TO_GEOMETRY, GET_PT_IDS, GET_TILE_SQL — Support geometry conversion, point identifier retrieval, and tile-based query generation.
- DROP_DEPENDENCIES — Removes dependent objects associated with a point cloud.
- POPULATE_FROM_CLSTPCDATA, WRITE_CLSTPCDATA — Handle transfer of data to and from clustered point cloud data structures.
- CREATE_CONTOUR_GEOMETRIES — Derives contour geometry from point cloud or TIN data.
Tables Accessed
The package references several data dictionary views via APPS synonyms, including USER_CONSTRAINTS, USER_OBJECTS, USER_TAB_COLS, and USER_TAB_COLUMNS, which are used to validate object existence and metadata during point cloud operations. DUAL is used for single-row evaluation contexts, while DBMS_LOB, UTL_RAW, and PLITBLM support binary large object handling and raw data conversion required when storing and reading point cloud blocks. The package also depends on MDSYS spatial types such as SDO_GEOMETRY, SDO_PC, SDO_TIN, SDO_MBR, and associated array types.
Usage Notes
SDO_PC_PKG is typically invoked from custom PL/SQL code, spatial analysis scripts, or third-party geospatial applications integrated with the EBS database tier. It is not generally surfaced through standard EBS forms or concurrent programs, since it belongs to the database's spatial option rather than the EBS application schema. Administrators and developers working with spatial data in an EBS 12.1.1 or 12.2.2 environment should confirm that the Oracle Spatial option is licensed and installed before relying on this package. Because the package is referenced by SDO_TIN_PKG, operations that convert between point clouds and TIN surfaces should account for both packages being available and valid.