Create PolyLine from 2 centroids in 1 row

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.

Spatial Analysis

Accepted answers

MarqueeCrew

Hey @StephenMack,

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

ST_CreateLine([SpatialObj],[SpatialObj2])

Cheers,

Mark

All comments

MarqueeCrew

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!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335