developer (#13) - Creating the topology using different tables (#253) - Message List

Creating the topology using different tables

Hi, I'm a begginer to pgRouting. I have some SHP files and I want to put each SHP on a different table and be able to create route using all those tables, but i don't know how to create the topology since the 'assign_vertex_id' function only supports one table, and I want to be able to join those tables and create a route between them.

Thanks in advance,

  • Message #904

    assign_vertex_id creates one table, that's right. And you need to have all your data in the table you want to create the topology on.
    In the end you need unique ID's in your whole network. After you created the topology nothing holds you back to split this table into smaller ones, and join them later again to route between tables. Though I don't understand how this makes sense or has any advantage for you.