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

The ST_LineFromKML() function

The ST_LineFromKML() function takes a KML LineString string and an optional spatial reference ID and returns a linestring object. A KML LineString string can contain the KML shape attributes <extrude>, <tessellate>, and <altitudeMode>, but they are ignored in the ST_LineString representation.

Syntax

ST_LineFromKML(kmlstring lvarchar)
ST_LineFromKML(kmlstring lvarchar, SRID integer)

Return type

ST_LineString

Example

EXECUTE FUNCTION ST_LineFromKML('<LineString><coordinates>-130.597293,50.678292,
                          0 -129.733457,50.190606,0 -130.509877,49.387208,
                          0 -128.801553,48.669761,0 -129.156745,47.858658,
                         0 -128.717835,47.739997,0</coordinates></LineString>',4);

Output:

(expression)  4 LINESTRING Z (-130.597292947 50.6782919759 0, -129.733456972 
50.1906059982 0, -130.509877068 49.3872080751 0, -128.801553066 48.669761042 0, 
-129.156744951 47.8586579701 0, -128.717834948 47.7399970362 0)