How to let a matrix from excel generate a network

1687
5
Jump to solution
01-04-2017 02:05 PM
EAlberts
New Contributor

Hey guys,

I have been trying to visualize a matrix like this from excel, where the row feeds the column and vice versa, in ArcGis. Is there a way I can generate a spoke network, where the size of the lines are dependent of the value. Something like this, for example? I found some topics on forums, but they were more about how to make a beautiful map. I just want to connect polygons, add excel data, and create some simple lines between the polygons. 

Kind regards,

0 Kudos
1 Solution

Accepted Solutions
XanderBakker
Esri Esteemed Contributor

In the past I did something similar to visualize migration, but using a different data structure. See thread here: Creating Polylines to track migration using some curvature to avoid overlapping lines when there is "traffic" is both directions between two points.

It is possible to adapt the code and read a matrix, use the names of the polygons (and a polygon featureclass) to extract the centroid of the polygon and connect the point storing the value from the matrix as attribute that afterwards can be used to assign a color and or width to the polylines. 

So, in short, yes it is possible, but it will require some coding (Python script).

View solution in original post

5 Replies
DanPatterson_Retired
MVP Emeritus

Moving this to Analysis‌ to better your chances of getting an answer  ... This may help in the future...https://community.esri.com/docs/DOC-1544 

EAlberts
New Contributor

Thank you!

0 Kudos
XanderBakker
Esri Esteemed Contributor

In the past I did something similar to visualize migration, but using a different data structure. See thread here: Creating Polylines to track migration using some curvature to avoid overlapping lines when there is "traffic" is both directions between two points.

It is possible to adapt the code and read a matrix, use the names of the polygons (and a polygon featureclass) to extract the centroid of the polygon and connect the point storing the value from the matrix as attribute that afterwards can be used to assign a color and or width to the polylines. 

So, in short, yes it is possible, but it will require some coding (Python script).

EAlberts
New Contributor

Thanks for your clarification, got some work to do then! 

0 Kudos
XanderBakker
Esri Esteemed Contributor

If you run into problems to code the solution, you can post your questions here in this thread or create a new question and tag me. I will see what I can do to help you.

0 Kudos