1
2
3
4
5
6
7
8
|
FromGeoJSON - geometry collectionz, SRID
:memory: #use in-memory database
SELECT AsEWkt(GeomFromGeoJSON('{"type":"GeometryCollection","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[4,3,13,10],"geometries":[{"type":"Point","coordinates":[4,6,0]},{"type":"Polygon","coordinates":[[[4,6,1],[7,10,1],[13,3,2],[4,6,1]]]}]}'))
1 # rows (not including the header row)
1 # columns
AsEWkt(GeomFromGeoJSON('{"type":"GeometryCollection","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[4,3,13,10],"geometries":[{"type":"Point","coordinates":[4,6,0]},{"type":"Polygon","coordinates":[[[4,6,1],[7,10,1],[13,3,2],[4,6,1]]]}]}')):0
SRID=3003;GEOMETRYCOLLECTION(POINT(4 6 0),POLYGON((4 6 1,7 10 1,13 3 2,4 6 1)))
|
