1
2
3
4
5
6
7
8
|
Closest Point - polygonZM with interior and Point
:memory: #use in-memory database
SELECT AsText(ClosestPoint(GeomFromText('POINTZM(4 6 1 3)'), GeomFromText('POLYGONZM((0 0 1 3, 10 0 2 3, 10 10 3 3, 0 10 2 3, 0 0 1 3),( 1 1 4 1, 3 1 5 1, 3 3 6 1, 1 3 5 2, 1 1 4 1))')))
1 # rows (not including the header row)
1 # columns
AsText(ClosestPoint(GeomFromText('POINTZM(4 6 1 3)'), GeomFromText('POLYGONZM((0 0 1 3, 10 0 2 3, 10 10 3 3, 0 10 2 3, 0 0 1 3),( 1 1 4 1, 3 1 5 1, 3 3 6 1, 1 3 5 2, 1 1 4 1))')))
POINT ZM(4 6 1 0)
|
