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