[postgis-users] Cant get the optimal path

Anton Patrushev anton at orkney.co.jp
Sat Oct 10 20:03:36 PDT 2009


Hi,

I tried to download your file, but this URL returns 401 error (File
was deleted).

Anton.

On Sun, Oct 11, 2009 at 4:15 AM, Supunmali Ahangama
<supunmali7 at gmail.com> wrote:
>
> Hi,
> http://www.nabble.com/file/p25837519/roads.zip roads.zip
>
> I need to get the optimal path using Dijkstra function in pgrouting.
> Thought I dont get an error, i dont get the results too. Dijkstra function
> runs (without any error), but it don't affect any rows in dijsktra_result.
> That is there is nothing in the created table 'dijsktra_result', it is
> empty.
>
> I created the topology for the road data (attached here) at the start by
>
> SELECT assign_vertex_id('roads', 0.001, 'the_geom', 'gid');
> UPDATE roads SET length = length(the_geom);
>
> in postgresql database.
>
> It didnt give any exception and did work fine when i did run it through
> pgAdmin111. It creates the source and the target columns for each edge/row
> in roads table.
>
> But at the end, it dont give the optimal path (Dijkstra) results, even for
> most simplest paths (connecting 3 nodes), where there are connected paths
> available between origin and destination.
>
> I'm not sure what the problem is. Any help would be appreciated.
>
> I have attached the shapefile too. Is it an issue in road data?
>
>
> Thanks
> --
> View this message in context: http://www.nabble.com/Cant-get-the-optimal-path-tp25837519p25837519.html
> Sent from the PostGIS - User mailing list archive at Nabble.com.
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list