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

The ST_PolyFromKML() function

The ST_PolyFromKML() function takes a KML Polygon string representation and an optional spatial reference ID and returns a polygon object.

Syntax

ST_PolyFromKML(kmlstring lvarchar)
ST_PolyFromKML(kmlstring lvarchar, SRID integer)

Return type

ST_Polygon

Example

EXECUTE FUNCTION ST_PolyFromKML('<Polygon><outerBoundaryIs>
                 <LinearRing>
                 <coordinates>-122.365662,37.826988,0    
                 -122.365202,37.826302,0 -122.364581,37.82655,0
                 -122.365038,37.827237,0 -122.365662,37.826988,0 
                 </coordinates></LinearRing></outerBoundaryIs>
                 </Polygon>',4);

Output:

4 POLYGON Z ((-122.365662056 37.8269879529 0, -122.365202058 
              37.8263019779 0, -122.364580958 37.8265500822 0, 
              -122.36503794 37.827237063 0, -122.365662056 
              37.8269879529 0))