1
2
3
4
5
6
7
|
shared paths - multiline, not quite matching
:memory: #use in-memory database
SELECT AsText(SharedPaths(GeomFromText('MULTILINESTRING((5 0, 15 0),(5 0, 5 5))'),GeomFromText('MULTILINESTRING((0 0, 4 0, 6 0, 10 0),(11 0, 5 0),(5 5, 5 1))')))
1 # rows (not including the header row)
1 # columns
AsText(SharedPaths(GeomFromText('MULTILINESTRING((5 0, 15 0),(5 0, 5 5))'),GeomFromText('MULTILINESTRING((0 0, 4 0, 6 0, 10 0),(11 0, 5 0),(5 5, 5 1))')))
MULTILINESTRING((5 0, 6 0, 10 0, 11 0), (5 1, 5 5))
|
