Your querry doesn't handle properly the case when one line has to be split by multiple other lines.
a simple list _are the geom valid (ST_ISValid / ST_MakeValid) _are the geom in the same referential _do you have a recent postgis/geos version (postgis_full_version()) _are you geometry at the correct precision (st_snaptogrid()) ... Cheers, Rémi-C 2014-10-17 22:23 GMT+02:00 <[email protected]>: > Hello List, > > > > I’ve got two polyline tables. I’m attempting to segment my lines by the > intersections of the other lines. > > > > create table segments as SELECT > ST_CollectionExtract(ST_Split(a.newgeom,b.geom),2) as geom from > > line1 a, line2 b WHERE ST_Intersects(a.newgeom,b.geom) = > true > > > > The end result is the geometry that I started with. What am I doing wrong? > > > > *Alex Mahrou* > > *Oil, Gas & Chemicals* > > > > *CH2**M HILL* > > 9191 S. Jamaica St. > > Englewood, CO 80112 > > www.ch2m.com > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
