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

Miguel R. Luaces miguelrluaces at gmail.com
Tue May 26 02:12:18 PDT 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090526/93e97fda/attachment.html>


More information about the postgis-users mailing list