[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Longitude and latitude ranges
From:       Ture_Pålsson <ture.palsson () gmail ! com>
Date:       2011-08-30 6:11:05
Message-ID: CAPmMWuwh6pH2_RptmrKjuOLePEJb8197psOVh7i=ONghiFee8w () mail ! gmail ! com
[Download RAW message or body]

2011/8/29 Jaime Casanova <jaime@2ndquadrant.com>:
>> Perhaps this is a too-obvious question, but have you made sure that
>> you don't have some "bad" point, with latitude and/or longitude out of
>> range, that has somehow sneaked into your data set?
>>
>
> if i create geometry points it works like a charm, so i don't think so

The geometry datatype does very little in terms of sanity checks, it
will happily let you create all sorts of bizarre coordinates:

idf=> select st_asewkt(st_setsrid(st_makepoint(1000, 1000), 4326));
        st_asewkt
----------------------------
SRID=4326;POINT(1000 1000)
(1 row)


However, try to cast one of those to geography, and you're in trouble:

idf=> select st_asewkt(st_setsrid(st_makepoint(1000, 1000), 4326))::geography;
ERROR:  Coordinate values are out of range [-180 -90, 180 90] for GEOGRAPHY type

 -- T
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[prev in list] [next in list] [prev in thread] [next in thread]