<div dir="ltr">Hi Diego,<div><br></div><div style>What about remove <span style="font-family:Arial,Helvetica,sans-serif;font-size:13px">::</span><span style="font-family:Arial,Helvetica,sans-serif;font-size:13px">geography from your query?</span></div>
<div style><span style="font-family:Arial,Helvetica,sans-serif;font-size:13px"><br></span></div><div style><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Aug 5, 2013 at 3:26 PM, Diego Roberto <span dir="ltr"><<a href="mailto:diegorrborges@gmail.com" target="_blank">diegorrborges@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>Hello I am conducting a survey to check if a point that I am trying to insert already exists a point near recorded in a radius of 300 meters.</div>
<div>I use this query to perform this procedure:</div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">
<br></div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px"><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
SELECT i.id_impediments </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> FROM impediments AS i </div>
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> WHERE st_dwithin( </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span>GeomFromText('POINT(-49.256452 -16.674886)',4326)::geography,</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span>i.geometry_data, </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> 300)</div>
</div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px"><br></div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">
So far so good, however for coordinates outside the 'Brazil' displays the following error:</div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">
Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type<br></div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">
<br></div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">Following SQL:</div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">SELECT i.id_impediments </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> FROM impediments AS i </div>
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> WHERE st_dwithin( </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span>GeomFromText('POINT(37.797848 -122.466774)',4326)::geography,</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span>i.geometry_data, </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre-wrap"> </span> 300) AND i.id_type =5</div>
</div><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px"><br></div><div style="vertical-align:baseline;margin:0px;border:0px;padding:0px">
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#222222" face="Arial, Helvetica, sans-serif">How should I treat this information, can someone help me? The way I'm working is correct?</font></div>
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#222222" face="Arial, Helvetica, sans-serif"><br></font></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><font color="#222222" face="Arial, Helvetica, sans-serif">Thank you.</font></div>
<span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888"><div style="vertical-align:baseline;color:rgb(34,34,34);font-size:13px;font-family:Arial,Helvetica,sans-serif;margin:0px;border:0px;padding:0px">Diego.</div>
<div><br></div>
</font></span><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><div>Rogério De Pieri (Lelo)<br></div>MBA em Gerenciamento de Projetos - FGV<br><div><div>SCJP 5<br><div><div>Buscando melhorar a cada dia<br>
Áudio, Hardware & Software</div></div><div><a href="http://www.twitter.com/lelopieri" target="_blank">www.twitter.com/lelopieri</a></div><div><a href="http://blogdolelo.wordpress.com" target="_blank">blogdolelo.wordpress.com</a></div>
</div></div></div>
</div>