[postgis-users] google -> wgs conversion (failed to load NAD27-83 correction file)

[Jaak Laineste]

Hi,

 

 I seem to have blind spot somewhere. I can convert wgs->google coordinate
system fine:

select astext(transform(geomfromtext('POINT(-22.19921875 1.47265625)',4326),
900913));

 -> "POINT(-2471205.72725849 163953.396913543)"

 

But when try to convert it back:

 

select st_asewkt(transform(geomfromtext('POINT(-2471205.72725849
163953.396913543)',900913), 4326));

 

then I get absurd numbers:

 

 -> "SRID=4326;POINT(-3.48051770446448e-06 2.30891282668362e-07)"

 

And there is also message: WARNING:  transform: -38 (failed to load NAD27-83
correction file)

 

In other machine (windows btw) same query works fine. 

 

After restart of the database (postgis which is debian) it worked exactly
one time. See 2 identical queries in a row:

 

gis=# select st_asewkt(st_transform(geomfromtext('POINT(-2471205.72725849
163953.396913543)',900913), 4326));

                   st_asewkt

------------------------------------------------

 SRID=4326;POINT(-22.19921875 1.47265624999999)

(1 row)

 

gis=# select st_asewkt(st_transform(geomfromtext('POINT(-2471205.72725849
163953.396913543)',900913), 4326));

WARNING:  transform: -38 (failed to load NAD27-83 correction file)

                          st_asewkt

-------------------------------------------------------------

 SRID=4326;POINT(-3.48051770446448e-06 2.30891282668362e-07)

(1 row)

 

Reinstalling postgis packages, including proj did not help. I have postgres
8.3 with 1.3.3-3 (from postgresql-8.3-postgis debian package). I triad also
with 1.3.5 postgis which was latest debian package what I found, same thing

 

Also I do not get what all this has to do with "NAD27-83 correction"

 

 

/Jaak Laineste

jaak at nutiteq.com

Skype: nutiteq

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090724/d59aec08/attachment.html>