1
2
3
4
5
6
7
|
FromGeoJSON - polygon with SRID and bbox
:memory: #use in-memory database
SELECT AsEWkt(GeomFromGeoJSON('{"type":"Polygon","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[1,2,4,9],"coordinates":[[[1,2.3],[4,1.2],[2,1.6],[1,2.3]],[[1.5,2],[3.5,9],[2.5,1],[1.5,2]]]}'));
1 # rows (not including the header row)
1 # columns
AsEWkt(GeomFromGeoJSON('{"type":"Polygon","crs":{"type":"name","properties":{"name":"EPSG:3003"}},"bbox":[1,2,4,9],"coordinates":[[[1,2.3],[4,1.2],[2,1.6],[1,2.3]],[[1.5,2],[3.5,9],[2.5,1],[1.5,2]]]}')):0
SRID=3003;POLYGON((1 2.3,4 1.2,2 1.6,1 2.3),(1.5 2,3.5 9,2.5 1,1.5 2))
|
