I have a road network and I used pgr_createTopology
and pgr_nodeNetwork
to convert it for use in pgRouting library. However the results are fragmented and there is no continuous path. Furthermore I have to give source and target values instead of ID in the below query. here 747
and 311
are source and target values from table rather than IDs.
pgr_dijkstra('
SELECT id, source::int, target::int, length::double precision AS cost FROM guru_noded',
747, 311, false, false);
I am new to this.