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
SDO_ORDINATE_ARRAY object with the two-dimensional points to be projected. These cannot be oriented points (which are described in Oriented Point).
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.