FromKML

Description

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:

<Point xmlns="http://www.opengis.net/kml/2.2"><coordinates>-75.65075,45.3742219</coordinates></Point>

Syntax

FromKML (str)

Arguments

str is a KML string

Example

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