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_PointFromKML() function

The ST_PointFromKML() function

The ST_PointFromKML() function takes a KML Point string and an optional spatial reference ID and returns a point object. A Point string can contain the elements of <coordinates>, <extrude>, <tessellate>, and <altitudeMode>.

Syntax

ST_PointFromKML(kmlstring lvarchar)
ST_PointFromKML(kmlstring lvarchar, SRID integer)

Return type

ST_Point

Example

EXECUTE FUNCTION ST_PointFromKML('<Point><coordinates>-122.44255879,37.80666418
                </coordinates></Point>',3);

Output:

   3 POINT (-122.44255879 37.80666418)