1
2
3
4
5
6
7
|
RemoveRepeatedPoints Text tolerance
:memory: #use in-memory database
SELECT RemoveRepeatedPoints(GeomFromText('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(10 10, 40 40), POLYGON((50 50, 100 50, 100 100, 50 100, 50 50), (60 60, 80 60, 80 80, 60 80, 60 60)))', 4326), 'tolerance');
1 # rows (not including the header row)
1 # columns
RemoveRepeatedPoints(GeomFromText('GEOMETRYCOLLECTION(POINT(1 1), LINESTRING(10 10, 40 40), POLYGON((50 50, 100 50, 100 100, 50 100, 50 50), (60 60, 80 60, 80 80, 60 80, 60 60)))', 4326), 'tolerance')
(NULL)
|
