ST_GeomFromGeoJson
Signature
VARCHAR ST_GeomFromGeoJson(VARCHAR geojson);Description
Converts a geojson (more details here) representation of a geometry into a geometry object.
Both 2D and 3D Geometries are supported.
Examples
SELECT ST_GeomFromGeoJson('
{"type":"Point",
"coordinates":[1.0,2.0]}');
-- Answer: POINT (1 2)
SELECT ST_GeomFromGeoJson('
{"type":"LineString",
"coordinates":[[1,2], [3,4], [5,6]]}');
-- Answer: LINESTRING (1 2, 3 4, 5 6)
SELECT ST_GeomFromGeoJson('
{"type":"Polygon",
"coordinates":[[[1,2], [3,4], [5,6], [7,8], [1,2]]]}');
-- Answer: POLYGON ((1 2, 3 4, 5 6, 7 8, 1 2))