[postgis-devel] [PostGIS] #1784: ST_Transform failure

PostGIS trac at osgeo.org
Thu Apr 19 08:08:55 PDT 2012

#1784: ST_Transform failure
 Reporter:  georgevl  |       Owner:  pramsey      
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.1
Component:  postgis   |     Version:  2.0.x        
 Keywords:            |  
 Hi all,

 Trying to execute the following:

 SELECT ST_AsText(ST_Transform(ST_GeomFromText('POINT(2649262.94974021
 4579345.79221865)', 3785), 4326))

 I get:

 NOTICE:  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

 ERROR:  transform: couldn't project point (2.64926e+006 4.57935e+006 0):
 failed to load NAD27-83 correction file (-38)

 Based on various comments I found floating around the web, I tried the
 environment vars plus copying the zip file etc etc.

 The thing that strikes me as most important is that if I restart the PG
 Service and try the statement it works, but only once, all subsequent
 executions fail!

 SELECT postgis_full_version();

 "POSTGIS="2.0.0beta3 r9497" GEOS="3.3.3dev-CAPI-1.7.3" PROJ="Rel. 4.7.1,
 23 September 2009" GDAL="GDAL 1.9.0, released 2011/12/29" LIBXML="2.7.8"

Ticket URL: <http://trac.osgeo.org/postgis/ticket/1784>
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