[postgis-users] ST_transform in PostGis 1.4.0 gives error

Ahlmark Johan Johan.Ahlmark at smhi.se
Sun Jan 17 23:32:31 PST 2010


Hi,

We recently updated PostGis to version 1.4.0 and after that we have a
problem when transforming projections. The problem I am facing is that I
want the ST-transform to return null if a projection is unable to be
transform and not and error. 

Example:

select st_transform(PointFromText('POINT(-117.157 32.7153)',4326),3021);

ERROR:  transform: couldn't project point (-117.157 32.7153 0): latitude
or longitude exceeded limits (-14)


I've tried some adjustments in proj4text definition of 3021, but that
has not helped. This is what I've tried:

Changed:
"+proj=tmerc +lat_0=0 +lon_0=15.80827777777778 +k=1 +x_0=1500000 +y_0=0
+ellps=bessel +units=m +no_defs"
To:
"+proj=tmerc +lat_0=0 +lon_0=15.80827777777778 +k=1 +x_0=1500000 +y_0=0
+ellps=bessel +units=m +nadgrids=@null +no_defs"

Is this the right approach? How should the proj4text be defined to get
it to work? Is there another way to do it?

Regards, Johan
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100118/13674124/attachment.html>


More information about the postgis-users mailing list