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