Stephen,<br><br>To add to what Paul said, you can also put a constraint on your table with the check to make sure no values outside of the correct range make it into the table in the first place.<br><br>David<br><br><div class="gmail_quote">
On Sun, Apr 20, 2008 at 5:20 PM, Paul Ramsey <<a href="mailto:pramsey@cleverelephant.ca">pramsey@cleverelephant.ca</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
This?<br>
<br>
select id from thetable where st_xmax(the_geom) > 180 or<br>
st_xmin(the_geom) < -180 or st_ymax > 90 or st_ymin < -90;<br>
<font color="#888888"><br>
P<br>
</font><div><div></div><div class="Wj3C7c"><br>
On Sun, Apr 20, 2008 at 12:44 AM, Stephen Davies <<a href="mailto:sdc@sdc.com.au">sdc@sdc.com.au</a>> wrote:<br>
> One of my users has been entering garbage lat/long coordinates for geometries<br>
> (SRID 4283). eg POINT(140.6365441 -304.409527) instead of<br>
> POINT(140.6365441 -34.409527)<br>
><br>
> PostGIS does not object to this but I cannot see what the value is interpreted<br>
> to mean.<br>
> Is there a simple way to test for such entries?<br>
><br>
> Cheers and thanks,<br>
> Stephen Davies<br>
> --<br>
> ========================================================================<br>
> This email is for the person(s) identified above, and is confidential to<br>
> the sender and the person(s). No one else is authorised to use or<br>
> disseminate this email or its contents.<br>
><br>
> Stephen Davies Consulting Voice: 08-8177 1595<br>
> Adelaide, South Australia. Fax: 08-8177 0133<br>
> Computing & Network solutions. Mobile:0403 0405 83<br>
> _______________________________________________<br>
> postgis-users mailing list<br>
> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
> <a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>************************************<br>David William Bitner