[pgrouting-users] Edge column in pgr_dijkstra

Kaja kajdotnet at gmail.com
Sat Nov 16 21:03:17 PST 2013


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/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wp_norway_network_test.dbf
Type: application/octet-stream
Size: 106025 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0005.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wp_norway_network_test.prj
Type: application/octet-stream
Size: 143 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0006.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wp_norway_network_test.qpj
Type: application/octet-stream
Size: 256 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0007.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wp_norway_network_test.shp
Type: application/octet-stream
Size: 141252 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0008.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: wp_norway_network_test.shx
Type: application/octet-stream
Size: 12932 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20131117/050274d8/attachment-0009.obj>


More information about the Pgrouting-users mailing list