od cost matrix

Tom_AndersEngebakken

Hi

I have created a python script that runs an OD cost matrix over five years, from 1999 to 2004. I have set up an OD cost matrix for each year, which I think is very cumbersome. Is there someone who can show me how I do this with a loop in python (arcpy) instead of setting up the OD cost matrix for each year.
In my orgins and Destinations I also have a field called HOSPITALS. In the OD cost matrix, this field should be connected to each other so there will only be an analysis of each orgins to Destination.
How can i do this?

OD_Cost_MatrixTEST.py.zip

Screenshot 2023-09-25 at 3.39.11 PM.png

SarahRijneke_1-1757942618654.png

BradShore1

With a route layer, you can load multiple features into it to be able to solve the route. If you define the RouteName field in the route layer (in your case you could use the Hospital ID), you can solve routes between Members and the Hospital they were seen at. The only downside to this is getting the data set up correctly.

You will need 2 features to do this, a Member feature and a Hospital feature. Here's the catch, in the hospital feature, there needs to be a record for every Member. So, if you have 20 Members total, 10 are seen at Hospital a, and 10 were seen at Hospital b, the Hospital feature will need 20 record total (10 Hospital a and 10 Hospital b). You can then load each feature into the stops of the Route Layer with the RouteName field defined on Hospital ID and it will calculate the distance between each Member and the Hospital they were seen at.

There are quite a few threads in the Network Analysis forums about how to use the RouteName field. I hope this makes sense and helps out.