31 SDO_UTIL Package (Utility)

This chapter contains descriptions of the spatial utility subprograms shown in Table 31-1.

Table 31-1 Spatial Utility Subprograms

Subprogram	Description
SDO_UTIL.AFFINETRANSFORMS	Returns a geometry that reflects an affine transformation of the input geometry.
SDO_UTIL.APPEND	Appends one geometry to another geometry to create a new geometry.
SDO_UTIL.BEARING_TILT_FOR_POINTS	Computes the bearing and tilt from a start point to an end point.
SDO_UTIL.CIRCLE_POLYGON	Returns the polygon geometry that approximates and is covered by a specified circle.
SDO_UTIL.CONCAT_LINES	Concatenates two line or multiline two-dimensional geometries to create a new geometry.
SDO_UTIL.CONVERT_UNIT	Converts values from one angle, area, or distance unit of measure to another.
SDO_UTIL.CONVERT3007TO3008	Converts an input three-dimensional multisurface geometry (SDO_GTYPE 3007) to a simple solid geometry (SDO_GTYPE 3008).
SDO_UTIL.ELLIPSE_POLYGON	Returns the polygon geometry that approximates and is covered by a specified ellipse.
SDO_UTIL.EXTRACT	Returns the two-dimensional geometry that represents a specified element (and optionally a ring) of the input two-dimensional geometry.
SDO_UTIL.EXTRACT_ALL	Returns all elements and subelements of the input two-dimensional geometry, as an array of one or more geometries.
SDO_UTIL.EXTRACT3D	Returns the three-dimensional geometry that represents a specified subset of the input three-dimensional geometry.
SDO_UTIL.EXTRUDE	Returns the three-dimensional extrusion solid geometry from an input two-dimensional polygon geometry.
SDO_UTIL.FROM_GML311GEOMETRY	Converts a geography markup language (GML 3.1.1) fragment to a Spatial and Graph geometry object.
SDO_UTIL.FROM_GMLGEOMETRY	Converts a geography markup language (GML 2.0) fragment to a Spatial and Graph geometry object.
SDO_UTIL.FROM_WKBGEOMETRY	Converts a geometry in the well-known binary (WKB) format to a Spatial and Graph geometry object.
SDO_UTIL.FROM_WKTGEOMETRY	Converts a geometry in the well-known text (WKT) format to a Spatial and Graph geometry object.
SDO_UTIL.GET_2D_FOOTPRINT	Returns a two-dimensional geometry that reflects the footprint of the input three-dimensional geometry.
SDO_UTIL.GETNUMELEM	Returns the number of elements in the input geometry.
SDO_UTIL.GETNUMVERTICES	Returns the number of vertices in the input geometry.
SDO_UTIL.GETNURBSAPPROX	Returns a line string geometry that is an approximation of the input NURBS curve geometry.
SDO_UTIL.GETVERTICES	Returns the coordinates of the vertices of the input geometry.
SDO_UTIL.INITIALIZE_INDEXES_FOR_TTS	Initializes all spatial indexes in a tablespace that was transported to another database.
SDO_UTIL.POINT_AT_BEARING	Returns a point geometry that is at the specified distance and bearing from the start point.
SDO_UTIL.POLYGONTOLINE	Converts all polygon-type elements in a geometry to line-type elements, and sets the SDO_GTYPE value accordingly.
SDO_UTIL.RECTIFY_GEOMETRY	Fixes certain problems with the input geometry, and returns a valid geometry.
SDO_UTIL.REMOVE_DUPLICATE_VERTICES	Removes duplicate (redundant) vertices from a geometry.
SDO_UTIL.REVERSE_LINESTRING	Returns a line string geometry with the vertices of the input geometry in reverse order.
SDO_UTIL.SIMPLIFY	Simplifies the input geometry, based on a threshold value, using the Douglas-Peucker algorithm.
SDO_UTIL.SIMPLIFYVW	Simplifies the input geometry, based on a threshold value, using the Visvalingham-Whyatt algorithm.
SDO_UTIL.THEME3D_GET_BLOCK_TABLE	Simplifies the input geometry, based on a threshold value, using the Visvalingham-Whyatt algorithm.
SDO_UTIL.THEME3D_HAS_LOD	Simplifies the input geometry, based on a threshold value, using the Visvalingham-Whyatt algorithm.
SDO_UTIL.THEME3D_HAS_TEXTURE	Simplifies the input geometry, based on a threshold value, using the Visvalingham-Whyatt algorithm.
SDO_UTIL.TO_GML311GEOMETRY	Converts a Spatial and Graph geometry object to a geography markup language (GML 3.1.1) fragment based on the geometry types defined in the Open GIS `geometry.xsd` schema document.
SDO_UTIL.TO_GMLGEOMETRY	Converts a Spatial and Graph geometry object to a geography markup language (GML 2.0) fragment based on the geometry types defined in the Open GIS `geometry.xsd` schema document.
SDO_UTIL.TO_WKBGEOMETRY	Converts a Spatial and Graph geometry object to the well-known binary (WKB) format.
SDO_UTIL.TO_WKTGEOMETRY	Converts a Spatial and Graph geometry object to the well-known text (WKT) format.
SDO_UTIL.VALIDATE_3DTHEME	Validates a 3D theme.
SDO_UTIL.VALIDATE_SCENE	Validates a 3D scene.
SDO_UTIL.VALIDATE_VIEWFRAME	Validates a 3D viewframe.
SDO_UTIL.VALIDATE_WKBGEOMETRY	Validates the input geometry, which is in the standard well-known binary (WKB) format; returns the string `TRUE` if the geometry is valid or `FALSE` if the geometry is not valid.
SDO_UTIL.VALIDATE_WKTGEOMETRY	Validates the input geometry, which is of type CLOB or VARCHAR2 and in the standard well-known text (WKT) format; returns the string `TRUE` if the geometry is valid or `FALSE` if the geometry is not valid.