Connection matrices for points along stream network

GregGoodrum — Sun, 29 Nov 2020 00:48:10 GMT

Hi,

I'm working with a polyline stream network (National Hydrography Dataset/NHD) and points (barriers) along stream network. I'm trying to generate two outputs;

1. A path-distance matrix showing the shortest-path distance between a one point (barrier) and all other points (barriers) in the network. The output should look like the following

Barrier	A	B	C	D
A	0	10	15	20
B	10	0	5	10
C	15	5	0	5
D	20	10	5	0

where A:D are points (barriers), and numbers in the cells are total stream segment lengths between them.

2. A binary matrix for each path that shows which barriers lie along the path. The output should look like the following

Source	Destination	A	B	C	D
A	B	1	1	0	0
A	C	1	1	1	0
A	D	1	1	1	1

where Source is the starting point (barrier), Destination is the ending point (barrier), and numbers in the cells indicate where the point identified on the column lies on the path (1 = true, 0 = false).

Is anyone familiar with this type of network/path analysis and knows a workflow that can calculate these outputs using ArcHydro or other tools? I've been working in ArcGIS Pro, but have access to ArcMap 10.6 as well. Thanks!

Re: Connection matrices for points along stream network

DavidPike — Sun, 29 Nov 2020 12:57:39 GMT

The first question is easily solved (I think) using the OD Cost Matrix tool Generate Origin Destination Cost Matrix (Ready To Use)—ArcGIS Pro | Documentation

I'm not up-to-date on Pro Network Analysis so there may be a much easier/better way for the second question. In theory you could iterate over each combination of origin and source to produce a route, then collect the traversed barriers from each route using

Copy Traversed Source Features (Network Analyst)—ArcGIS Pro | Documentation

I'm using network analyst as a solution only because I can't comment on the hydro toolset, I'd hope there's a better built-in way someone can point you to though.

topic Re: Connection matrices for points along stream network in Water Resources Questions

Connection matrices for points along stream network

Re: Connection matrices for points along stream network