[postgis-users] simple polygon clip

[Komяpa]

You've got several lines as several rows, you should combine them before
cutting the polygon:

CREATE TABLE aoi_blocks AS
SELECT *,
    ST_Difference(aoi.geom, ST_Union(lines.buffer_geom))
    FROM aoi, lines;

2014-11-10 14:41 GMT+03:00 Christopher Braune <chbraune at uni-potsdam.de>:

>  Dear all,
>
> I want to clip polygons like this:
>
>
> I tried the following SQL-sentences:
>
> CREATE TABLE aoi_blocks AS
> SELECT *,
>     ST_Difference(aoi.geom, lines.buffer_geom)
>     FROM aoi, lines;
>
> I get polygons, but not only the difference polygons!
>
> Thanks for all replies!
> Christopher
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
xmpp:me at komzpa.net mailto:me at komzpa.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141110/a3abe5ac/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ebebejfe.jpg
Type: image/jpeg
Size: 29320 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141110/a3abe5ac/attachment.jpg>