[postgis-devel] [PostGIS] #765: Topology: error adding two edge with a common node

PostGIS trac at osgeo.org
Tue Jan 11 07:11:41 PST 2011


#765: Topology: error adding two edge with a common node
------------------------+---------------------------------------------------
  Reporter:  aperi2007  |       Owner:  strk         
      Type:  defect     |      Status:  closed       
  Priority:  medium     |   Milestone:  PostGIS 2.0.0
 Component:  topology   |     Version:  trunk        
Resolution:  wontfix    |    Keywords:               
------------------------+---------------------------------------------------
Changes (by aperi2007):

  * status:  new => closed
  * resolution:  => wontfix


Comment:

 I try even this other code:

 DROP TABLE IF EXISTS CARICAMENTO.TEST;
  CREATE TABLE CARICAMENTO.TEST(ID INTEGER PRIMARY KEY, CODICE TEXT);
  SELECT topology.DropTopology('schema_topo');
  SELECT topology.CreateTopology('schema_topo',3003, 0.00005);
  SELECT topology.AddTopoGeometryColumn('schema_topo', 'caricamento',
  'test', 'topo_line', 'LINE');
  --
  -- insert all edges
  --
  select topology.ST_AddIsoEdge(
      'schema_topo',
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(1
 4)')),
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(2
 2)')),
      ST_GeomFromEWKT('SRID=3003;LINESTRING(1 4, 2 2)')
  );

  select topology.ST_AddIsoEdge(
      'schema_topo',
     2, -- (2 is the code for the common node)
 topology.ST_AddIsoNode('schema_topo',NULL,ST_GeomFromEWKT('SRID=3003;POINT(4
 4)')),
      ST_GeomFromEWKT('SRID=3003;LINESTRING(2 2, 4 4)')
  );

 But in this case I have again another error:

  ERROR: SQL/MM Spatial exception - not isolated node

 So the ST_AddIsoEdge seem usable only to add isolated-edge.

 So I understand that ST_AddIsoEdge the prefix ISO is for Isolated don't
 for I.S.O.
 :))

 this is not a bug !

 close the ticket.

 sorry for noise.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/765#comment:1>
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