pgRouting

Forum #23 - Topic #77 - Message List

Creating Road Data

Hello. I download the image foss4g. After some work i finally follow all the steps to run the query shortest_path and get my route between 238 and 1455.

When i configure my test enviroment the process of loading data was easy running the victoria.sql file. And [victoria] table only have 3 fields [gid,id,the_geom]

Now how i create my database using my own routing data? How i can load road restrictions (one way, two ways, only left turn)? Which algorithm will take this restrictions to make the route?

Thanks in advice

juan.oropeza
12/11/07 06:56:50
Tree View Flat View (newer first) Flat View (older first)
  • Message #296

    For the FOSS4G tutorial you need to go on with Dijkstra. http://pgrouting.postlbs.org/wiki/Workshop-PrepareDikstra There you run the "create_vertex_id()" function.

    For turn restrictions you need Shooting Star algorithm. But there is no free data available as far as I know, so you can only test it making your own sample data (extending existing one), if you don't have your own one.

    daniel
    12/11/07 09:22:02
    • Message #306

      There is a function call "assign_vertex_id" SELECT assign_vertex_id('victoria', 0.001, 'the_geom', 'gid'); UPDATE victoria SET length = length(the_geom); Where is the help for that function?

      My map info is on Mapinfo TAB. There is an manual to load a TAB file to postgre and use it on the Dijkstra function?

      Using Dijkstra can i put some restriction? one way road, two way road or dead end?

      juan.oropeza
      12/11/07 22:35:57
    • Message #307

      Also there is some documentation so i can extent the data to include turn restriction and use the Dijkstra function?

      juan.oropeza
      12/11/07 23:29:10
      • Message #308

        As you can see on the homepage, if you want to handle turn restrictions, you need to use the shooting star algorithm.

        It is documented on this page : http://pgrouting.postlbs.org/wiki/ShootingStar

        Tristram
        12/11/07 23:48:20
        • Message #310

          Ok. I think i can help you to create a sample for turn restrictions. I will start a new thread with my test on that subject later.

          But lets start from the beginning. I use the victoria.sql to load the Routing data. What are the steps to convert my Mapinfo .tab road map to the sql file or how i create my own routing table?

          juan.oropeza
          12/12/07 04:59:09
Tree View Flat View (newer first) Flat View (older first)