|
If you have two drawings: Line and Point, this will do it: SELECT first(p) AS pointgeom, pid FROM ( SELECT distance(point.[Geom (I)],p) AS dist,p, point.id AS pid, lineid FROM point, (SELECT line.id AS lineID, p FROM line SPLIT BY Coords([Geom (I)]) AS p ) ORDER BY pid, dist ASC ) GROUP BY pid
|