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 t
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).
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 en