1 2 3 4 5 6 7
|
ST_ConcaveHull XYM - no_holes
:memory: #use in-memory database
SELECT ST_Equals(ST_ConcaveHull(GeomFromText('MULTIPOINTM(10 10 100, 10 12 100, 10 14 100, 10 16 100, 10 18 100, 10 20 100, 12 10 100, 12 12 100, 12 14 100, 12 16 100, 12 18 100, 12 20 100, 14 10 100, 14 12 100, 14 14 100, 14 18 100, 14 20 100, 17 10 100, 17 12 100, 17 14 100, 17 16 100, 17 18 100, 17 20 100, 16 10 100, 16 12 100, 16 14 100, 16 16 100, 16 18 100, 16 20 100, 18 10 100, 18 20 100, 20 10 100, 20 20 100)')), GeomFromText('POLYGON M((12 10 0, 10 10 0, 10 12 0, 10 14 0, 10 16 0, 10 18 0, 10 20 0, 12 20 0, 14 20 0, 16 20 0, 17 20 0, 18 20 0, 17 18 0, 17 16 0, 17 14 0, 17 12 0, 18 10 0, 17 10 0, 16 10 0, 14 10 0, 12 10 0))'));
1 # rows (not including the header row)
1 # columns
ST_Equals(ST_ConcaveHull(GeomFromText('MULTIPOINTM(10 10 100, 10 12 100, 10 14 100, 10 16 100, 10 18 100, 10 20 100, 12 10 100, 12 12 100, 12 14 100, 12 16 100, 12 18 100, 12 20 100, 14 10 100, 14 12 100, 14 14 100, 14 18 100, 14 20 100, 17 10 100, 17 12 100, 17 14 100, 17 16 100, 17 18 100, 17 20 100, 16 10 100, 16 12 100, 16 14 100, 16 16 100, 16 18 100, 16 20 100, 18 10 100, 18 20 100, 20 10 100, 20 20 100)')), GeomFromText('POLYGON M((12 10 0, 10 10 0, 10 12 0, 10 14 0, 10 16 0, 10 18 0, 10 20 0, 12 20 0, 14 20 0, 16 20 0, 17 20 0, 18 20 0, 17 18 0, 17 16 0, 17 14 0, 17 12 0, 18 10 0, 17 10 0, 16 10 0, 14 10 0, 12 10 0))'))
1
|