1
2
3
4
5
6
7
|
ST_Split - Collection-Line (split)
:memory: #use in-memory database
SELECT AsText(ST_Split(GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 11, 10 11), POLYGON((0 1, 10 1, 10 10, 0 10, 0 1)))'), GeomFromText('LINESTRING(7 0, 7 20)')));
1 # rows (not including the header row)
1 # columns
AsText(ST_Split(GeomFromText('GEOMETRYCOLLECTION(LINESTRING(0 11, 10 11), POLYGON((0 1, 10 1, 10 10, 0 10, 0 1)))'), GeomFromText('LINESTRING(7 0, 7 20)')))
GEOMETRYCOLLECTION(LINESTRING(0 11, 7 11), LINESTRING(7 11, 10 11), POLYGON((0 1, 0 10, 7 10, 7 1, 0 1)), POLYGON((7 1, 7 10, 10 10, 10 1, 7 1)))
|
