<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7651.59">
<TITLE>Examples SQL for spatial searches in post gis eg intersect</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi folks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">Thanks. </FONT>
</P>
<P><FONT COLOR="#000080" SIZE=2 FACE="Courier New">Mohammed Wahead</FONT><FONT COLOR="#000080" FACE="Arial"></FONT>
<BR><FONT SIZE=2 FACE="Verdana">"Subscribe to Cadcorp eNews at </FONT><A HREF="file://www.cadcorp.com"><U><FONT COLOR="#0000FF" SIZE=2 FACE="Verdana">www.cadcorp.com</FONT></U></A><FONT SIZE=2 FACE="Verdana">."</FONT><FONT FACE="Times New Roman"><BR>
<BR>
</FONT><FONT COLOR="#000080" SIZE=2 FACE="Courier New">GIS & RDBMS Specialist</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Cadcorp</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Computer Aided Development Corporation Ltd Sterling Court,</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Norton Road,</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Stevenage, Herts,</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">SG1 2JY, UK</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Tel: +44 (0)1438 731440</FONT><BR>
<FONT COLOR="#000080" SIZE=2 FACE="Courier New">Fax: +44 (0)1438 747997</FONT>
</P>
<br><br><table bgcolor=white style="color:black"><tr><td><br>****************************************************************************<br>
This email is confidential and may be privileged and should not be used, <br>
read or copied by anyone who is not the original intended recipient. If you <br>
have received this email in error please inform the sender and delete it <br>
from your mailbox or any other storage mechanism. Unless specifically <br>
stated, nothing in this email constitutes an offer by Cadcorp and Cadcorp <br>
does not warrant that any information contained in this email is accurate. <br>
Cadcorp cannot accept liability for any statements made which are clearly <br>
the sender's own and not expressly made on behalf of Cadcorp or one of its <br>
agents. Please rely on your own virus check. No responsibility is taken by <br>
Cadcorp for any damage arising out of any bug or virus infection. <br>
****************************************************************************</td></tr></table></BODY>
</HTML>