I have two tables
roads in my PostgreSQL 9.5 database. Some of the points lie on the intersections of three roads (line segments). The sample scenario is as follows:
I want to identify all such points that lie on the intersection of three roads. I came across this question on GIS-SE, but the code returned me all points on the intersections of individual line segments which is not desired. Can someone suggest me how do I identify the points that lie on the intersection of three segments (street crossing) only?