Hi, I still dont get any GIS layers returning, when I do:
SELECT ST_Dump(ST_Split(polygon.geom, line.geom)) INTO clip1 FROM testclip line, floodplainw polygon; Thanks Le gach dea ghui, *Shane Carey* *GIS and Data Solutions Consultant* On Thu, Oct 18, 2018 at 6:00 PM Shane Carey <[email protected]> wrote: > Ok so! :) > Le gach dea ghui, > *Shane Carey* > *GIS and Data Solutions Consultant* > > > On Thu, Oct 18, 2018 at 3:45 PM Arnaud L. <[email protected]> wrote: > >> Le 18/10/2018 à 18:55, Shane Carey a écrit : >> > Ok thanks, will do in future: >> >> Dont' wait, do it now ! ;) >> >> > This is what I have tried and no joy- any ideas? Thanks in advance. >> > SELECT ST_AsText((ST_Dump(ST_Split(circle, line))).geom) As wkt >> >> Don't make a WKT representation. WKT is a text string, not a geometry. >> Remove the ST_AsText() and you should be OK. >> >> -- >> Arnaud >> >
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
