1 2 3 4 5 6 7
|
shared paths - two polygonZM, internal ring
:memory: #use in-memory database
SELECT AsText(SharedPaths(GeomFromText('POLYGONZM((0 0 2 4, 10 0 12 4, 10 10 12 4, 0 10 2 4, 0 0 2 4),(1 1 3 5, 3 1 5 5, 3 3 5 5, 1 3 3 5, 1 1 3 5))'),GeomFromText('POLYGONZM((5 0 7 4, 15 0 17 4, 15 10 17 4, 5 10 7 4, 5 0 7 4))')))
1 # rows (not including the header row)
1 # columns
AsText(SharedPaths(GeomFromText('POLYGONZM((0 0 2 4, 10 0 12 4, 10 10 12 4, 0 10 2 4, 0 0 2 4),(1 1 3 5, 3 1 5 5, 3 3 5 5, 1 3 3 5, 1 1 3 5))'),GeomFromText('POLYGONZM((5 0 7 4, 15 0 17 4, 15 10 17 4, 5 10 7 4, 5 0 7 4))')))
MULTILINESTRING ZM((5 0 7 0, 10 0 12 0), (10 10 12 0, 5 10 7 0))
|