Hi All,Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.I have tried a range of thingsbuffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to take getting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record. I think i need a Spatial Angle Join but am struggling with the logic on the listsAny help or suggestions appreciated. Thanks Steve

Hi All,Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.I have tried a range of thingsbuffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to takegetting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record.I think i need a Spatial Angle Join but am struggling with the logic on the listsAny help or suggestions appreciated.Thanks SteveI haven’t tested it but have you tried the FuzzyParallelLineFinder? It’s a custom transformer maintained by Safe Software

Solved

Spatial Join linear feature with closest running a similar angle (Spatial Angle Join)

8 months ago
July 10, 2024
4 replies
72 views

+5

goatboyboz
Contributor
6 replies

Hi All,

Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.

I have tried a range of things

buffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to take
getting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record.

I think i need a Spatial Angle Join but am struggling with the logic on the lists

Any help or suggestions appreciated.

Thanks Steve

Best answer by ctredinnick

My first suggestion when seeing transferring attributes between lines is to recommend my custom transformer LineOnLineRelator. Although it doesn’t have specific control for the angle between lines, just picks what’s best, and falls off if the lines are too different in angle.

If you want to work with your angle list, I could recommend using a trig function.

ABS(SIN(2*(angle+45))) has minimums at 45 and -45 degrees which you can sort your list by.

@abs(@sin(2*@degToRad(@Value(angle)+45)))

View original

Did this help you find an answer to your question?

+34

virtualcitymatt
Celebrity
1824 replies
8 months ago
July 10, 2024

goatboyboz wrote:

Hi All,

Im trying to do a spatial join of attributes from the red line (running parallelish) to the black line, not the attributes from the red line running down Duke Street.

I have tried a range of things

buffering the black line and seeing what it contains ( it contains a piece of Duke Street) and the parallel red line but i cant work out which record to take
getting the polar angle of the lines and looking at the list of records that spatially join it - im struggling to sort the list to find the correct record.

I think i need a Spatial Angle Join but am struggling with the logic on the lists

Any help or suggestions appreciated.

Thanks Steve

I haven’t tested it but have you tried the FuzzyParallelLineFinder? It’s a custom transformer maintained by Safe Software

+5

goatboyboz
Author
Contributor
6 replies
8 months ago
July 10, 2024

Thanks Matt,

Its not quite right in my use case ( but useful to know about). I have gone down the neighbor finder route. I now have a list of neighboring lines appended to my original line. I also have a polar angle ( 0-180) for each line. What i cant figure out is now to get the item in the list with the closest polar angle to my original line.

Say my original line is running 45 degrees. I now have a list with x items in it all with a polar angle. How do i get the line with the closest to 45 degrees ( say my lines are 23,127 and 40 degrees) I want the 40 degree one to be selected.

I tried using a listsorter and taking the 1st item of the list ( but this doesn't work as i want to item with the angle closest to 45 , not closest to zero.

Thanks steve

+18

ctredinnick
Supporter
222 replies
Best Answer
8 months ago
July 10, 2024

My first suggestion when seeing transferring attributes between lines is to recommend my custom transformer LineOnLineRelator. Although it doesn’t have specific control for the angle between lines, just picks what’s best, and falls off if the lines are too different in angle.

If you want to work with your angle list, I could recommend using a trig function.

ABS(SIN(2*(angle+45))) has minimums at 45 and -45 degrees which you can sort your list by.

@abs(@sin(2*@degToRad(@Value(angle)+45)))

+5