[postgis-devel] [PostGIS] #1641: SQL/MM Spatial exception - geometry crosses an edge

PostGIS trac at osgeo.org
Thu Mar 1 02:25:54 PST 2012


#1641: SQL/MM Spatial exception - geometry crosses an edge
----------------------+-----------------------------------------------------
 Reporter:  lrssvt    |       Owner:  strk         
     Type:  defect    |      Status:  new          
 Priority:  medium    |   Milestone:  PostGIS 2.0.0
Component:  topology  |     Version:  2.0.x        
 Keywords:            |  
----------------------+-----------------------------------------------------
 Running SQL script (attached file polyTopo) I get the following error for
 my layer (attached file layerPoly).

 {{{
 ERROR:  SQL/MM Spatial exception - geometry crosses an edge
 CONTEXT: PL/pgSQL function "topogeo_addlinestring" line 143 at assignment
 SQL statement "SELECT array_cat(edges, array_agg(x)) FROM ( select
 topology.TopoGeo_addLinestring(atopology, rec.geom, tolerance) as x ) as
 foo"
 PL/pgSQL function "topogeo_addpolygon" line 23 at assignment
 SQL statement "INSERT INTO poly_topo.relation(topogeo_id, layer_id,
 element_type, element_id) SELECT 2, 1, 3, topogeo_addPolygon('poly_topo',
 '0103000020BC0B0000010000000A000000640FEAD1CAC0DABFA8D653CFF82FE43F807A7AC40C63C9BF0CABC1DC9906E43FB8E2E5B7779ECCBF751D41DFF25ADE3F6084AF11173FC23FF783D649EFFDD93F803B8CFD12DBABBFAE520CA6A8F4C43F785AF3A726AEC93FA0F9F2CB618885BF00B612B697557ABFB4386EE1F850B9BF00CEDC644808873FFF54F94ABD5AC6BF18995CCF8903C0BF3A9BD621CEC4C3BF640FEAD1CAC0DABFA8D653CFF82FE43F'::geometry,
 0);"
 PL/pgSQL function "totopogeom" line 125 at EXECUTE statement
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1641>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.


More information about the postgis-devel mailing list