[postgis-users] Error in spatial graph Table

[Suhr, Ralf]

Hi Frank,

better post to pgrouting-users at lists.postlbs.org

And you use a tolerance of 0.1 in assign_vertex_id(). All new start/ endpoints with a distance shorter then 0.1 will be mapped to existing nodes.

Gr Ralf


-----Ursprüngliche Nachricht-----
Von: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] Im Auftrag von FRANK RADA
Gesendet: Donnerstag, 25. Februar 2010 15:57
An: postgis-users at postgis.refractions.net
Betreff: [postgis-users] Error in spatial graph Table

Hi, i build a topology using pgrouting`s function
assign_vertex_id('vias', 0.1, 'the_geom', 'gid'); after that i found
one vertex that constains the follow structure
 as you see, the node_id code don`t appears in the column target_id.

the question is, is bad the graph?

this is the query from edges and node tables
"node_id";"name_street";"source_id";"target_id"
165;"AV0400000C070";165;151
165;"CL0900000C050";165;166
165;"CL0900000C060";165;164
165;"AV0400000C060";165;174

this is the aproximate graphical representation, the vertices of the
graph are connected to other edges, for simplify i put only the graph
shown in the table

                                          |
                                          |
                                          |
                     ---------------------*-----------------------
                                          |
                                          |
                                          |
* is the node which converge the edges.
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users