MariaDB starting with 10.2.4

ST_AsGeoJSON was added in MariaDB 10.2.4


ST_AsGeoJSON(g[, max_decimals[, options]])


Returns the given geometry g as a GeoJSON element. The optional max_decimals limits the maximum number of decimals displayed.

The optional options flag can be set to 1 to add a bounding box to the output.

Note that this function did not work correctly before MariaDB 10.2.8 - see MDEV-12181.


SELECT ST_AsGeoJSON(ST_GeomFromText('POINT(5.3 7.2)'));
| ST_AsGeoJSON(ST_GeomFromText('POINT(5.3 7.2)')) |
| {"type": "Point", "coordinates": [5.3, 7.2]}    |

See also


Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.