milhouse537
asked on
ArcGIS - street intersections to point layer
I'm using ArcGIS 9.2, although I do have access to 9.3.1 and 10.x (I just haven't upgraded yet).
I have street centerline data. For weeks now, I've been trying to create a layer of points that match the street centerline intersections, with street names and X/Y coordinates. In the end, I need to be able to generate a table in Access, with street intersection names and coordinates, so that I can generate a printable report.
I have tried the various methods suggested on the interwebs, to no success. I've also tried several add-ins from the ESRI website - either they don't install properly at all, or they don't work.
How can I go about this? I'd be willing to consider a paid add-in to do this job, if it would work. Or if someone has some methodology that actually works. I'm not the world's strongest GIS person, but I can't believe that somebody hasn't done a project like this before.
I have street centerline data. For weeks now, I've been trying to create a layer of points that match the street centerline intersections, with street names and X/Y coordinates. In the end, I need to be able to generate a table in Access, with street intersection names and coordinates, so that I can generate a printable report.
I have tried the various methods suggested on the interwebs, to no success. I've also tried several add-ins from the ESRI website - either they don't install properly at all, or they don't work.
How can I go about this? I'd be willing to consider a paid add-in to do this job, if it would work. Or if someone has some methodology that actually works. I'm not the world's strongest GIS person, but I can't believe that somebody hasn't done a project like this before.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
As I mentioned in a comment on the original post, there's no easy way to do this in ArcGIS, although I did find a methodology that partially works.
ASKER
After lots of tribulations, I was able to get this methodology to partially work (source: http://forums.arcgis.com/threads/23215-create-point-shapefile-of-street-intersections-from-polyline-ArcEditor)
1) Create Version of centerline that only has named streets
2) Dissolve on full street name (e.g. MAIN ST - this will remove duplicates later)
3) Use Intersect on this layer with output type = point
4) Add XY coordinates to new point layer and create DissolveID field and set to X_Y as mentioned above
5) Dissolve on DissolveID field to end up with only one point per intersection
6) Add new field to your Dissolved Named Streets layer - make 150-200 characters to hold 4-5 street names, then use Field Calculator to fill it with street name and add an underscore "_" at the end (e.g. MAIN ST_)
7) Do a Spatial Join with your target being the intersection points, and the Join Features being the dissolved named streets layer. Right click on your new field in the Field Map of Join Features, and under Merge Rule choose Join. After running, your end result should look something like A ST_1ST ST_ All streets at the intersection will be included (I got up to 4), and only once each if you did the original dissolve.
8) Use Field calculator to strip the last "_" and then replace the rest with " & " - set the Parser to Python, then use the following: !YourFieldName!.rstrip('_'
This does not give perfect results, but it's a start. Thanks for suggestions.