gw1

DROP TABLE ws_migra.connec_to_link;
CREATE TABLE ws_migra.connec_to_link AS
SELECT connec_id, ST_ClosestPoint(v_edit_link.the_geom, v_edit_man_wjoin.the_geom) as the_geom
FROM ws_migra.v_edit_man_wjoin,ws_migra.v_edit_link
WHERE ST_DWithin(v_edit_link.the_geom, v_edit_man_wjoin.the_geom, 0.2);