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

PostGIS trac at osgeo.org
Thu Jan 20 07:02:06 PST 2011


#318: 900913->4326 Transform
---------------------+------------------------------------------------------
 Reporter:  pramsey  |       Owner:  mcayland     
     Type:  defect   |      Status:  new          
 Priority:  medium   |   Milestone:  PostGIS 1.4.3
Component:  postgis  |     Version:  trunk        
 Keywords:           |  
---------------------+------------------------------------------------------

Comment(by pbalomiri):

 Hi,
 I got this bug too. I am working on os/x
 The lib versions are:
 {{{
 template_postgis=# select * from postgis_version();
             postgis_version
 ---------------------------------------
  1.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

 template_postgis=# select * from postgis_proj_version();
      postgis_proj_version
 -------------------------------
  Rel. 4.7.1, 23 September 2009
 }}}

 The Error consistently appears when using SRID 4326:
 {{{
 wien_python=# select st_transform(st_transform('srid=4326;POINT(1
 1)'::geometry, 900913), 4326);
 ERROR:  transform: couldn't project point (111319 111325 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.

 For SRID 4267, however it works
 }}}
 wien_python=# select ST_Transform('SRID=900913;POINT(653103 6.63036e+06
 0)'::geometry, 4267);
                             st_transform
 --------------------------------------------------------------------
  01010000A0AB10000037CD83F1BA771740E31A12928E8649400000000000000000
 (1 row)
 {{{

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/318#comment:23>
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.


More information about the postgis-devel mailing list