ST_GeomFromKML

Description

Constructs a PostGIS ST_Geometry object from the 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,libxml2 2.6+

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

	ST_GeomFromKML function not support SQL/MM curves geometries.

Examples - A single geometry with srsName

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

See Also

Section 2.4.1, “Configuration” , ST_AsKML