topic Extract TOIDs from route in ArcGIS Network Analyst Questions

Extract TOIDs from route

JamesSmith5 — Tue, 20 Sep 2011 11:23:53 GMT

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

Re: Extract TOIDs from route

JamesSmith5 — Tue, 20 Sep 2011 11:32:41 GMT

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.

Re: Extract TOIDs from route

JaySandhu — Tue, 20 Sep 2011 14:03:06 GMT

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

Re: Extract TOIDs from route

JamesSmith5 — Wed, 21 Sep 2011 08:01:59 GMT

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

Re: Extract TOIDs from route

JaySandhu — Wed, 21 Sep 2011 13:36:31 GMT

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