1
2
3
4
5
6
7
|
LinesCutAtNodes - closed linestringZM, nodes
:memory: #use in-memory database
SELECT AsText(LinesCutAtNodes(GeomFromText('LINESTRINGZM(0 0 1 4, 0 10 1 2, 10 10 1 6, 10 0 1 3, 0 0 1 4)'),GeomFromText('MULTIPOINTZM(0 10 1 2, 10 10 1 6)')))
1 # rows (not including the header row)
1 # columns
AsText(LinesCutAtNodes(GeomFromText('LINESTRINGZM(0 0 1 4, 0 10 1 2, 10 10 1 6, 10 0 1 3, 0 0 1 4)'),GeomFromText('MULTIPOINTZM(0 10 1 2, 10 10 1 6)')))
MULTILINESTRING ZM((10 10 1 6, 10 0 1 3, 0 0 1 4, 0 10 1 2), (0 10 1 2, 10 10 1 6))
|
