Latest Contributions by JaySandhu

When you use 10 .vs. 10 SP4 is there a change in the network dataset, the settings such as Hierarchy or use a different set of restrictions? Or the points being used? As far as we are aware there is no change in the performance of the OD solver between 10 and any service packs. Jay Sandhu ... View more

If you need to find the best locations for your pick up and drop off sites, then I suggest that you look at the Location-Allocation solver. The online help is here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Location_allocation_analysis/004700000050000000/ and you can do the tutorial here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_9_Choosing_optimal_store_locations_using_location_allocation/004700000067000000/ Jay Sandhu ... View more

Instead of the closest facility, can you run a route and if that succeeds to make sure it is not a network dataset issue. Jay Sandhu ... View more

Scott, As long as you know that you visiting the local locations from a pre-defined shop then the route sequence is always known, that is: Shop1, Home1, Shop1,Routename1 Shop1, Home2, Shop1,Routename2 Shop2, Home3, Shop2,Routename3 etc or simpler (assuming travel time is same from work and back to work), the data will look like: Shop1, Home1,Routename1 Shop1, Home2,Routename2 Shop2, Home3,Routename3 So VRP is not the way to solve this. it is the Route solver as there is no optimization of the sequence of the visits from Shop1. The route solver Stops sub-class is loaded with right-click Load Locations or the GP tool Add Locations. It can be run multiple times. So the input locations can come from more than one file. As long as the routename is same for a pair (or three) of stops, they will paired up by the route solver. Yes, you will be loading 70,806 records. But they will make 35403 unique pairs. So the above file can be loaded twice, first with the "shop" address and routename field and then again with "home" address and routename fields. Loading into an existing stops layer with records does not over-write, rather adds on to what's there. So your work is in pre-processing your inputs so that they can loaded into the stops layer. I hope the above makes sense. Jay Sandhu ... View more

You need to use the VRP solver for this. You can read more about it here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Vehicle_routing_problem_analysis/00470000004v000000/ and best if you run through the tutorials for that tool (Exercise 7 and 8). Details here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_7_Servicing_a_set_of_orders_with_a_fleet_of_vehicles/004700000062000000/ Jay Sandhu ... View more

What kind of network dataset are you using how far apart are the incidents from the facility. if they are far apart perhaps Hierarchy needs to be ON. What kind of information do you need to transfer to SPSS? Is it just the total route lenght? If that is the case then use the OD Cost Matrix solver as it is simillar to the closest facility but does not write out the geometry of the routes in the end but will give you the network route lenghts. Jay Sandhu ... View more

Given your description that you want to make route from depot to address and back to depot, you should not use the VRP solver. The VRP solver is meant to solve an optimizing problem where it is not known which depot will serve which order and an optimal allocation of addressess to depots is needed. You can simply use the route solver but use the ROUTENAME property to load multiple sets of depot/address/depot into the same route layer and solve. In this way you can load in 35403 sets of stops into a single route layer and solve to generate 35403 sets of output routes. You can read more about the routename property here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Route_analysis/004700000045000000/ Jay Sandhu ... View more

The size of the network dataset does not matter. Do you have 1 address and 1 depot? Or do you have more addresses? What does the following mean: Orders (35403) Depots (929) Routes (35403) To trouble shoot, can you get a route (using the Route analysis layer) between yuor 1 address and 1 depot? Jay Sandhu ... View more

What are your goals? Is it know the number of turns (define turn!)? That is, is it to know left/right turns only when street name changes? Or is it to know bends or turns in the road even when the street name does not change? At a minimum, you could export the directions and count how many "left" and "right" words are contained in it! Jay Sandhu ... View more

The street directions looks at every edge of a route as it connects to the next edge, computes the angle and then decides what angle exists before it can say left or right turn. As I mentioned, this VBA (or the new AddIn) export out the turn features that were part of the network dataset. it cannot export what does not exist. You will have to post process the Edges that are exported out of here to determine left/right turns. Jay Sandhu ... View more

The VAB is posted below. It will work for turns if they exist in your data. Jay Sandhu Public Sub AddNATraversalResultToArcMap()   Dim pMxDoc As IMxDocument   Dim pNetworkAnalystExtension As INetworkAnalystExtension   Dim pNALayer As INALayer   Dim pFLayer As IFeatureLayer   Dim pTraversalResultQuery As INATraversalResultQuery   Dim pNATraversalResultEdit As INATraversalResultEdit     Set pMxDoc = ThisDocument   Set pNetworkAnalystExtension = Application.FindExtensionByName("Network Analyst")   Set pNALayer = pNetworkAnalystExtension.NAWindow.ActiveAnalysis   Set pTraversalResultQuery = pNALayer.Context.Result   Set pNATraversalResultEdit = pTraversalResultQuery     'Infer Geometry   pNATraversalResultEdit.InferGeometry "", Nothing, New CancelTracker     'Get the Edges and add as a layer   Set pFLayer = New FeatureLayer   Set pFLayer.FeatureClass = pTraversalResultQuery.FeatureClass(esriNETEdge)   pFLayer.Name = pFLayer.FeatureClass.AliasName   pMxDoc.FocusMap.AddLayer pFLayer     'Get the Junctions and add as a layer   Set pFLayer = New FeatureLayer   Set pFLayer.FeatureClass = pTraversalResultQuery.FeatureClass(esriNETJunction)   pFLayer.Name = pFLayer.FeatureClass.AliasName   pMxDoc.FocusMap.AddLayer pFLayer   'Get the Turns and add as a layer   Set pFLayer = New FeatureLayer   Set pFLayer.FeatureClass = pTraversalResultQuery.FeatureClass(esriNETTurn)   pFLayer.Name = pFLayer.FeatureClass.AliasName   pMxDoc.FocusMap.AddLayer pFLayer   End Sub ... View more

The Network Analyst tool you need to ultimately use is the VRP solver. However I will suggest that you start with the free streetmap data  that comes with with ArcGIS. It is a free nationwide street network. It is on the data and maps dvd and it is ready to use out of the box. You can also find in online to download if you do not have the dvd. Besides the tutorials, online resources on ArcGIS.com, etc., you can watch this VRP video to get a bit more familliar with it: http://video.arcgis.com/watch/686/vehicle-routing-problem-example-appliance-delivery Jay Sandhu ... View more

In the catalog, bring up the properties of the shape file. Then click on the Indexes tab. Towards the bottom right, it should have a way to add, delete, update the spatial index. If you are unable to find this way, then you can use the GP tool to Add Spatial Index. http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000060000000 Jay Sandhu ... View more

You can create an artificial road network by using the GP tool "Create Fishnet" to first create a grid of lines that covers the extent of your points and then build a network dataset on it and then use the Route tool to load your points, select the "Reorder Stops to Find Optimal Route" to find the best tour to visit the points. Fishnet doc: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00170000002q000000 Based on the extent of your points, you can make an adequately dense grid, say 500 meter cell size for this purpose. Jay Sandhu ... View more

Have you looked at the 3D routing in a building tutorial? Link here: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00470000005q000000 Jay Sandhu ... View more