[postgis-users] Split polygon by line

[Darafei "Komяpa" Praliaskouski]

Hi,

ST_Dump returns geometry_dump object that consists of two fields.
To get geometry from it:

(ST_Dump(whatever)).geom as geom

чт, 18 окт. 2018 г. в 19:46, Shane Carey <careyshan at gmail.com>:

> 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 <careyshan at gmail.com> 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. <arnaud.listes at codata.eu>
>> 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
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181018/e2e47720/attachment.html>