1
2
3
4
5
6
7
8
9
|
FromGeoJSON - geometry collection, 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]},{"type":"Polygon","coordinates":[[[4,6],[7,10],[13,3],[4,6]]]},{"type":"LineString","coordinates":[[8,-2],[0.2,3.2]]},{"type":"Point","coordinates":[-4,2.4]},{"type":"Point","coordinates":[1,-4]},{"type":"LineString","coordinates":[[4,6],[1.2,4]]},{"type":"Polygon","coordinates":[[[1,0],[2,3],[4,3],[1,0]]]}]}'))
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]},{"type":"Polygon","coordinates":[[[4,6],[7,10],[13,3],[4,6]]]},{"type":"LineString","coordinates":[[8,-2],[0.2,3.2]]},{"type":"Point","coordinates":[-4,2.4]},{"type":"Point","coordinates":[1,-4]},{"type":"LineString","coordinates":[[4,6],[1.2,4]]},{"type":"Polygon","coordinates":[[[1,0],[2,3],[4,3],[1,0]]]}]}')):0
SRID=3003;GEOMETRYCOLLECTION(POINT(4 6),POINT(-4 2.4),POINT(1 -4),LINESTRING(8 -2,0.2 3.2),LINESTRING(4 6,1.2 4),POLYGON((4 6,7 10,13 3,4 6)),POLYGON((1 0,2 3,4 3,1 0)))
|
