<a href="http://www.postgis.org/support/wiki/">http://www.postgis.org/support/wiki/</a><br><br><div><span class="gmail_quote">On 4/3/07, <b class="gmail_sendername">Mohammed Wahead</b> &lt;<a href="mailto:Mohammed.Wahead@cadcorp.com">
Mohammed.Wahead@cadcorp.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">






<div>


<p><font face="Arial" size="2">Hi folks,</font>
</p>

<p><font face="Arial" size="2">Can anyone point mw in the right direction. I would like examples of SQL syntax for running spatial searches in postgis. For example what is the SQL for determining which spatial features intersect with another spatial feature.
</font></p>

<p><font face="Arial" size="2">Thanks. </font>
</p>

<p><font color="#000080" face="Courier New" size="2">Mohammed Wahead</font><font color="#000080" face="Arial"></font> 

<br><font face="Verdana" size="2">&quot;Subscribe to Cadcorp eNews at </font><a><u><font color="#0000ff" face="Verdana" size="2">www.cadcorp.com</font></u></a><font face="Verdana" size="2">.&quot;</font><font face="Times New Roman">
<br>
<br>
</font><font color="#000080" face="Courier New" size="2">GIS &amp; RDBMS Specialist</font><br>
<font color="#000080" face="Courier New" size="2">Cadcorp</font><br>
<font color="#000080" face="Courier New" size="2">Computer Aided Development Corporation Ltd Sterling Court,</font><br>
<font color="#000080" face="Courier New" size="2">Norton Road,</font><br>
<font color="#000080" face="Courier New" size="2">Stevenage, Herts,</font><br>
<font color="#000080" face="Courier New" size="2">SG1 2JY, UK</font><br>
<font color="#000080" face="Courier New" size="2">Tel: +44 (0)1438 731440</font><br>
<font color="#000080" face="Courier New" size="2">Fax: +44 (0)1438 747997</font>
</p>

<br><br><table style="color: black;" bgcolor="white"><tbody><tr><td><br>****************************************************************************<br>
This&nbsp;email&nbsp;is&nbsp;confidential&nbsp;and&nbsp;may&nbsp;be&nbsp;privileged&nbsp;and&nbsp;should&nbsp;not&nbsp;be&nbsp;used,&nbsp;<br>
read&nbsp;or&nbsp;copied&nbsp;by&nbsp;anyone&nbsp;who&nbsp;is&nbsp;not&nbsp;the&nbsp;&nbsp;original&nbsp;intended&nbsp;recipient.&nbsp;If&nbsp;you&nbsp;<br>
have&nbsp;received&nbsp;this&nbsp;email&nbsp;in&nbsp;error&nbsp;&nbsp;please&nbsp;inform&nbsp;the&nbsp;sender&nbsp;and&nbsp;delete&nbsp;it&nbsp;<br>
from&nbsp;your&nbsp;mailbox&nbsp;or&nbsp;any&nbsp;other&nbsp;storage&nbsp;mechanism.&nbsp;Unless&nbsp;specifically&nbsp;<br>
stated,&nbsp;nothing&nbsp;in&nbsp;this&nbsp;email&nbsp;constitutes&nbsp;an&nbsp;offer&nbsp;by&nbsp;Cadcorp&nbsp;and&nbsp;Cadcorp&nbsp;<br>
does&nbsp;not&nbsp;warrant&nbsp;that&nbsp;any&nbsp;information&nbsp;contained&nbsp;in&nbsp;this&nbsp;email&nbsp;is&nbsp;accurate.&nbsp;<br>
Cadcorp&nbsp;cannot&nbsp;accept&nbsp;liability&nbsp;for&nbsp;any&nbsp;statements&nbsp;made&nbsp;which&nbsp;are&nbsp;clearly&nbsp;<br>
the&nbsp;sender&#39;s&nbsp;own&nbsp;and&nbsp;not&nbsp;expressly&nbsp;made&nbsp;on&nbsp;behalf&nbsp;of&nbsp;Cadcorp&nbsp;or&nbsp;one&nbsp;of&nbsp;its&nbsp;<br>
agents.&nbsp;Please&nbsp;rely&nbsp;on&nbsp;your&nbsp;own&nbsp;virus&nbsp;check.&nbsp;No&nbsp;responsibility&nbsp;is&nbsp;taken&nbsp;by&nbsp;<br>
Cadcorp&nbsp;for&nbsp;any&nbsp;damage&nbsp;arising&nbsp;out&nbsp;of&nbsp;any&nbsp;bug&nbsp;or&nbsp;virus&nbsp;infection.&nbsp;<br>
****************************************************************************</td></tr></tbody></table></div>
<br>_______________________________________________<br>postgis-users mailing list<br><a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net
</a><br><a onclick="return top.js.OpenExtLink(window,event,this)" href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br><br>
</blockquote></div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner