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
Three-dimensional geometry object.
Tolerance value (see Tolerance).
Usage Notes
You can use this function to return the 2D (on an x-y plane) 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;