Extract TOIDs from route

527
4
09-20-2011 04:23 AM
JamesSmith5
New Contributor
Hi everyone,

I'm a bit of a newbie, but hope someone might be able to help me.

As an example of my problem, I have 10 origins and 10 destinations. I am using the Network Analyst toolbox and an ITN to come up with routes between each of them. However I have some 3rd party data that I would like to join to these routes. The identifying field in the 3rd party data is TOID. So is there some way to do this? When I look at the attribute table of the route that Arc has created, it does not seem to have a column containing the TOIDs of the roads that the route has used. Can these be accessed somehow, and then joined to my data?

Thanks

James
Tags (2)
0 Kudos
4 Replies
JamesSmith5
New Contributor
Just been having a proper glance through the Forum history and came accross this:

http://forums.arcgis.com/threads/37655-Finding-all-links-in-a-route

Seems to be a similar problem. Will read up on it and the answers Jay suggests, but in the meantime if anyone has any ideas that would be appreciated.
0 Kudos
JaySandhu
Esri Regular Contributor
I have replied to this in the other thread:
http://forums.arcgis.com/threads/37655-Finding-all-links-in-a-route?p=135000&posted=1#post135000

Basically use the traversal result addin from the ArcGIS resources to get to the table of all the edges traversed.

Jay Sandhu
0 Kudos
JamesSmith5
New Contributor
I have replied to this in the other thread:
http://forums.arcgis.com/threads/37655-Finding-all-links-in-a-route?p=135000&posted=1#post135000

Basically use the traversal result addin from the ArcGIS resources to get to the table of all the edges traversed.

Jay Sandhu


Dear Jay,

Thanks for the response. I have used the add-in as you suggest and now have 3 new tables; Edges, Turns and Junctions. Unfortunately none of these tables have brought through the field RoadLinkTOID, which is what I need to link to my external data. Is there someway for me to bring this through, or alternatively to link back from the Edges table to the Road_Links table (where the RoadLinkTOID is stored) ?

Thanks for your help!

James
0 Kudos
JaySandhu
Esri Regular Contributor
As I mentioned in my previous post, read the other other thread where I provided two ways to solve this including doing Joins.

Jay Sandhu
0 Kudos