Intersection Question : Include ALL Intersections in a single point (3way+)

2572
2
09-03-2014 02:32 PM
DarrenWiens2
MVP Honored Contributor

Hmmm it works for me.

 

Imagine I have only two points A and B that are coincident.

 

Run Spatial Join using the points as both Target and Join features, and JOIN_ONE_TO_MANY as the join operation.

 

You now have 4 points, with all of the columns from the Target feature (including a column for street name) and all of the columns from the Join features (including its street name). The four features are: A joined to A, A joined to B, B joined to A, and B joined to B. Only one of these will have a Target_FID greater than Join_FID. This is the only point you want to keep (i.e. select all of the points with Target_FID < Join_FID, and delete them). You now have one feature with two fields, each with a street name.

0 Kudos
2 Replies
BrianO_keefe
Regular Contributor II

My question is now... what about 3 and 4 way intersections?

For instance, we have some streets that span a directional split...

North Memorial Drive and South Memorial Drive.

So technically, where Memorial INTERSECTS with our split point which is parallel to Admiral I should have...

  1. Intersection 1
    1. South Memorial Drive
    2. North Memorial Drive
    3. West Admiral Drive

Any ideas here?

0 Kudos
BrianO_keefe
Regular Contributor II

On an interesting side note...

I just discovered a weird side-effect.

After doing the spatial join I get a SINGLE point for ALMOST ALL Intersections.

ALMOST ALL... EXCEPT those that are like I described above...

For instance...

Where Admiral Blvd splits North and South Phoenix Ave I have 3 points.

  1. Intersection Point
    1. N PHOENIX AVE
    2. S PHOENIX AVE
  2. Intersection Point
    1. N PHOENIX AVE
    2. W ADMIRAL BLVD
  3. Intersection Point
    1. S PHOENIX AVE
    2. W ADMIRAL BLVD

The street names above that are bolded I would like to merge into a single point... The ones struck through should be removed.

Any ideas how to get to this?

0 Kudos