1 2 3 4 5 6 7
|
InteriorRingN - POLGON ZM second interior
:memory: #use in-memory database
SELECT AsText(InteriorRingN(GeomFromText('POLYGONZM((0 0 0 1, 0 4 1 1, 4 4 2 1, 4 0 3 1, 0 0 0 1),(1 1 2 2, 1 3 2 2, 3 3 2 2, 3 1 2 2, 1 1 2 2),(2 2 1 3, 2 3 1 3, 3 3 1 3, 3 2 1 3, 2 2 1 3))'), 2));
1 # rows (not including the header row)
1 # columns
AsText(InteriorRingN(GeomFromText('POLYGONZM((0 0 0 1, 0 4 1 1, 4 4 2 1, 4 0 3 1, 0 0 0 1),(1 1 2 2, 1 3 2 2, 3 3 2 2, 3 1 2 2, 1 1 2 2),(2 2 1 3, 2 3 1 3, 3 3 1 3, 3 2 1 3, 2 2 1 3))'), 2))
LINESTRING ZM(2 2 1 3, 2 3 1 3, 3 3 1 3, 3 2 1 3, 2 2 1 3)
|