<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2900.2873" name=GENERATOR></HEAD>
<BODY bgColor=#eaeaea>
<DIV>
<P><FONT face=宋体 size=2></FONT></P>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2><FONT face="Times New Roman"
size=3>Hi，Martin</FONT></FONT></FONT></DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2></FONT></FONT> </DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2><FONT face="Times New Roman"
size=3>This error is seperate from Intersection() error. Please show me
some tips, I am still underground.</FONT></FONT></FONT></DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2></FONT></FONT> </DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2>FW:<BR>I got an error said
POSTGIS2GEOS Conversion Fail.I made the query with BOX3D boundingbox.Could this
cause such an error? How can I come over? Thanks for your kindly
help.<BR>Followed my query and stack trace.</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2>SQL:<BR>SELECT
AsSVG(intersection(the_geom,GeometryFromText('POLYGON((1.835401366666<BR>667E7
3440267.666666667,1.844584833333333E7 3440267.666666667,1.844584833333333E<BR>7
3371624.333333333,1.835401366666667E7 3371624.333333333,1.835401366666667E7
34<BR>40267.666666667))',-1)),0,1) FROM roadurban WHERE the_geom &&
setSRID('BO<BR>X3D(1.835401366666667E7 3440267.666666667, 1.844584833333333E7
3371624.333333333<BR>)'::box3d,-1) and displayrank='4'</FONT></FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=宋体 size=2><FONT face=宋体 size=2>Stack
trace:<BR>org.postgresql.util.PSQLException: ERROR: POSTGIS2GEOS conversion
failed<BR> at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx<BR>ecutorImpl.java:1512)<BR>
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor<BR>Impl.java:1297)<BR>
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja<BR>va:188)<BR>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat<BR>ement.java:437)<BR>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract<BR>Jdbc2Statement.java:339)<BR>
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc<BR>2Statement.java:238) </FONT></FONT></DIV>
<DIV><FONT face=宋体 size=2> </FONT></DIV>
<DIV> </DIV></DIV></BODY></HTML>