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

[Martin Davis]

Can you post the other geometry which is causing the error?

Alex Chew wrote:
> 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)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   

-- 
Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022