[postgis-users] problem with POSTGIS2GEOS Conversion Fail

Alex Chew alex_chew at 163.com
Mon Dec 11 18:20:35 PST 2006


Hi,
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)





More information about the postgis-users mailing list