[postgis-users] Postgis topology issue

[Sandro Santilli]

On Thu, Feb 09, 2012 at 05:01:15PM +0100, francescoboccacci at libero.it wrote:
> Hi all,
> i'm "playing" with Postgis 2.0 Topology function and i like it.. but i receive 
> this error:
> 
> ********** Error **********
> 
> ERROR: SQL/MM Spatial exception - point not on edge
> SQL state: P0001
> Context: PL/pgSQL function "topogeo_addpoint" line 66 at assignment
> PL/pgSQL function "topogeo_addlinestring" line 111 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 sample1.relation(topogeo_id, layer_id, 
> element_type, element_id) SELECT 5, 1, 3, topogeo_addPolygon('sample1', 
> '0103000000010000000A00000000000080AB6829413789412068EB284137894160A9682941000000002BEB2841C976BEDFA5682941000000C0C0EA2841C976BE1FA4682941378941A08AEA28410000008049682941378941A08DEA2841C976BE5F4B68294100000080C5EA2841000000804B68294100000080C7EA2841000000004F682941000000402FEB28410000000051682941000000406BEB284100000080AB6829413789412068EB2841'::
> geometry, 0);"
> PL/pgSQL function "totopogeom" line 125 at EXECUTE statement
> 
> 
> 
> these are my query that are "copy and paste " from 
> 
> http://postgis.refractions.net/pipermail/postgis-users/2012-January/032169.
> html
> 
> --Create new togology ---
> SELECT CreateTopology('sample1');
> 
> --Add topoGeomColumn---
> SELECT AddTopoGeometryColumn('sample1',
>                               'public', 'small_polygon', 'topogeom',
>                               'POLYGON');
> 
> 
>                               
> UPDATE small_polygon SET topogeom = toTopoGeom(the_geom, 'sample1',1);
> 
> Do you have any suggestion? maybe i used a a wrong geometry..

It's a bug, what you can do:

 1) Make sure you're running the latest PostGIS version.
    This includes re-loading all the SQL files 
 2) Reduce your input as much as possible while still 
    triggering the error
 3) Attach your reduced input to a ticket on
    http://trac.osgeo.org/postgis

Hopefully (1) will fix !

--strk; 

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net
  `-o------'