35.25 SDO_UTIL.GET_2D_FOOTPRINT
Format
SDO_UTIL.GET_2D_FOOTPRINT( geometry IN SDO_GEOMETRY, tolerance IN NUMBER DEFAULT 0.0000005 ) RETURN SDO_GEOMETRY;
Description
Returns a two-dimensional geometry that reflects the footprint of the input three-dimensional geometry.
Parameters
- geometry
-
Three-dimensional geometry object.
- tolerance
-
Tolerance value (see Tolerance).
Usage Notes
Note:
SDO_UTIL.GET_2D_FOOTPRINT function is not supported in Oracle Autonomous Database Serverless deployments.You can use this function to return the 2D (on an x-y plane where z=0) footprint of 3D geometries such as buildings.
Examples
The following example returns the 2D footprint of a 3D geometry. It assumes that a table named FTPTS exists with at least a numeric ID column and a column named GEOMETRY of type SDO_GEOMETRY containing three-dimensional geometries.
SELECT sdo_util.get_2d_footprint(geometry, 0.05) FROM ftpts WHERE id =1;
Parent topic: SDO_UTIL Package (Utility)