[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Split polygon by line
From: Darafei_"Komяpa"_Praliaskouski <me () komzpa ! net>
Date: 2018-10-18 16:53:09
Message-ID: CAC8Q8tK+2m=66+NE7VkGGAZNajm=K9Dw+dLThL=Y7FFscSRFag () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@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@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@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
--
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
[Attachment #5 (text/html)]
<div dir="ltr">Hi,<div><br></div><div>ST_Dump returns geometry_dump object that \
consists of two fields. </div><div>To get geometry from \
it:</div><div><br></div><div>(ST_Dump(whatever)).geom as geom<br><br><div \
class="gmail_quote"><div dir="ltr">чт, 18 окт. 2018 г. в 19:46, Shane Carey \
<<a href="mailto:careyshan@gmail.com">careyshan@gmail.com</a>>:<br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div \
dir="ltr"><div>Hi,</div><div><br></div><div>I still dont get any GIS layers \
returning, when I do:</div><div><br></div><div>SELECT ST_Dump(ST_Split(polygon.geom, \
line.geom))<br> INTO clip1<br>FROM testclip line, floodplainw \
polygon;<br></div><div><br></div><div><br></div><div>Thanks<br></div></div></div><div \
dir="ltr"><div dir="ltr"><div><div><div dir="ltr" \
class="m_-4553355520752010310gmail_signature"><div dir="ltr"><div><div \
dir="ltr"><div><div dir="ltr"><div>Le gach dea ghui,<br></div><div><span \
style="color:rgb(61,133,198)"><b><span \
style="background-color:rgb(255,255,255)"><i>Shane \
Carey</i></span></b></span></div><div><span style="color:rgb(61,133,198)"><b><span \
style="background-color:rgb(255,255,255)"><i>GIS and Data Solutions \
Consultant</i></span></b></span><br></div></div></div></div></div></div></div></div><br></div></div></div><br><div \
class="gmail_quote"><div dir="ltr">On Thu, Oct 18, 2018 at 6:00 PM Shane Carey <<a \
href="mailto:careyshan@gmail.com" target="_blank">careyshan@gmail.com</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Ok so! :)<br \
clear="all"><div><div><div dir="ltr" \
class="m_-4553355520752010310m_-1577027419897208774gmail_signature" \
data-smartmail="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div \
dir="ltr"><div>Le gach dea ghui,<br></div><div><span \
style="color:rgb(61,133,198)"><b><span \
style="background-color:rgb(255,255,255)"><i>Shane \
Carey</i></span></b></span></div><div><span style="color:rgb(61,133,198)"><b><span \
style="background-color:rgb(255,255,255)"><i>GIS and Data Solutions \
Consultant</i></span></b></span><br></div></div></div></div></div></div></div></div><br></div></div><br><div \
class="gmail_quote"><div dir="ltr">On Thu, Oct 18, 2018 at 3:45 PM Arnaud L. <<a \
href="mailto:arnaud.listes@codata.eu" target="_blank">arnaud.listes@codata.eu</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">Le 18/10/2018 18:55, Shane Carey \
a écrit :<br> > Ok thanks, will do in future:<br>
<br>
Dont' wait, do it now ! ;)<br>
<br>
> This is what I have tried and no joy- any ideas? Thanks in advance.<br>
> SELECT ST_AsText((ST_Dump(ST_Split(circle, line))).geom) As wkt<br>
<br>
Don't make a WKT representation. WKT is a text string, not a geometry.<br>
Remove the ST_AsText() and you should be OK.<br>
<br>
--<br>
Arnaud<br>
</blockquote></div>
</blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div></div>-- \
<br><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div \
dir="ltr">Darafei Praliaskouski<br>Support me: <a \
href="http://patreon.com/komzpa">http://patreon.com/komzpa</a></div></div>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic