I am trying to split a network of line geometry by points in to non-overlapping subsets with PostGIS in PostgreSQL. I have tried multiple methods from stack: here and here.

Every method seems to work to some degree - but they all also produce overlapping subsets of either the entire original line or part of it (maybe split by 1 out of 5 intersecting points). This only happens in some cases. Most lines (and their assoc. points) work fine.

Note: I am using PostGIS 2.4.3 and have ensured I use ST_Snap rather than just ST_ClosestPoint in all attempts.

Looking for why this might be.

  • 1
    Can you post your code? – pdavis Mar 28 '19 at 17:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.