topic Re: Network Analyst Traffic Condition in ArcGIS Network Analyst Questions https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467279#M4468 <HTML><HEAD></HEAD><BODY><SPAN>Priyanka,</SPAN><BR /><SPAN>You can add the excel sheet to ArcMap and then right-click it to either geocode or display as XY to convert the excel sheet into a point feature class. So if you have address data you can geocode and if you have lat/long then you can use the XY option. No need to convert that to something else.</SPAN><BR /><BR /><SPAN>Ex 8 in the Network Analyst tutorials also shows how to geocode orders for VRP from an excel sheet called OrderPairs.xls You can see the details here:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_8_Finding_best_routes_to_service_paired_orders/004700000063000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_8_Finding_best_routes_to_service_paired_orders/004700000063000000/</A><BR /><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jay Sandhu</SPAN></BODY></HTML> Fri, 05 Nov 2010 14:33:03 GMT JaySandhu 2010-11-05T14:33:03Z Network Analyst Traffic Condition https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467276#M4465 <HTML><HEAD></HEAD><BODY><SPAN>Hello there, </SPAN><BR /><BR /><SPAN>I have added streets network dataset(ESRI data) for finding the shortest route but i think it doesn't take into account the historical traffic condition. Can you tell how can i add traffic data to the network dataset.</SPAN><BR /><BR /><SPAN>Please guide me.</SPAN><BR /><BR /><SPAN>Priyanka</SPAN></BODY></HTML> Mon, 01 Nov 2010 12:50:17 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467276#M4465 PriyankaJain 2010-11-01T12:50:17Z Re: Network Analyst Traffic Condition https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467277#M4466 <HTML><HEAD></HEAD><BODY><SPAN>The free streetmap data that comes with ArcGIS does not contain historical traffic conditions. You can buy StreetMap premium advanced data with that information. You can get some more information here: </SPAN><A href="http://www.esri.com/data/streetmap/comparison.html">http://www.esri.com/data/streetmap/comparison.html</A><BR /><BR /><SPAN>If you want to make your own, then you can take a look at the Tutorial data that comes with Network Analyst, specifically the San Francisco data as it has been set up with historical data.</SPAN><BR /><SPAN>You can read more about historical data here:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0047000000s0000000.htm">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//0047000000s0000000.htm</A><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jay Sandhu</SPAN></BODY></HTML> Mon, 01 Nov 2010 13:57:16 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467277#M4466 JaySandhu 2010-11-01T13:57:16Z Re: Network Analyst Traffic Condition https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467278#M4467 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the information. </SPAN><BR /><SPAN>Also, i wanted to know how can i add Excel data sheet as 'orders' for Vehicle Routing Problem. Do i need to convert it to some other format? </SPAN><BR /><BR /><SPAN>Thanks, </SPAN><BR /><SPAN>Priyanka</SPAN></BODY></HTML> Fri, 05 Nov 2010 03:30:04 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467278#M4467 PriyankaJain 2010-11-05T03:30:04Z Re: Network Analyst Traffic Condition https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467279#M4468 <HTML><HEAD></HEAD><BODY><SPAN>Priyanka,</SPAN><BR /><SPAN>You can add the excel sheet to ArcMap and then right-click it to either geocode or display as XY to convert the excel sheet into a point feature class. So if you have address data you can geocode and if you have lat/long then you can use the XY option. No need to convert that to something else.</SPAN><BR /><BR /><SPAN>Ex 8 in the Network Analyst tutorials also shows how to geocode orders for VRP from an excel sheet called OrderPairs.xls You can see the details here:</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_8_Finding_best_routes_to_service_paired_orders/004700000063000000/">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Exercise_8_Finding_best_routes_to_service_paired_orders/004700000063000000/</A><BR /><BR /><BR /><SPAN>Regards,</SPAN><BR /><SPAN>Jay Sandhu</SPAN></BODY></HTML> Fri, 05 Nov 2010 14:33:03 GMT https://community.esri.com/t5/arcgis-network-analyst-questions/network-analyst-traffic-condition/m-p/467279#M4468 JaySandhu 2010-11-05T14:33:03Z