Download IBM Informix Spatial DataBlade Module User's Guide

|
|
|
|
|
|
|
|
|
|
|
|
ST_MPointFromKML()
ST_MPointFromKML() takes a KML MultiGeometry and Point combination and
an optional spatial reference ID and returns a multipoint object. A Point string can
contain the elements of <coordinates>, <extrude>, <tessellate>, and
<altitudeMode>, but they are ignored.
Syntax
ST_MPointFromKML(kmlstring lvarchar)
ST_MPointFromKML(kmlstring lvarchar, SRID integer)
Return Type
ST_MultiPoint
Example
|
|
|
|
EXECUTE FUNCTION ST_MPointFromKML('<MultiGeometry><Point><coordinates>
-122.365662,37.826988, 0</coordinates></Point><Point>
<coordinates>-122.365038,37.82655,0</coordinates>
</Point></MultiGeometry>',4);
|
|
|
Output:
4 MULTIPOINT Z (-122.365662056 37.8269879529 0, -122.36503794
37.8265500822 0)
Chapter 8. SQL Functions
8-99