I have a table containing a set of points of intersections.
Most of the roads intersects whith just one road BUT i have some roads which intersects with two, therefore three different point of intersection has been created. BUT, i want only one point of intersection for all the three distinct roads.
Any suggestion how I can merge the 3 points to just one where there is such situation.
I am using postgresql with postgis
The following is the table where i have the points of intersection
The following is a graphical screenshot of the situation.