PostGIS
Name
ST_GeomFromGeoJSON — Takes as input a geojson representation of a geometry and outputs a PostGIS geometry object
Synopsis
geometry +`*`+ST_GeomFromGeoJSON*(`text `geomjson`)`;
geometry +`*`+ST_GeomFromGeoJSON*(`json `geomjson`)`;
geometry +`*`+ST_GeomFromGeoJSON*(`jsonb `geomjson`)`;
Description
Constructs a PostGIS geometry object from the GeoJSON representation.
ST_GeomFromGeoJSON works only for JSON Geometry fragments. It throws an error if you try to use it on a whole JSON document.
Enhanced: 3.0.0 parsed geometry defaults to SRID=4326 if not specified otherwise.
Enhanced: 2.5.0 can now accept json and jsonb as inputs.
Availability: 2.0.0 requires - JSON-C >= 0.9
|
This function
supports 3d and will not drop the z-index.
Examples
SELECT ST_AsText(ST_GeomFromGeoJSON('{"type":"Point","coordinates":[-48.23456,20.12345]}')) As wkt;
wkt
------
POINT(-48.23456 20.12345)-- a 3D linestring
SELECT ST_AsText(ST_GeomFromGeoJSON('{"type":"LineString","coordinates":[[1,2,3],[4,5,6],[7,8,9]]}')) As wkt;
wkt
-------------------
LINESTRING(1 2,4 5,7 8)