1
2
3
4
5
6
7
|
SnapAndSplit, INT Tolerance
:memory: #use in-memory database
SELECT AsText(SnapAndSplit(GeomFromText('LINESTRING(0 0, 10 0, 10 10, 0 10, 0 0)', 4326), GeomFromText('MULTIPOINT(5 0, 10 5, 5 10, 0 5)', 4326), 0));
1 # rows (not including the header row)
1 # columns
AsText(SnapAndSplit(GeomFromText('LINESTRING(0 0, 10 0, 10 10, 0 10, 0 0)', 4326), GeomFromText('MULTIPOINT(5 0, 10 5, 5 10, 0 5)', 4326), 0))
MULTILINESTRING((0 5, 0 0), (0 0, 5 0), (5 0, 10 0, 10 5), (10 5, 10 10, 5 10), (5 10, 0 10, 0 5))
|
