demo (#22) - tutorial foss4g_w12 - help me (#60) - Message List

tutorial foss4g_w12 - help me

Hello. I did not experience. I am writing thesis and find pgrouting very interesting. My goal is to get to calculate the minimum turns with the restrictions on openlayers but I have many problems. This of course depends on the fact that I have little knowledge.

For the moment I have 2 problems 1) To learn I am following the tutorial foss4g_w12_manual.pdf and I stopped to page 3. I do not know exactly how to perform the function Run Shortest Path Dijkstra query; If pgadmin3 (sql query) launch

SELECT * FROM shortest_path ( '

Gid as SELECT id,

Source
integer,
Target
integer,
Length
double precision as cost Victoria FROM ', 25793, 128002, false, false);

I have an error; ERROR: Start vertex was not found.

What's wrong?

2) I can not understand, even seeing the templates, how to 'link' openlayers to pgrouting

Thank you very much

  • Message #220

    Hi,

    Can you make sure, that the vertex exists?

    SELECT * FROM victoria WHERE gid=25793;
    

    I recommend you using the online version of the tutorial and not the PDF. I probably updated the dataset once. The functions are the same, but the IDs have been generated new.

    You can try it with 238, 1455 as start and end vertex. That should work.