ST_GeomFromGeoJSON¶
TL;DR¶
ST_GeomFromGeoJSON parses a GeoJSON geometry object into GEOMETRY.
Syntax¶
ST_GeomFromGeoJSON(geojson)
ST_GeomFromGeoJSON(geojson, srid)
Arguments¶
geojson is a VARCHAR containing a GeoJSON geometry object. srid is an optional INT64 spatial reference identifier.
Return Value¶
Returns a GEOMETRY. The one-argument form assigns SRID 4326.
Usage Notes¶
Pass an explicit SRID to override the default. Invalid GeoJSON is rejected.
Examples¶
DROP DATABASE IF EXISTS geo_st_geomfromgeojson_demo;
CREATE DATABASE geo_st_geomfromgeojson_demo;
USE geo_st_geomfromgeojson_demo;
SELECT ST_AsText(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[3,4]}')) AS point_value;
SELECT ST_SRID(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[3,4]}')) AS default_srid;
SELECT ST_SRID(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[3,4]}', 0)) AS explicit_srid;
DROP DATABASE geo_st_geomfromgeojson_demo;