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

Note: This function is supported only for WGS 1984, EPSG:4326.

An example of a KML string is:

<Point xmlns=""><coordinates>-75.65075,45.3742219</coordinates></Point>


FromKML (str)


str is a KML string


Returns a feature geometry from a KML-formatted string.

select Country from countries where FromKML('<Point xmlns=""><coordinates>-122.364167,37.824787,50</coordinates></Point>') Within obj