1
Closest Point - polygonZM with interior and Point
2
:memory: #use in-memory database
3
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))")))
4
1 # rows (not including the header row)
6
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))")))