Build Dictionary from 2 tables

Question

Hi I have a link and a node table as follows. I would need to create a number of lines based on the nodeid and also the node type. Where type=vertex, I would only add a vertex to the line to represent change in direction.

 NodeID     Coords  Type
 A x1,y1  Valve 
 B  x2,y2    Valve
 C     x3,y3 Valve
 D  x4,y4 Vertex
 E  x5,y5 Valve

 FromNode  ToNode
 A  B
 B  C
 C  D
 D  E

Expected Output

Line 1 coordinates: (x1,y1), (x2,y2)

Line 2 coordinates: (x2,y2), (x3,y3)

Line 3 coordinates: (x3,y3), (x4,y4), (x5,y5)

With C# I would like to be able to loop through the 2 tables, and build a dictionary (or similar) with line number and coordinates, so that I can go and then create the geometry for the lines.

Any ideas how can I go about achieving this?

Thanks

Tapan Patel · Answer

Something as below would help to get it done in query it self.

Ravin Hasseea · Answer

Hi Thanks for the reply. Unfortunately this doesn't give me the output I am expecting as a line could be made up of number of vertices hence could have more than 2 coordinates. e.g. Line 3 coordinates: (x3y3) (x4y4) (x5y5)

NodeID	Coords	Type
A	x1,y1	Valve
B	x2,y2	Valve
C	x3,y3	Valve
D	x4,y4	Vertex
E	x5,y5	Valve