[postgis-users] Re: Coordinate changes using transform from 1.3.1 to 1.3.6

[Ivan Mincik]

Can You check if there is no change in proj parameters for Your projection ? You will find proj parameters in spatial_ref_sys table. 
Ivan

On Tuesday 26 May 2009, Miguel R. Luaces wrote:
> The query should be:
> 
> select nome, astext(the_geom), astext(transform(the_geom, 4326)) from
> monumentos where id = 9;
> 
> Copy-paste mistake. The problem still remains...
> 
> Best regards,
>   Miguel
> 
> On Tue, May 26, 2009 at 11:12 AM, Miguel R. Luaces
> <miguelrluaces at gmail.com>wrote:
> 
> > Dear all,
> >
> > we have a PostgreSQL 8.1 database with postgis 1.2 installed. We have some
> > data in the database stored using EPSG:23029.
> >
> > We make a backup with pg_dump and we restore the database in PostgreSQL 8.2
> > with Postgis 1.3.1 without any problem.
> >
> > But, if we restore the backup in PostgreSQL 8.2 with Postgis 1.3.6, the
> > function transform() returns a different result. More precisely:
> >
> > The same query:
> >
> > select astext(the_geom), astext(transform(the_geom)) from monumentos where
> > id = ,
> >
> > In Postgis 1.3.1:
> >
> > "Castelo de San Antón";"POINT(549556.009066526
> > 4801796.3531214)";"POINT(-8.38839299999999 43.3657910268222)"
> >
> > In Postgis 1.3.6:
> >
> > "Castelo de San Antón";"POINT(549556.009066526
> > 4801796.3531214)";"POINT(-8.38839299999999 43.3666118995462)"
> >
> > The second coordinate of the transformation to 4326 changes by 0.004
> > degrees (approx).
> >
> > Any idea?
> >
> > Thank you very much in advance.
> >
> > Best regards,
> >   Miguel
> >
> >
> >
>