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 <[EMAIL PROTECTED]> 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@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users