[postgis-users] Cant get the optimal path

Supunmali Ahangama supunmali7 at gmail.com
Sun Oct 11 00:56:33 PDT 2009




Anton Patrushev-2 wrote:
> 
> 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
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

The file
http://www.nabble.com/file/p25841380/roads.zip roads.zip 
-- 
View this message in context: http://www.nabble.com/Cant-get-the-optimal-path-tp25837519p25841380.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list