<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16625"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial>Tom,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial>I think the PostGIS 1.3 should error out too so probably a bug
in PostGIS 1.3 that was corrected in later releases.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial>The problem is 80 13 can't be projected to any area covered in
32613 (which is utm zone 13 covering a 6 degree strip )</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial>Just tested on my 1.5 and it errors out as
well.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial>Leo </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=802215921-17092010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of </B>Tom
Kessler<BR><B>Sent:</B> Friday, September 17, 2010 11:16 AM<BR><B>To:</B>
postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users]
Assistance with ST_Transform in Ver. 1.5.1returning projection
error<BR></FONT><BR></DIV>
<DIV></DIV>I recently upgraded from Postgis 1.3 to 1.5 and started seeing
projection errors returned from pgsql triggers. I was able to reduce the problem
to the behavior of this simple query: <BR><BR>In 1.3 the
following two queries work without error: <BR><BR>Select
astext(st_transform<BR>(GeomFromText('POINT( -80 13 )',4326),
32613))<BR><BR>Select astext(st_transform<BR>(GeomFromText('POINT( 80 13
)',4326), 32613))<BR><BR>In 1.5 the first query works and the second one returns
a "couldn't project point - lat or long exceeded limits error."<BR><BR>My 1.3
version is:<BR><BR>POSTGIS="1.3.1" GEOS="3.0.0rc4-CAPI-1.3.3" PROJ="Rel. 4.5.0,
22 Oct 2006" USE_STATS<BR><BR>My 1.5 full version is:<BR>POSTGIS="1.5.1"
GEOS="3.2.2-CAPI-1.6.2" PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.6.32"
USE_STATS<BR><BR>proj4text in both spatial_ref_sys SRID entries is
identical...Is this related to need for grid-shift files?<BR><BR>Thanks in
advance.<BR><BR>Tom<BR><BR><BR><BR><BR><BR><BR></BODY></HTML>