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 SE_EnvelopeAsKML() functionThe SE_EnvelopeAsKML() function takes a geometry value returned by ST_Envelope and returns it as a KML LatLonBox.

The SE_EnvelopeAsKML() function

The SE_EnvelopeAsKML() function takes a geometry value returned by ST_Envelope and returns it as a KML LatLonBox.

Syntax

SE_EnvelopeAsKML(p ST_Geometry)

Return type

ST_Geometry

Example

EXECUTE FUNCTION SE_EnvelopeAsKML(ST_PolyFromText(‘POLYGON 
                  ((-124.21160602 25.8373769872,
                  -67.1589579416 25.8373769872, 
                  -67.1589579416 49.384359066, 
                  -124.21160602 49.384359066, 
                  -124.21160602 25.8373769872))',3));

Output:

<LatLonBox>
           <north>49.384359066</north>
           <south>25.8373769872</south>
           <east>-67.1589579416</east>
           <west>-124.21160602</west>
</LatLonBox>