<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY><FONT color=#0000ff>
<P><SPAN class=671541305-25062003><FONT face=Arial color=#000000 size=2>I'm
having a problem with the transform function in Postgis. If I run the following
query:</FONT></SPAN></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P></FONT><FONT face=Arial><FONT size=2><FONT color=#0000ff>select</FONT>
transform(GeometryFromText('MULTIPOLYGON(((112 -45 ,112 -10 ,155 -10 ,155
-45,112 -45)))',4326),54004)</FONT></FONT></P></BLOCKQUOTE>
<P><SPAN class=671541305-25062003><FONT face=Arial size=2>I
get:</FONT></SPAN></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><SPAN class=671541305-25062003></SPAN><SPAN class=671541305-25062003><FONT
face=Arial size=2>SRID=54004;MULTIPOLYGON(((12467782.9688466
-5591295.91855339,12467782.9688466 -1111475.10285223,17254521.0729574
-1111475.10285223,17254521.0729574 -5591295.91855339,12467782.9688466
-5591295.91855339)))</FONT></SPAN></P></BLOCKQUOTE>
<P><SPAN class=671541305-25062003><FONT face=Arial size=2>But if I
do:</FONT></P></SPAN>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><FONT face=Arial size=2>select
transform(GeometryFromText('MULTIPOLYGON(((-180 -90 ,-180 90 ,180 90 ,180
-90,-180 -90)))',4326),54004)</FONT></P></BLOCKQUOTE>
<P><SPAN class=671541305-25062003><FONT face=Arial size=2>I
get:</FONT></SPAN></P>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<P><SPAN class=671541305-25062003><FONT face=Arial size=2>Error: transform:
couldn't project polygon<BR></FONT></SPAN><SPAN class=671541305-25062003><FONT
face=Arial size=2>Warning: Error occurred while executing PL/pgSQL function
transform<BR>Warning: line 2 at return</FONT></SPAN></P></BLOCKQUOTE>
<P dir=ltr><SPAN class=671541305-25062003><FONT face=Arial size=2>Any ideas why?
I turned the postgresql log level to debug5 to see if I could get more detailed
errors, but it's exactly the same error. I'm running postgresql 7.3.2, postgis
0.7.5 and proj 4.4.7</FONT></SPAN></P>
<P dir=ltr><SPAN class=671541305-25062003><FONT face=Arial
size=2>Thanks,</FONT></SPAN></P>
<P dir=ltr><SPAN class=671541305-25062003><FONT face=Arial size=2>Benjamin
Wragg</FONT></SPAN></P></BODY></HTML>