ST_AsKML
Name
ST_AsKML — Return the geometry as a KML element. Several variants. Default version=2, default maxdecimaldigits=15
Synopsis
text
ST_AsKML
(
geometry
geom
, integer
maxdecimaldigits=15
, text
nprefix=NULL
)
;
text
ST_AsKML
(
geography
geog
, integer
maxdecimaldigits=15
, text
nprefix=NULL
)
;
Description
Return the geometry as a Keyhole Markup Language (KML) element. There are several variants of this function. maximum number of decimal places used in output (defaults to 15), version default to 2 and default namespace is no prefix.
Version 1: ST_AsKML(geom_or_geog, maxdecimaldigits) / version=2 / maxdecimaldigits=15
Version 2: ST_AsKML(version, geom_or_geog, maxdecimaldigits, nprefix) maxdecimaldigits=15 / nprefix=NULL
![[Note]](images/note.png)
|
|
|
Requires PostGIS be compiled with Proj support. Use PostGIS_Full_Version to confirm you have proj support compiled in. |
|
|
|
|
Availability: 1.2.2 - later variants that include version param came in 1.3.2 |
|
|
|
|
Enhanced: 2.0.0 - Add prefix namespace. Default is no prefix |
|
|
|
|
Changed: 2.0.0 - uses default args and supports named args |
|
|
|
|
AsKML output will not work with geometries that do not have an SRID |
This function supports 3d and will not drop the z-index.
Examples
SELECT ST_AsKML(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));
st_askml
--------
<Polygon><outerBoundaryIs><LinearRing><coordinates>0,0 0,1 1,1 1,0 0,0</coordinates></LinearRing></outerBoundaryIs></Polygon>
--3d linestring
SELECT ST_AsKML('SRID=4326;LINESTRING(1 2 3, 4 5 6)');
<LineString><coordinates>1,2,3 4,5,6</coordinates></LineString>