[postgis-users] Split polygon by line

[Shane Carey]

Hi,

Yep, I run the following:

SELECT ST_Split(circle, line)
INTO qlayer
FROM (SELECT
    ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)) As line,
    ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;

But this layer does not show up as a gis layer in qgis?

Thanks in advance for your help. Sorry, what do you mean by top post?
Thanks - postgis is super
Le gach dea ghui,
*Shane Carey*
*GIS and Data Solutions Consultant*


On Thu, Oct 18, 2018 at 3:28 PM Arnaud L. <arnaud.listes at codata.eu> wrote:

> Le 18/10/2018 à 18:31, Shane Carey a écrit :
> > This works and runs but how do I make a polygon out of it as opposed to
> > it just being in a table - I'd like it as individual polygons.
>
> It doesn't have to be in a table.
> The second polygon example in the doc builds two individual polygons
> from one polygon and one line.
>
> (please try not to top post)
>
> --
> Arnaud
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20181018/ba4baa65/attachment.html>