Opened 7 years ago

Closed 7 years ago

#1784 closed defect (fixed)

ST_Transform failure

Reported by: georgevl Owned by: pramsey
Priority: medium Milestone: PostGIS 2.0.1
Component: postgis Version: 2.0.x
Keywords: Cc:

Description

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 behaviour.

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" LIBJSON="UNKNOWN" RASTER"

Change History (3)

comment:1 Changed 7 years ago by strk

Please update to PostGIS 2.0.0 final -- there have been some fixes to Proj4 error reporting.

comment:2 in reply to:  1 Changed 7 years ago by georgevl

Replying to strk:

Please update to PostGIS 2.0.0 final -- there have been some fixes to Proj4 error reporting.

Many thanks. Took me a while to figure out how but working now. Apologies.

comment:3 Changed 7 years ago by georgevl

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.