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