[OpenLayers-Dev] PostGIS and OL disagree

[Eric Lemoine]

On Mon, Jun 15, 2009 at 8:52 AM, Christopher
Schmidt<crschmidt at metacarta.com> wrote:
> On Sat, Jun 13, 2009 at 10:16:25PM +0200, Eric Lemoine wrote:
>> Hello
>>
>> I noticed that PostGIS and OpenLayers don't give the same result when
>> reprojecting a point from 4326 to 900913.
>
> Sounds like:
>  * proj is out of date or
>  * You don't have the 'null' gridshift file.
>
> u=# insert into spatial_ref_sys VALUES (900913, 'EPSG', 900913, '', '+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +no_defs');
> INSERT 0 1

I deleted the srid=900913 row from the spatial_ref_sys table,
reinserted it with the above statement, it works now. I had something
wrong in my proj string or something.

Thanks Chris,

-- 
Eric Lemoine

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex

Tel : 00 33 4 79 44 44 96
Mail : eric.lemoine at camptocamp.com
http://www.camptocamp.com