[postgis-users] Is -180 longitude valid for wgs84?

Paul Ramsey pramsey at refractions.net
Thu Aug 3 14:52:57 PDT 2006


The problem is one of model: PostGIS supports only cartesian 
coordinates.  You want your lat/lon coordinates to be treated as 
spherical coordinates.

<http://postgis.refractions.net/support/wiki/index.php?WishList>

Peter Fay wrote:
> Hi,
> 
> I have some points in a coastline database (GSHHS) that have 
> longitude=-180.  When equal points are compared, for example,
> 
> select equals(geomfromtext('POINT(180 20)', 4326), 
> geomfromtext('POINT(-180 20)', 4326))
> 
> the result is false.  Is the problem here invalid data (one can’t use 
> -180 in SRID 4326) or is it a bug in postgis?
> 
> Or worse, neither – do I always need to normalize every longitude in 
> case it happens to be -180?



More information about the postgis-users mailing list