[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