Hey, I am looking to pull out intersections into a single points file. I have a good feature of the streets as lines.
When I run "Intersect" and then "Spatial Join" and then "Delete Identical" I get a stack of points at each intersection. A sample would be:
One intersection having separate points that say "Cortland Street & East Main Street" and "East Main Street & Cortland Street". I don't need these as two points but just one.
I also need to be picky with the output table and we would prefer it formatted as:
Full Street Names Together | street 1 | street 2 | street 3 | short 1 | short 2 | short 3
Bay St and Harvest St | Bay St | Harvest St | | Bay | Harvest |
That being a full label text name, Full name of each street and short name of each street. My road file is already set to allow this as it has separate columns for full name and pieces of the name (Prefix, base, postfix). The most names to one intersection in the city is four, so it would be up to street 4 and short 4, maybe go 5 just in case city planners get jumpy?
If this can be something that uses just tools and built in model builder that would be best as we can just set it to run every so often. Doing it in python is less preferred but still a valid solution.