Home
Extending HCL OneDB™Beyond standard relational database objects, HCL OneDB™ can be extended to handle specialized data types, access methods, routines, and other objects. HCL OneDB™ includes many built-in extensions that are fully integrated in the database server. HCL OneDB™ also provides DataBlade® modules, which are packages of extended database objects for a particular purpose and that are installed separately from the database server. Alternatively, you can create your own user-defined objects for HCL OneDB™.
HCL OneDB™ extensions and DataBlade® modulesThese topics describe how to use built-in database extensions and separately installed DataBlade® modules.
Spatial Data User's GuideThe HCL OneDB™ Spatial Data User's Guide contains information to assist you in using the HCL® OneDB® spatial extension. The HCL® OneDB® spatial extension adds custom data types and supporting routines to the server.
Spatial functionsUse specific spatial data type functions to perform operations on spatial data.
The ST_EnvelopeFromGML() functionThe ST_EnvelopeFromGML() function takes a GML2 or GML3 string representation of an envelope and an optional spatial reference ID and returns a geometry object.

The ST_EnvelopeFromGML() function

The ST_EnvelopeFromGML() function takes a GML2 or GML3 string representation of an envelope and an optional spatial reference ID and returns a geometry object.

If the srsName attribute is specified in the GML string, then a corresponding entry in the spatial_references table must exist unless it is specified as UNKNOWN or DEFAULT.

Syntax

ST_EnvelopeFromGML(gml_string lvarchar) 
ST_EnvelopeFromGML(gml_string lvarchar, SRID integer)

Return type

A four sided ST_Polygon representing the envelope.

Example

ST_EnvelopeFromGML('<gml:Envelope>
    <gml:lowerCorner> -180.0 -90.0</gml:lowerCorner>
    <gml:upperCorner> 180.0 90.0 </gml:upperCorner>
</gml:Envelope>', 1003)