PostGIS :: Tecnisys Docs

ST_AsKML
Prev	8.9.3. Other Formats	Next

Name

ST_AsKML — Return the geometry as a KML element.

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. default maximum number of decimal places is 15, default namespace is no prefix.

Using the `maxdecimaldigits` parameter can cause output geometry to become invalid. To avoid this use ST_ReducePrecision with a suitable gridsize first.

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

Note

Enhanced: 2.0.0 - Add prefix namespace, use default and named args

Note

Changed: 3.0.0 - Removed the "versioned" variant signature

Note

AsKML output will not work with geometries that do not have an SRID

check 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>

PostGIS

Name

Synopsis

Description

Examples

See Also