1
2
3
4
5
6
7
|
reverse - GeometryCollection XYZM
:memory: #use in-memory database
SELECT AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTIONZM(POINTZM(1 2 100 10), LINESTRINGZM(3 4 101 10, 5 6 102 11, 7 8 103 13, 9 9 19 13), POLYGONZM((10 10 101 11, 15 10 102 13, 13 13 103 13, 10 10 101 11), (11 10.5 100 10, 13 10.5 101 11, 13 11.3 102 13, 11 10.5 100 10)), POLYGONZM((20 20 100 10, 27 20 101 11, 22 18 102 13, 20 20 100 10), (21 19.5 101 11, 27 19.5 102 13, 22 18.5 103 13, 21 19.5 101 11)))', 4326)));
1 # rows (not including the header row)
1 # columns
AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTIONZM(POINTZM(1 2 100 10), LINESTRINGZM(3 4 101 10, 5 6 102 11, 7 8 103 13, 9 9 19 13), POLYGONZM((10 10 101 11, 15 10 102 13, 13 13 103 13, 10 10 101 11), (11 10.5 100 10, 13 10.5 101 11, 13 11.3 102 13, 11 10.5 100 10)), POLYGONZM((20 20 100 10, 27 20 101 11, 22 18 102 13, 20 20 100 10), (21 19.5 101 11, 27 19.5 102 13, 22 18.5 103 13, 21 19.5 101 11)))', 4326)))
SRID=4326;GEOMETRYCOLLECTION(POINT(1 2 100 10),LINESTRING(9 9 19 13,7 8 103 13,5 6 102 11,3 4 101 10),POLYGON((10 10 101 11,13 13 103 13,15 10 102 13,10 10 101 11),(11 10.5 100 10,13 11.3 102 13,13 10.5 101 11,11 10.5 100 10)),POLYGON((20 20 100 10,22 18 102 13,27 20 101 11,20 20 100 10),(21 19.5 101 11,22 18.5 103 13,27 19.5 102 13,21 19.5 101 11)))
|
