<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8">
<title></title>
<meta name="GENERATOR" content="OpenOffice.org 3.1 (Linux)">
<style type="text/css">
<!--
@page { margin: 0.79in }
P { margin-bottom: 0.08in }
P.code-western { margin-bottom: 0in; background: #f3f3f3; border: 1px solid #000000; padding: 0.02in; font-family: "Courier New", monospace; font-size: 10pt; so-language: zxx; line-height: 100%; page-break-before: auto }
P.code-cjk { margin-bottom: 0in; background: #f3f3f3; border: 1px solid #000000; padding: 0.02in; line-height: 100%; page-break-before: auto }
P.code-ctl { margin-bottom: 0in; background: #f3f3f3; border: 1px solid #000000; padding: 0.02in; line-height: 100%; page-break-before: auto }
--Lie</style>Liem,<br><br>You may want to check out http://postgis.refractions.net/documentation/manual-1.4/ST_Contains.html for the ST_Contains function. Hope this helps.<br><br>Kind regards,<br><br>Edward Mac Gillavry<br><br><hr id="stopSpelling">Date: Mon, 10 May 2010 11:29:27 +0700<br>From: liemnguyendl@gmail.com<br>To: postgis-users@postgis.refractions.net<br>Subject: [postgis-users] using "&&" oprerator<br><br><br clear="all">Hi All, i'm a newbie with postgis and probably this is an easy question.<br><br>As I know "&&" operator which is used for checking 1 geometry is overlap on another or not.<br>Could I check 1 point is overlap on 1 polygon by the query bellow ?<br>
<pre style="color: rgb(51, 0, 153);"><font size="4"><code>SELECT f.point_id, s.zip_id<br>FROM points f, zips s <br>WHERE ST_SetSRID(ST_MakePoint(f.longitude, f.latitude),4326) && s.zip_polygon;<br></code></font><br><br><font style="color: rgb(0, 153, 0);" size="4">Does anything wrong here? Or could you give me other ways to check 1 point is within in 1 polygon or not?</font><br></pre>Cheers.<br>-- <br>Liem Nguyen<br>Developer<br>Axon Active Corp.<br>
----------------------------------------------------------------------------<br>Direct Line : +84 38 948 4645<br>Fax : +84 38 811 3489<br>Mobile Phone : +84 168 994 8897<br>Skype ID : liemnguyendl2204<br>
Email : <a href="mailto:liem.nguyen@axonactive.net">liem.nguyen@axonactive.net</a> / <a href="mailto:liemnguyendl@gmail.com">liemnguyendl@gmail.com</a><br>Web Site : <a href="http://axonactive.vn">http://axonactive.vn</a><br>
Address : 87 Thang Long Street,Gate 2 Ward 4,<br> Tan Binh District, HCM city, Vietnam.<br><br> </body>
</html>