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

[Stephen Davies]

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 <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