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 <[email protected]>:
> 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
> [email protected]
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
--
Darafei "Komяpa" Praliaskouski
OSM BY Team - http://openstreetmap.by/
xmpp:[email protected] mailto:[email protected]
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
