ST_AsXML(VARCHAR(128)) method

Syntax

geometry-expression.ST_AsXML(VARCHAR(128) format)

format – A string defining the output text format to use when converting the geometry-expression to an XML representation. If not specified, the st_geometry_asxml_format option is used to choose the XML representation. Seest_geometry_asxml_format option.

LONG VARCHAR Returns the XML representation of the geometry-expression.

Example 1 – If the st_geometry_asxml_format option has its default value of 'GML', then the following returns the result <Point srsName="EPSG:4326"><pos>1 2 3 4</pos></Point>.
```
SELECT NEW ST_Point( 1.0, 2.0, 3.0, 4.0, 4326 ).ST_AsXML()
```
If the st_geometry_asxml_format option has its default value of 'GML', then the following returns the result <Point srsName="EPSG:4326"><pos>1 2 3 4</pos></Point>.
```
SELECT CAST( NEW ST_Point( 1.0, 2.0, 3.0, 4.0, 4326 ) AS XML)
```
The following example returns the result <Point srsName="EPSG:4326"><coordinates>1,2</coordinates></Point>.
```
SELECT NEW ST_Point( 1.0, 2.0, 3.0, 4.0, 4326 ).ST_AsXML('GML(Version=2)')
```
The following returns a complete SVG document with polygons filled with random colors.
```
SELECT NEW ST_Polygon( 'Polygon(( 0 0, 0 20, 60 10, 0 0 ))' )
.ST_AsXML( 'SVG' )
```

SQL/MM (ISO/IEC 13249-3: 2006) Vendor extension