[pgrouting-users] Edge column in pgr_dijkstra

Stephen Woodbridge woodbri at swoodbridge.com
Tue Nov 19 11:52:39 PST 2013

Thanks Kaja,

I have the files that you attached.
I'll look at them when I get a chance.

You might want to read:

You can also run the graph analysis and node network on your data and 
see if that fixes things. Typically data from OSM is not noded correctly 
and needs to be noded to work with pgRouting.


On 11/17/2013 12:03 AM, Kaja wrote:
> Hi,
> I am using function pgr_dijkstra from pgrouting on a shape file I have
> attached here.
> The table from the shape file has following columns: gid, geom,
> start_id, end_id, length
> When I run the following code:
> SELECT seq, id1 AS node, id2 AS edge, cost FROM pgr_dijkstra('
>                  SELECT gid AS id,
>                  start_id::integer AS source,
> end_id::integer AS target,
> length AS cost
> FROM wp_norway_network',
>                  1,100, false, false);
> I am getting results with seq, node, edge and cost. But the values for
> the edge column has eight digit values which is not listed in my table.
> Is not it supposed to be the gid values of my table has to be given in
> the edge column?
> I have attached the files as well. You can see the screenshot of my
> tables here:
> http://gis.stackexchange.com/questions/77465/edge-column-in-pgr-dijkstra/
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users

More information about the Pgrouting-users mailing list