AnsweredAssumed Answered

Simple routing with many:many sources

Question asked by jprimicias on Jan 31, 2014
Latest reply on Feb 6, 2014 by jprimicias

Like • Show 0 Likes0
Comment • 8

I have a table with From- and To- addresses. Let's say there are 10,000 records in the table and each record has to be a different route. These addresses have already been geocoded. I tried network analyst and linear referencing but with no success. I have access to StreetMaps Premium 2013 but have no idea how to utilize it in this scenario.

Any assistance would be greatly appreciated.

jsandhu-esristaff

Feb 5, 2014 9:21 AM

Correct Answer

I think you should try using the Route solver with the Routename property rather than the VRP solver. It is easier to set up, that is two load locations on the data you already have set up and it is ready to solve.

Jay Sandhu

See the reply in context

No one else had this question

Outcomes

8 Replies

rfairhur24 Jan 31, 2014 11:41 AM
Mark Correct
Correct Answer
I have a table with From- and To- addresses. Let's say there are 10,000 records in the table and each record has to be a different route. These addresses have already been geocoded. I tried network analyst and linear referencing but with no success. I have access to StreetMaps Premium 2013 but have no idea how to utilize it in this scenario.

Any assistance would be greatly appreciated.

Network Analyst is the only tool that can even begin to do this that I know of. Did you set up a Network with real connectivity? What did you attempt to do with Network Analyst and what was the result? The Network Analyst forum may be a better place to post this question, since only people who use that extension will have experience that can help you. (I don't use it, since I don't need to solve these kinds of problems, but I know it is the only real way to deal with these kinds of problems).
Like • Show 0 Likes0
Actions
jprimicias Jan 31, 2014 12:04 PM
Mark Correct
Correct Answer
Thanks Richard, I'll post this question in the NA forum.
Like • Show 0 Likes0
Actions
MKennedy-esristaff Jan 31, 2014 1:23 PM
Mark Correct
Correct Answer
I'm sorry, Joe. I moved this thread here before I realized that you'd already reposted the question here.

Melita
Like • Show 0 Likes0
Actions
bsriramak Feb 2, 2014 4:12 AM
Mark Correct
Correct Answer
Do you have lat/long of each location? or are you able to plot them on a map ? If yes, you must first separate from and to. Make a table/shapefile/feature class of from locations and another table/shapefile/ feature class of to location. Then you can use NA. If you want route displayed on the map, you have a long task at hand. If you just want to get attributes of routes, you can use OD matrix.

If you could state your end purpose more clearly, the group can give you more options.
Like • Show 0 Likes0
Actions
jsandhu-esristaff Feb 3, 2014 9:04 AM
Mark Correct
Correct Answer
Use the Routename property to solve for routes between pairs of points.
See http://forums.arcgis.com/threads/12128-add-origin-amp-destination-locations-from-the-same-row-to-a-route-analysis-layer?highlight=routename

Jay Sandhu
Like • Show 0 Likes0
Actions
jprimicias Feb 3, 2014 1:03 PM
Mark Correct
Correct Answer
Actually, I geocoded the From-addresses to a feature class named Origin_1 and To-addresses to a feature class named Dest_1. I'm using the Vehicle Routing Problem solver in NA, created a field called RouteID with unique numbers to match the ObjectID in the Origin_1 table, and did the same for the Dest_1 table. So far I've loaded the Depots using Origin_1 and before I load the Orders with Dest_1, I need to Add Item in Routes. That where the problem lies. Since I have to Add Item 10,000 times, I'd like to automate this process.

I did a sample set of 20 records manually and it worked great. Is it possible to Add 10,000 Items automatically?
Like • Show 0 Likes0
Actions
jsandhu-esristaff Feb 5, 2014 9:21 AM
Unmark Correct
Correct Answer
I think you should try using the Route solver with the Routename property rather than the VRP solver. It is easier to set up, that is two load locations on the data you already have set up and it is ready to solve.

Jay Sandhu
Like • Show 0 Likes0
Actions
jprimicias Feb 6, 2014 5:36 AM
Mark Correct
Correct Answer
You're right, Jay! I tried the Route solver and it was much easier.
Thank you.

Joe
Like • Show 0 Likes0
Actions

GeoNet

The Esri Community

Simple routing with many:many sources

Outcomes

Related Content

Recommended Content