Subscribe to this thread
Home - General / All posts - SQL to output lines overlapping segments

1,741 post(s)
#25-Jul-18 18:37


I have to drawings containing line: [A] and [B]. [A] can be contained in [B], partialy overlapping [B] or crossing [B]

I'm trying with SQL to obtain from [A] just the overlapping segments with [B]. If [A] is just crossing [B], it should not be in the output.

I also want the output lines to have only one branch and I don't want any duplicates

I tried a lot of things (IntersectLine, AllBranches, Normalize, Split BY,...) , without achieving it.

Thank you for any pointer !



1,741 post(s)
#25-Jul-18 19:49

Looks like my query is good, but the data I'm working on is not well suited. Running AllBranches on [B] should solve the issue

Manifold User Community Use Agreement Copyright (C) 2007-2017 Manifold Software Limited. All rights reserved.