Description

Constructs a PostGIS geometry from an OGC KML representation.

ST_GeomFromKML works only for KML Geometry fragments. It throws an error if you try to use it on a whole KML document.

OGC KML versions supported:

OGC KML standards, cf: http://www.opengeospatial.org/standards/kml:

Availability: 1.5, requires libxml2 2.6+

This function supports 3d and will not drop the z-index.

	ST_GeomFromKML does not support SQL/MM curve geometries.

Examples

A single LineString geometry.

	SELECT ST_AsEWKT(ST_GeomFromKML($$
	    <LineString>
	        <coordinates>-71.1663, 42.2614
	            -71.1667, 42.2616</coordinates>
	    </LineString>
	$$));

	        

SRID=4326;LINESTRING(-71.1663 42.2614,-71.1667 42.2616)

Figure

See Also

Section 2.2.3, “Build configuration”, ST_AsKML