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

Alex Chew alex_chew at 163.com
Mon Dec 11 18:27:00 PST 2006


Hi,
	I also got an error said GEOS Intersection() failed. Is this caused by the boundingbox BOX3D?
Or does something wrong with my data? Help please and thanks in advance.

Alex

SQL:
SELECT AsSVG(intersection(the_geom,GeometryFromText('POLYGON((1.836401366666
667E7 3432767.666666667,1.843584833333333E7 3432767.666666667,1.843584833333333E
7 3379124.333333333,1.836401366666667E7 3379124.333333333,1.836401366666667E7 34
32767.666666667))',-1)),0,1) FROM admarea WHERE the_geom && setSRID('BO
X3D(1.836401366666667E7 3432767.666666667, 1.843584833333333E7 3379124.333333333
)'::box3d,-1) and displayrank='4'

Stack trace:
org.postgresql.util.PSQLException: ERROR: GEOS Intersection() threw an error!
        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