[postgis-users] Intersection errors

Darren Houston dhouston at beyondcompliance.ca
Mon Jun 6 19:29:50 PDT 2005


Hi Sean,

I'm correct in assuming the multipolygon posted is the geometry at 
layer=3? I received a false isvalid on that multipolygon.

'POSTGIS="1.0.1" GEOS="3.0.0" PROJ="Rel. 4.4.9, 29 Oct 2004" USE_STATS 
DBPROC="0.3.0" RELPROC="0.3.0"'

I'm in a rush, but I promise to look at it more tomorrow.

Darren H.

Sean M. Montague wrote:

>Several months ago I had posted on this list about some intersection
>problems I was having, but was never able to solve it.  I gave up with
>the intentions of revisiting it if version 1 did not fix the bug.  It
>has not.  The problem arises when trying to intersect one poly with
>another when it has holes.  If the intersecting poly partially overlays
>a hole, it throws an error.  Below is the geometry with holes and the
>two intersection statements.  The first works, it does not intersect any
>part of the hole.  The second fails.  I've tried to keep it simple.
>Thanks.
>
>Sean
>
>
>GeometryFromText('MULTIPOLYGON(((-244339 1210399, -244339 1541250, 21058
>1541250, 21058 1210399, -244339 1210399)),((-39283 1521307, -57692
>1518238, -64340 1511591, -62805 1497784, -54112 1494716, -45931 1494716,
>-40306 1494204, -38260 1493693, -34681 1482443, -42862 1471705, -50021
>1460966, -51044 1448182, -41840 1437955, -27522 1431307, -8601 1422614,
>603 1409318, 92 1392955, -13715 1377103, -46953 1370455, -68942 1365341,
>-91442 1342841, -91442 1309092, -81726 1303467, -2976 1329546, 13899
>1358182, 14921 1431818, -7067 1513125, -39283 1521307)))',32767)
>
>SELECT intersection(the_geom, PolygonFromText('POLYGON((-341457 1496785,
>-161897 1496785, -161897 1317225, -341457 1317225, -341457
>1496785))',32767))
>As the_geom
>>From test_02
>WHERE layer='3'
>AND the_geom && PolygonFromText('POLYGON((-341457 1496785, -161897
>1496785, -161897 1317225, -341457 1317225, -341457 1496785))',32767);
>
>Returns:
>"0103000020FF7F000001000000050000000000000098D30DC1000000006919344100000
>00098D30DC100000000D1D636410000000048C303C100000000D1D636410000000048C30
>3C100000000691934410000000098D30DC10000000069193441"
>
>
>
>SELECT intersection(the_geom, PolygonFromText('POLYGON((-213394 1467529,
>-33834 1467529, -33834 1287969, -213394 1287969, -213394
>1467529))',32767))
>As the_geom
>>From test_02
>WHERE layer='3'
>AND the_geom && PolygonFromText('POLYGON((-213394 1467529, -33834
>1467529, -33834 1287969, -213394 1287969, -213394 1467529))',32767);
>
>Returns:
>NOTICE:  AssertionFailedException: EdgeRing::computePoints: found null
>Directed Edge
>
>ERROR:  GEOS Intersection() threw an error!
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>  
>




More information about the postgis-users mailing list