I search top know the shortest line path beetwwen a shape and a point !!
in the mxb area and point are in the same row
it is a bit like https://stackoverflow.com/questions/28002162/closest-distance-to-border-of-shape but for point locate out of the shape !!!
A) so because relative to distance i search for distance in query builder and i find GeomDistance
In this context what mean the euclidean distance ?
GeomDistance(<geom>, <geom>, <tolerance>) : <value>
Takes two geoms and returns the Euclidean distance between the geoms, reported in whatever units are used for the geoms. The geoms are assumed to be in the same coordinate system. A tolerance of zero means automatic tolerance.
B) in a way i want to find the coordinate point locate in the edge of the geom and store it in another geom column ( not create in the mxb, need to goto schema ... ) . I don't know if the enclose circle can be usefull for compute this !!!
C) any clue about he best way to achieve this ? i think we need to compute for each point in the geom the distance and take the short value and id 2 short value appear then the shortest is the point locate in the midlle of this 2 points !! right ?
using implicit loop The logic seem to be
1) convert shape to point coordinate
2) for each point compute distance beetween the 2 points
3) take the min value and be shure it is unique
4) if not unique no answer stop
D) Does the result could be achieve using SQL only ?