topic Re: How to let a matrix from excel generate a network in Spatial Data Science Questions

How to let a matrix from excel generate a network

EAlberts — Wed, 04 Jan 2017 22:05:48 GMT

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,

Re: How to let a matrix from excel generate a network

DanPatterson_Retired — Wed, 04 Jan 2017 22:14:26 GMT

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

Re: How to let a matrix from excel generate a network

EAlberts — Thu, 05 Jan 2017 10:02:06 GMT

Thank you!

Re: How to let a matrix from excel generate a network

XanderBakker — Thu, 05 Jan 2017 12:04:39 GMT

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).

Re: How to let a matrix from excel generate a network

EAlberts — Thu, 05 Jan 2017 21:09:57 GMT

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

Re: How to let a matrix from excel generate a network

XanderBakker — Thu, 05 Jan 2017 21:57:17 GMT

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.