[postgis-users] Clip and select outside an polygon

[Birgit Laggner]

Hi Júlio,

this would be done with ST_Difference(lines_geom, polygon_geom).

http://postgis.refractions.net/documentation/manual-1.5/ST_Difference.html

Hope that helps,

Birgit.


Am 19.04.2011 16:49, schrieb Júlio Almeida:
> Hello,
>
>
> I need to clip/trim from a geometry the geometries that 
> ST_Intersection(r.the_geom, m.the_geom) and select the geometries that 
> area outside of an ST_Intersection(r.the_geom, m.the_geom).
> I have attached an image to illustrate.
>
> How can it be done?
> Thanks,
>
> julio
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110421/7cc73f92/attachment.html>