1
2
3
4
5
6
7
|
From GeoJSON - GeomColl Point-Linestring-Polygon bbox-coords-crs-type
:memory:
SELECT AsEWKT(GeomFromGeoJSON('{"bbox":[0,0,4,4],"geometries":[{"type":"Point","coordinates":[0,0]},{"type":"LineString","coordinates":[[1,1],[2,2]]},{"type":"Polygon","coordinates":[[[3,3],[3,4],[4,4],[4,3],[3,3]]]}],"crs":{"type":"name","properties":{"name":"EPSG:4326"}},"type":"GeometryCollection"}'));
1 # rows
1 # column
AsEWKT(GeomFromGeoJSON('{"bbox":[0,0,4,4],"geometries":[{"type":"Point","coordinates":[0,0]},{"type":"LineString","coordinates":[[1,1],[2,2]]},{"type":"Polygon","coordinates":[[[3,3],[3,4],[4,4],[4,3],[3,3]]]}],"crs":{"type":"name","properties":{"name":"EPSG:4326"}},"type":"GeometryCollection"}')):0
SRID=4326;GEOMETRYCOLLECTION(POINT(0 0),LINESTRING(1 1,2 2),POLYGON((3 3,3 4,4 4,4 3,3 3)))
|
