1
2
3
4
5
6
7
8
9
|
dissolve - POLYGON
:memory: #use in-memory database
SELECT AsText(DissolveSegments(geom)),AsText(DissolvePoints(geom)) from (SELECT GeomFromText('POLYGON((0 0,10 0,10 10,0 10,0 0),(1 1,2 2, 2 1, 1 1))') as geom) dummy;
1 # rows (not including the header row)
2 # columns
AsText(DissolveSegments(geom))
AsText(DissolvePoints(geom))
MULTILINESTRING((0 0, 10 0), (10 0, 10 10), (10 10, 0 10), (0 10, 0 0), (1 1, 2 2), (2 2, 2 1), (2 1, 1 1))
MULTIPOINT(0 0, 10 0, 10 10, 0 10, 0 0, 1 1, 2 2, 2 1, 1 1)
|
