TransWikia.com

How to split lines at every intersection from a single geometry using PostGIS?

Geographic Information Systems Asked by user12949097 on June 22, 2021

The query I tried is this:

Create table test1 as 
  Select 
    row_number() over() as ID,
    (st_dump(st_split(input.geom, blade.geom))).geom as geom
  from roads input
  join roads blade on st_intersects(input.geom, blade.geom);

The error that pops up is like this:

ERROR:  Splitter line has linear intersection with input
SQL state: XX000

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP