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, requires libxml2 2.6+

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

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.2.3, “Build configuration”, ST_AsKML