31.11 SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN
Format
SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN( ordinates2D SDO_ORDINATE_ARRAY, tin SDO_TIN ) RETURN SDO_ORDINATE_ARRAY;
Description
Projects two-dimensional points onto a TIN, thereby determining point heights.
Parameters
- ordinates2D
-
SDO_ORDINATE_ARRAY object with the two-dimensional points to be projected. These cannot be oriented points (which are described in Oriented Point).
- tin
-
SDO_TIN object onto which to project the points.
Usage Notes
This function can be thought of as performing height interpolation for the specified two-dimensional input points.
The SDO_TIN data type is described in TIN-Related Object Types.
Modeling Surfaces describes how to use TINs to model surfaces.
Examples
The following example projects two-dimensional points (2.3, 3.4), (4.5, 5.6), (6.7, 7.8) onto a TIN, yielding three-dimensional points (2.3, 3.4, 5.7), (4.5, 5.6, 10.1), (6.7, 7.8, 14.5). In this example, the TIN shape is an inclined surface with zi=xi+yi
.
SELECT sdo_tin_pkg.project_ordinates_onto_tin( ordinates2d => sdo_ordinate_array( 2.3, 3.4, 4.5, 5.6, 6.7, 7.8), tin => (select tin from tins where tin_id = 1)) FROM DUAL; SDO_TIN_PKG.PROJECT_ORDINATES_ONTO_TIN(ORDINATES2D=>SDO_ORDINATE_ARRAY(2.3,3.4,4 -------------------------------------------------------------------------------- SDO_ORDINATE_ARRAY(2.3, 3.4, 5.7, 4.5, 5.6, 10.1, 6.7, 7.8, 14.5) 1 row selected.
Parent topic: SDO_TIN_PKG Package (TINs)