<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>ST_transform in PostGis 1.4.0 gives error</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"><FONT SIZE=2 FACE="Arial">Hi,</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">We recently updated PostGis to version 1.4.0 and after that we have a problem</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">when t</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">r</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">ansforming projections.</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">The problem I am facing is that</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">I</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">want the ST-transform to return null if a projection is unable to be</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">transform</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial"></FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">and not and error. </FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Example:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">select st_transform(PointFromText('POINT(-117.157 32.7153)',4326),3021);</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">ERROR: transform: couldn't project point (-117.157 32.7153 0): latitude or longitude exceeded limits (-14)</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<BR>
<P DIR=LTR><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">I</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">ve tried some adjustments in proj4text definition of 3021, but t</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">hat has not helped. This is what I</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">’</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">ve tried:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Changed:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">“</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">+proj=tmerc +lat_0=0 +lon_0=15.80827777777778 +k=1 +x_0=1500000 +y_0=0 +ellps=bessel +units=m +no_defs</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">”</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">To:</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">“</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">+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</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">”</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Is this the right</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"> <FONT SIZE=2 FACE="Arial">approach</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">?</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial"> How should the proj4text be defined to get it to work? Is there another way to do it?</FONT></SPAN></P>
<P DIR=LTR><SPAN LANG="en-gb"><FONT SIZE=2 FACE="Arial">Regards, Johan</FONT></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="sv"></SPAN><SPAN LANG="en-gb"></SPAN></P>
</BODY>
</HTML>