Name
ST_GeomFromKML — Takes as input KML representation of geometry and outputs a PostGIS geometry object
Synopsis
geometry
ST_GeomFromKML
(
text
geomkml
)
;
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:
-
KML 2.2.0 Namespace
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.
![[Note]](./images/note.png)
|
|
|
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>
$$);