Hello,<br><br>the SRID definition in spatial_ref_sys is exactly the same. Remember that I am restoring the same database dump in two different DBMS.<br><br>The information:<br><br>First DBMS:<br><br>SELECT version(), postgis_full_version();<br>
<br>"PostgreSQL 8.2.13 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)";"POSTGIS="1.3.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS DBPROC="0.3.0" RELPROC="1.3.1" (needs proc upgrade)"<br>
<br>spatial_ref_sys<br><br>4326;"EPSG";4326;"GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]";"+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs "<br>
<br>23029;"EPSG";23029;"PROJCS["ED50 / UTM zone 29N",GEOGCS["ED50",DATUM["European_Datum_1950",SPHEROID["International 1924",6378388,297,AUTHORITY["EPSG","7022"]],AUTHORITY["EPSG","6230"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4230"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-9],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","23029"]]";"+proj=utm +zone=29 +ellps=intl +units=m +no_defs "<br>
<br>Second DBMS:<br><br>SELECT version(), postgis_full_version();<br><br>"PostgreSQL 8.2.13 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)";"POSTGIS="1.3.6" GEOS="3.1.0-CAPI-1.5.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS DBPROC="0.3.0" RELPROC="1.3.6" (needs proc upgrade)"<br>
<br>spatial_ref_sys<br><br>4326;"EPSG";4326;"GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]]";"+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs "<br>
<br>23029;"EPSG";23029;"PROJCS["ED50 / UTM zone 29N",GEOGCS["ED50",DATUM["European_Datum_1950",SPHEROID["International 1924",6378388,297,AUTHORITY["EPSG","7022"]],AUTHORITY["EPSG","6230"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4230"]],PROJECTION["Transverse_Mercator"],PARAMETER["latitude_of_origin",0],PARAMETER["central_meridian",-9],PARAMETER["scale_factor",0.9996],PARAMETER["false_easting",500000],PARAMETER["false_northing",0],UNIT["metre",1,AUTHORITY["EPSG","9001"]],AUTHORITY["EPSG","23029"]]";"+proj=utm +zone=29 +ellps=intl +units=m +no_defs "<br>
<br>Thank you very much in advance.<br><br>Best regards,<br>  Miguel<br><br><div class="gmail_quote">On Tue, May 26, 2009 at 1:39 PM, Mark Cave-Ayland <span dir="ltr"><<a href="mailto:mark.cave-ayland@siriusit.co.uk">mark.cave-ayland@siriusit.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">Miguel R. Luaces wrote:<br>
<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Dear all,<br>
<br>
we have a PostgreSQL 8.1 database with postgis 1.2 installed. We have some data in the database stored using EPSG:23029.<br>
<br>
We make a backup with pg_dump and we restore the database in PostgreSQL 8.2 with Postgis 1.3.1 without any problem.<br>
<br>
But, if we restore the backup in PostgreSQL 8.2 with Postgis 1.3.6, the function transform() returns a different result. More precisely:<br>
<br>
The same query:<br>
<br>
select astext(the_geom), astext(transform(the_geom)) from monumentos where id = ,<br>
<br>
In Postgis 1.3.1:<br>
<br>
"Castelo de San Antón";"POINT(549556.009066526 4801796.3531214)";"POINT(-8.38839299999999 43.3657910268222)"<br>
<br>
In Postgis 1.3.6:<br>
<br>
"Castelo de San Antón";"POINT(549556.009066526 4801796.3531214)";"POINT(-8.38839299999999 43.3666118995462)"<br>
<br>
The second coordinate of the transformation to 4326 changes by 0.004 degrees (approx).<br>
<br>
Any idea?<br>
<br>
Thank you very much in advance.<br>
<br>
Best regards,<br>
  Miguel<br>
</blockquote>
<br>
<br></div></div>
Hi Miguel,<br>
<br>
What versions of PostgreSQL/PostGIS are you using on both servers, and with which versions of the PROJ.4 library?<br>
<br>
SELECT version(), postgis_full_version();<br>
<br>
Also can you confirm that the spatial_ref_sys entries for 23029 and 4326 are identical between the two servers?<br>
<br>
<br>
ATB,<br>
<br>
Mark.<br><font color="#888888">
<br>
-- <br>
Mark Cave-Ayland - Senior Technical Architect<br>
PostgreSQL - PostGIS<br>
Sirius Corporation plc - control through freedom<br>
<a href="http://www.siriusit.co.uk" target="_blank">http://www.siriusit.co.uk</a><br>
t: +44 870 608 0063</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</div></div></blockquote></div><br>