<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EstiloCorreo17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=ES link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Hi List,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>I’ve a question about the CROSSES (geometry,
geometry) function. I’d like to use it to select lines from a table that
do not cross, or intersect, some polygons in a separate table. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>The following script lets me select the lines that
cross the polygons:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>SELECT <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'> lines.*<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>FROM <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'> lines,
<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'> polygons<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>WHERE <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'> CROSSES(lines.the_geom,
polygons.the_geom)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Now I’d like to place a ‘NOT’
before the function CROSSES (-> NOT CROSSES(lines.the_geom, polygons.the_geom),
rather naively it seems, as doing that returns me a table with the same
geometry as the original layer, but with 30 times more rows (an increase of 400
to 12,000 records). In other words, it hasn’t ‘selected’ and
lines out of the layer, merely repeated the table geometry 30 times.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Can anybody explain where I’m going wrong?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Many thanks in advance,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'>Matt<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span lang=EN-GB style='font-size:
10.0pt;font-family:Arial'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellpadding=0 align=left width="100%"
bgcolor=white style='width:100.0%;background:white'>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span lang=EN-GB style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td width="62%" style='width:62.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span lang=EN-GB style='font-size:12.0pt;font-family:Arial;
color:#2E3A75'>Matt Doughty</span></font><span lang=EN-GB><o:p></o:p></span></p>
</td>
<td width="37%" rowspan=5 valign=top style='width:37.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><img width=90
height=100 id="_x0000_i1025" src="cid:image001.jpg@01C7A9C4.927231B0"></span></font><span
lang=EN-GB><o:p></o:p></span></p>
</td>
</tr>
<tr>
<td width="62%" style='width:62.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span lang=EN-GB style='font-size:12.0pt;font-family:Arial;
color:#2E3A75'>GEOGRAMA </span></font><font color="#2e3a75" face=Arial><span
style='font-family:Arial;color:#2E3A75'>S.L.</span></font><font face=Arial><span
style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td width="62%" style='width:62.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Tel.:
+34 945 13 13 72 652 77 14 15</span></font><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td width="62%" style='width:62.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'>Fax:
+34 945 23 03 40 </span></font><font face=Arial><span style='font-family:
Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td width="62%" style='width:62.06%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3 color="#2e3a75"
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:#2E3A75'><a
href="http://www.geograma.com/">www.geograma.com</a></span></font><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></p>
</td>
</tr>
<tr>
<td colspan=2 style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal style='mso-element:frame'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'> <o:p></o:p></span></font></p>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>