[postgis-users] split line at polygon edge

2016-03-19 Thread Garret W
Hi Ive been looking for a way to take several hundred lines and split them where they intersect a polygon while also giving them the ID of the polygon they fall in. Ive seen many posts on splitting polygons. But its been difficult for me to adapt those examples. Ive been able to get an output from

Re: [postgis-users] split line at polygon edge

2016-03-19 Thread Rémi Cura
ence(). > > > > Regards, > > > > Hugues. > > > > *De :* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *De > la part de* Garret W > *Envoyé :* jeudi 17 mars 2016 04:11 > *À :* postgis-users@lists.osgeo.org > *Objet :* [postgis-users] s

Re: [postgis-users] split line at polygon edge

2016-03-19 Thread Garret W
ST_Difference(). >> >> >> >> Regards, >> >> >> >> Hugues. >> >> >> >> *De :* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *De >> la part de* Garret W >> *Envoyé :* jeudi 17 mars 2016 04:11 >> *À :

Re: [postgis-users] split line at polygon edge

2016-03-19 Thread François Hugues
: postgis-users@lists.osgeo.org Objet : [postgis-users] split line at polygon edge Hi Ive been looking for a way to take several hundred lines and split them where they intersect a polygon while also giving them the ID of the polygon they fall in. Ive seen many posts on splitting polygons. But its been

Re: [postgis-users] split line at polygon edge

2016-03-19 Thread François Hugues
gards, >> >> >> >> Hugues. >> >> >> >> *De :* postgis-users [mailto:postgis-users-boun...@lists.osgeo.org] *De >> la part de* Garret W >> *Envoyé :* jeudi 17 mars 2016 04:11 >> *À :* postgis-users@lists.osgeo.org >> *Objet :* [post

Re: [postgis-users] split line at polygon edge

2016-03-20 Thread Rémi Cura
returned using ST_GeometryType(). > You > >> may have some geometrycollections and I’m not sure QGis can handle it. > In > >> this case you could extract lines using ST_CollectionExtract(). > >> > >> > >> > >> To achieve what you want to do, y