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