[postgis-users] Error in spatial graph Table

FRANK RADA frankrada at gmail.com
Thu Feb 25 06:57:18 PST 2010


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.



More information about the postgis-users mailing list