1
2
3
4
5
6
7
|
IsPolygonCW - False Interior Ring
:memory: #use in-memory database
SELECT ST_IsPolygonCW(GeomFromText('GEOMETRYCOLLECTION ZM(POINT ZM(1 2 100 10),LINESTRING ZM(3 4 101 10,5 6 102 11,7 8 103 13,9 9 19 13),POLYGON ZM((10 10 101 11,13 13 103 13,15 10 102 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)),POLYGON ZM((20 20 100 10,24.1 20 101 11,22 18 102 13,20 20 100 10),(21 19.5 101 11,23.1 19.5 102 13,22 18.5 103 13,21 19.5 101 11)))'));
1 # rows (not including the header row)
1 # columns
ST_IsPolygonCW(GeomFromText('GEOMETRYCOLLECTION ZM(POINT ZM(1 2 100 10),LINESTRING ZM(3 4 101 10,5 6 102 11,7 8 103 13,9 9 19 13),POLYGON ZM((10 10 101 11,13 13 103 13,15 10 102 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)),POLYGON ZM((20 20 100 10,24.1 20 101 11,22 18 102 13,20 20 100 10),(21 19.5 101 11,23.1 19.5 102 13,22 18.5 103 13,21 19.5 101 11)))'));
0
|
