[postgis-users] ST_Split just doesn't work for me.

[Rémi Cura]

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 <Alexander.Mahrou at ch2m.com>:

>  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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141017/46de1242/attachment.html>