[postgis-users] simple polygon clip

[Christopher Braune]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141110/babfbd3f/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/babfbd3f/attachment.jpg>