ST_AsGeoJSON(VARCHAR(128)) method

Returns a string representing a geometry in JSON format.

Syntax

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

Parameters

format – A string defining parameters controlling how the GeoJSON result is generated. If not specified, the default is 'GeoJSON'.

Returns

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

Examples

Example 1 – The following example returns the result {"type":"Point", "coordinates":[1,2]}.
```
SELECT NEW ST_Point( 1.0, 2.0, 3.0, 4.0, 4326 ).ST_AsGeoJSON()
```

Standards

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

Parent topic: ST_Geometry type

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com