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