|Functions / Geometry Constructor Functions|
Converts a string formatted in KML (Keyhole Markup Language) to a feature geometry, such as a Point, LineString, Polygon, MultiPoint, MultiLineString, MultiPolygon, or Geometry Collection. This function deals with the KML geometry fragment only and assumes it is in the OGC KML 2.2.0 syntax. FromKML() will not enforce the namespace to be in OGC KML 2.2.0 as long as the syntax is conformed to. The KML schema is located at http://schemas.opengis.net/kml/2.2.0/ogckml22.xsd.
An example of a KML string is:
str is a KML string
Returns a feature geometry from a KML-formatted string.
select Country from countries where FromKML('<Point xmlns="http://www.opengis.net/kml/2.2"><coordinates>-122.364167,37.824787,50</coordinates></Point>') Within obj