File: dissolve27.testcase

package info (click to toggle)
spatialite 5.1.0-3
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 74,240 kB
  • sloc: ansic: 587,051; makefile: 8,583; sh: 4,276; yacc: 1,973; xml: 717
file content (9 lines) | stat: -rw-r--r-- 1,032 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
 
dissolve - Overlap points POLYGON ZM
:memory: #use in-memory database
SELECT AsText(DissolveSegments(geom)),AsText(DissolvePoints(geom)) from (SELECT GeomFromText('POLYGONZM((-10 0 0 0, -10 10 0 0, -10 10 10 0, 10 10 10 0, 10 10 10 10, 10 10 10 -10, 10 -10 10 -10, -10 -10 -10 -10, -10 0 0 0),(0 1 0 2, 0 2 1 3, 1 2 2 4, 1 2 3 5, 1 2 3 6, 1 2 3 6, 0 1 0 2))') as geom) dummy;
1 # rows (not including the header row)
2 # columns
AsText(DissolveSegments(geom))
AsText(DissolvePoints(geom))
MULTILINESTRING ZM((-10 0 0 0, -10 10 0 0), (-10 10 0 0, -10 10 10 0), (-10 10 10 0, 10 10 10 0), (10 10 10 0, 10 10 10 10), (10 10 10 10, 10 10 10 -10), (10 10 10 -10, 10 -10 10 -10), (10 -10 10 -10, -10 -10 -10 -10), (-10 -10 -10 -10, -10 0 0 0), (0 1 0 2, 0 2 1 3), (0 2 1 3, 1 2 2 4), (1 2 2 4, 1 2 3 5), (1 2 3 5, 1 2 3 6), (1 2 3 6, 0 1 0 2))
MULTIPOINT ZM(-10 0 0 0, -10 10 0 0, -10 10 10 0, 10 10 10 0, 10 10 10 10, 10 10 10 -10, 10 -10 10 -10, -10 -10 -10 -10, -10 0 0 0, 0 1 0 2, 0 2 1 3, 1 2 2 4, 1 2 3 5, 1 2 3 6, 1 2 3 6, 0 1 0 2)