I need to know how this can be done. I have already contacted the ESRI support but probably tackle them with a difficult question because I have not heard from them yet.
Anyway, I have a point layer (FARMS) that are located on the STREETS. Where STREETS intersects other streets there is an intersection point. I need to identify from the intersection points which one is the closest to the FARM.
I have included the snapshot. The FARM is located on Stockington Rd. Stockington Rd is connected to Ballingers Mill Rd and to Salem Cty 611. Red cross is the intersection point. I need to select the closest road to the FARM that intersect Stockington Rd. Correct answer is Ballingers Mill Rd.
I tried to run 'Spatial Join' - Closest because this type of analysis will identify the intersection point that might be closest to the FARM but not necessarily it is connected to Stockington Rd on which the FARM is located. As you can see the distance shows that there is an intersectin point that is closer to the FARM but does not touch the boundary of Stockington Rd.