<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Júlio,<br>
<br>
this would be done with ST_Difference(lines_geom, polygon_geom).<br>
<br>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/documentation/manual-1.5/ST_Difference.html">http://postgis.refractions.net/documentation/manual-1.5/ST_Difference.html</a><br>
<br>
Hope that helps,<br>
<br>
Birgit.<br>
<br>
<br>
Am 19.04.2011 16:49, schrieb Júlio Almeida:
<blockquote
cite="mid:BANLkTimjNyOxOgkRR8hcpDpXOpLrRv7UUA@mail.gmail.com"
type="cite">Hello,<br>
<br>
<br>
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).<br>
I have attached an image to illustrate.<br>
<br>
How can it be done?<br>
Thanks,<br>
<br>
julio<br>
<br>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
</body>
</html>