[postgis-users] GEOS Intersection() threw an error, help please

Alex Chew alex_chew at 163.com
Tue Dec 12 18:16:09 PST 2006


Hi,Martin

This error is seperate from Intersection() error. Please show me some tips, I am still underground.

FW:
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.
Followed my query and stack trace.

SQL:
SELECT AsSVG(intersection(the_geom,GeometryFromText('POLYGON((1.835401366666
667E7 3440267.666666667,1.844584833333333E7 3440267.666666667,1.844584833333333E
7 3371624.333333333,1.835401366666667E7 3371624.333333333,1.835401366666667E7 34
40267.666666667))',-1)),0,1) FROM roadurban WHERE the_geom && setSRID('BO
X3D(1.835401366666667E7 3440267.666666667, 1.844584833333333E7 3371624.333333333
)'::box3d,-1) and displayrank='4'

Stack trace:
org.postgresql.util.PSQLException: ERROR: POSTGIS2GEOS conversion failed
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:1512)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1297)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:188)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:437)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:339)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc
2Statement.java:238)       
               
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061213/8f9b97d6/attachment.html>


More information about the postgis-users mailing list