<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="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><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 class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> FROM impediments AS i </div>
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> WHERE st_dwithin( </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span>GeomFromText('POINT(-49.256452 -16.674886)',4326)::geography,</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span>i.geometry_data, </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> 300)</div>
</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
So far so good, however for coordinates outside the 'Brazil' displays the following error:</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Following SQL:</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">
<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 class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> FROM impediments AS i </div>
<div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> WHERE st_dwithin( </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span>GeomFromText('POINT(37.797848 -122.466774)',4326)::geography,</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline">
<span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span>i.geometry_data, </div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline"><span class="Apple-tab-span" style="margin:0px;padding:0px;border:0px;vertical-align:baseline;white-space:pre"> </span> 300) AND i.id_type =5</div>
</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)"><br></div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;background-color:rgb(255,255,255)">
<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>
</div><div style="margin:0px;padding:0px;border:0px;vertical-align:baseline;color:rgb(34,34,34);font-family:Arial,Helvetica,sans-serif;font-size:13px;background-color:rgb(255,255,255)">Diego.</div><div><br></div>