1 2 3 4 5 6 7 8 9
|
Sanitize Geometry - POLYGON ZM with interior
:memory: #use in-memory database
SELECT AsText(SanitizeGeometry(GeomFromText('POLYGONZM((-10 -10 1 0, -10 -10 1 0, 10 -10 2 2, 10 10 3 2, -10 10 4 2, -10 -10 1 2, -10 -10 1 0),(-6 -6 2 1, -6 -5 3 1, -5 -5 3 1, -5 -5 4 1, -5 -5 4 1, -5 -6 9 1, -6 -6 2 1),(6 6 0 1, 5 6 0 2, 5 6 0 1, 5 5 0 2, 6 5 0 1, 6 6 0 1))')))
1 # rows (not including the header row)
1 # columns
AsText(SanitizeGeometry(GeomFromText('POLYGONZM((-10 -10 1 0, -10 -10 1 0, 10 -10 2 2, 10 10 3 2, -10 10 4 2, -10 -10 1 2, -10 -10 1 0),(-6 -6 2 1, -6 -5 3 1, -5 -5 3 1, -5 -5 4 1, -5 -5 4 1, -5 -6 9 1, -6 -6 2 1),(6 6 0 1, 5 6 0 2, 5 6 0 1, 5 5 0 2, 6 5 0 1, 6 6 0 1))')))
POLYGON ZM((-10 -10 1 0, 10 -10 2 2, 10 10 3 2, -10 10 4 2, -10 -10 1 0), (-6 -6 2 1, -6 -5 3 1, -5 -5 3 1, -5 -5 4 1, -5 -6 9 1, -6 -6 2 1), (6 6 0 1, 5 6 0 2, 5 5 0 2, 6 5 0 1, 6 6 0 1))
|