Create PolyLine from 2 centroids in 1 row

[StephenMack]

I have a table, and on each row I calculate 2 different centroids. I would like to draw a line between them, but I'm not sure how to work between columns instead of down the rows.

I would like to end up with each row having their own PolyLine.

I'm assuming this will require some cross tab magic but I can't quite get it to work.

[MarqueeCrew · Accepted solution]

Hey @StephenMack,

How about using a Formula tool with a new spatialobj output, My_Line:

ST_CreateLine([SpatialObj],[SpatialObj2])

Cheers,

Mark

[StephenMack]

As usual the solution ends up being surprisingly simple and beautiful. Much appreciated!

[joshuaburkhow]

Just for my own learning this same thing can be done with the poly-build tool correct?

[StephenMack]

In this case I don't think so.

Poly-Build tool will create a line or polygon based on spatial data in a single column. I was looking at creating a line between centroids in 2 different columns in the same row.

[joshuaburkhow]

Ahh nice thank you!