ST_GeomFromKML

ST_GeomFromKML
Prev	2. Geometry Constructors	Next

Name

ST_GeomFromKML — Constructs a geometric object given its KML representation

Synopsis

geometry ST_GeomFromKML(varchar KML);

Alias

GeomFromKML

Description

Constructs a geometric object given its KML representation


	ST_AsKML is the reverse of ST_GeomFromGML

Coordinate Dimensions

2D	3D	M
		-

Spatial Standards Support

OGC SFS for SQL. 1.1 (1999)	OGC SFS for SQL. 1.1.0 (2005)	OGC SFS for SQL. 1.2.0 (2006)	SQL-MM Part 3
-	-	-	-

Examples

SELECT ST_GeomFromKML('
<kml:Polygon xmlns:kml="http://earth.google.com/kml/2.1">
    <kml:outerBoundaryIs>
        <kml:LinearRing>
            <kml:coordinates>
-5.850379847879675,43.35970362178223 
-5.848336797975651,43.36161117272741 
-5.850411866073801,43.36311451294508 
-5.853216861450062,43.36175621008758 
-5.850379847879675,43.35970362178223

            </kml:coordinates>
        </kml:LinearRing>
    </kml:outerBoundaryIs>
</kml:Polygon>
');

Related functions

ST_AsKML