Thanks guys. I shall go with the constraint idea using Paul's syntax. BTW, where is POINT(140.6365441 -304.409527)?
Cheers, Stephen >Stephen, > >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. > >David > >On Sun, Apr 20, 2008 at 5:20 PM, Paul Ramsey <[EMAIL PROTECTED]> >wrote: > >> 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 [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
