I need to create three distance matrices for around 550 points spread throughout Africa, Europe and Asia. The first matrix represents great circle distances, the second is the shortest distance along a network of trade routes, and the third is the shortest great circle distance via a way point.
I've completed the first two and was wondering if anyone knew of a method in ArcGIS 10.3 to calculate the distances between every point in two point layers via a single point. For instance, I have a group of points in southern Africa (Layer 1) and another group of points in Kazakhstan (Layer 2). I have a waypoint in Cairo, Egypt (Layer 3). I need to calculate the great circle distance from each point in Layer 1 to the waypoint in Layer 3 and then the great circle distance to each point in Layer 2.
Right now I'm planning on using the Generate Near Table tool twice, once between Layer 1 and the waypoint in Layer 3, and then again with Layer 2 and the waypoint in Layer 3. I'll then combine the distances accordingly in excel. This will take a very long time since the distance matrix has roughly 250,000 lines, so if there is a tool that could calculate great circle distance via waypoints it would save me a ton of time.
Please let me know if you need any more information.