ST_AsGeoJSON
MariaDB starting with 10.2.4
ST_AsGeoJSON was added in MariaDB 10.2.4
Syntax
ST_AsGeoJSON(g[, max_decimals[, options]])
Description
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.
Examples
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
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.