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

[David William Bitner]

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 <pramsey at cleverelephant.ca>
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 <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
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



-- 
************************************
David William Bitner
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080421/a28696ab/attachment.html>