File: reverse4.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (7 lines) | stat: -rw-r--r-- 1,110 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
 
reverse - GeometryCollection XYZ
:memory: #use in-memory database
SELECT AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTIONZ(POINTZ(1 2 100), LINESTRINGZ(3 4 101, 5 6 102, 7 8 103, 9 9 19), POLYGONZ((10 10 101, 15 10 102, 13 13 103, 10 10 101), (11 10.5 100, 13 10.5 101, 13 11.3 102, 11 10.5 100)), POLYGONZ((20 20 100, 27 20 101, 22 18 102, 20 20 100), (21 19.5 101, 27 19.5 102, 22 18.5 103, 21 19.5 101)))', 4326)));
1 # rows (not including the header row)
1 # columns
AsEWKT(ST_Reverse(GeomFromText('GEOMETRYCOLLECTIONZ(POINTZ(1 2 100), LINESTRINGZ(3 4 101, 5 6 102, 7 8 103, 9 9 19), POLYGONZ((10 10 101, 15 10 102, 13 13 103, 10 10 101), (11 10.5 100, 13 10.5 101, 13 11.3 102, 11 10.5 100)), POLYGONZ((20 20 100, 27 20 101, 22 18 102, 20 20 100), (21 19.5 101, 27 19.5 102, 22 18.5 103, 21 19.5 101)))', 4326)))
SRID=4326;GEOMETRYCOLLECTION(POINT(1 2 100),LINESTRING(9 9 19,7 8 103,5 6 102,3 4 101),POLYGON((10 10 101,13 13 103,15 10 102,10 10 101),(11 10.5 100,13 11.3 102,13 10.5 101,11 10.5 100)),POLYGON((20 20 100,22 18 102,27 20 101,20 20 100),(21 19.5 101,22 18.5 103,27 19.5 102,21 19.5 101)))