[postgis-devel] [PostGIS] #318: 900913->4326 Transform

[PostGIS]

#318: 900913->4326 Transform
----------------------+-----------------------------------------------------
  Reporter:  pramsey  |       Owner:  mcayland     
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.4.1
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by robe):

 Guys,

 I can produce this error on my PostGIS 1.5SVN windows install

 {{{
 SELECT
 ST_ASTEXT(ST_Transform(ST_SetSRID(ST_Point(-305748.113141,7834489.65112),900913),4267));


 Yields:
 couldn't project point (-305748 7.83449e+006 0): failed to load NAD27-83
 correction file (-38)
 HINT:  PostGIS was unable to transform the point because either no grid
 shift files were found, or the point does not lie within the range for
 which the grid shift is defined. Refer to the ST_Transform() section of
 the PostGIS manual for details on how to configure PostGIS to alter this
 behaviour.

 This could possibly be the same problem we ran across in #387 that the
 proj4text is simply different, or possibly I'm using an out of date set of
 datum shift files.


 }}}

 I tried my 1.3.6 install, and that doesn't even have this entry.  It is my
 understanding that this is a defunct srid put in a while ago before there
 was an official google mercator EPSG SRID, so its highly likely everyones
 is slightly different unless they reloaded their spatial_ref_sys.

 Mine reads:

 {{{
 SELECT proj4text from spatial_ref_sys where srid = 900913;


 +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0
 +units=m +k=1.0 +nadgrids=@null +no_defs
 }}}


 and I'm running proj 4.6.1

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/318#comment:14>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.