[postgis-users] How does PostGIS treat "garbage" lat/long coords?

[Paul Ramsey]

This?

select id from thetable where st_xmax(the_geom) > 180 or
st_xmin(the_geom) < -180 or st_ymax > 90 or st_ymin < -90;

P

On Sun, Apr 20, 2008 at 12:44 AM, Stephen Davies <sdc at sdc.com.au> wrote:
> One of my users has been entering garbage lat/long coordinates for geometries
>  (SRID 4283). eg POINT(140.6365441 -304.409527) instead of
>  POINT(140.6365441 -34.409527)
>
>  PostGIS does not object to this but I cannot see what the value is interpreted
>  to mean.
>  Is there a simple way to test for such entries?
>
>  Cheers and thanks,
>  Stephen Davies
>  --
>  ========================================================================
>  This email is for the person(s) identified above, and is confidential to
>  the sender and the person(s).  No one else is authorised to use or
>  disseminate this email or its contents.
>
>  Stephen Davies Consulting                            Voice: 08-8177 1595
>  Adelaide, South Australia.                             Fax: 08-8177 0133
>  Computing & Network solutions.                       Mobile:0403 0405 83
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>