[pgrouting-users] pgrouting with TeleAtlas Multinet

pgRouting pgrouting-users
1

Hi, I’m a new user of PostGis and PGRouting.

I’m using a Geoserver + OpenLayers solution with own TeleAtlas shape-files.

I have license for using the NW layer in routing mode, and I’m trying to find tutorial to know how to build a network in PGRouting.

Can someone help-me finding information on that.

I’m now using RWNet and I have all the “recipe” to create the network information based on a Multinet shapefile, but I want to try the PGRouting.

Thank you in advance

Ricardo Pedro

2

Hi, I’m a new user of PostGis and PGRouting.

I’m using a Geoserver + OpenLayers solution with own TeleAtlas shape-files.

I have license for using the NW layer in routing mode, and I’m trying to find tutorial to know how to build a network in PGRouting.

Can someone help-me finding information on that.

I’m now using RWNet and I have all the “recipe” to create the network information based on a Multinet shapefile, but I want to try the PGRouting.

Thank you in advance

Ricardo Pedro

3

Hi Ricardo,

If you have data as SHP files you can import the data with shp2psql or so.
I’m not sure if your TeleAtlas data already contains “source” and “target” attribute. If not, then take a look at the workshop how to create a routing topology: http://workshop.pgrouting.org/chapters/topology.html

In the end you should at least have the following attributes

  • gid
  • source
  • target
  • cost
  • the_geom
    Depending on the shortest path algorithm you need more or less attributes. But this is also explained in the workshop.
    You can rename columns if they have another name, or you can create a “VIEW” or use “ALIAS” to get the column names right.

Hope that helps,
Daniel

On Tue, Sep 20, 2011 at 5:08 AM, Ricardo Silva Pedro <Ricardo.SilvaPedro@tecmic.pt> wrote:

Hi, I’m a new user of PostGis and PGRouting.

I’m using a Geoserver + OpenLayers solution with own TeleAtlas shape-files.

I have license for using the NW layer in routing mode, and I’m trying to find tutorial to know how to build a network in PGRouting.

Can someone help-me finding information on that.

I’m now using RWNet and I have all the “recipe” to create the network information based on a Multinet shapefile, but I want to try the PGRouting.

Thank you in advance

Ricardo Pedro

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/pgrouting-users

–
Georepublic UG & Georepublic Japan
eMail: daniel.kastl@georepublic.de
Web: http://georepublic.de

4

On 9/19/2011 4:04 PM, Ricardo Silva Pedro wrote:

Hi, I'm a new user of PostGis and PGRouting.

I'm using a Geoserver + OpenLayers solution with own TeleAtlas shape-files.

I have license for using the NW layer in routing mode, and I'm trying to
find tutorial to know how to build a network in PGRouting.

Can someone help-me finding information on that.

I'm now using RWNet and I have all the "recipe" to create the network
information based on a Multinet shapefile, but I want to try the PGRouting.

The recipe for any data set is roughly the same as the tutorial[1][2]:

1. load you road network into postGIS as a table
2. create a network topology using assign_vertex_id() or if you have zlevels then you might need to find a copy or modify assign_vertex_id() to handle zlevels.
3. update your cost and reverse cost columns based on one-way streets
4. you should be good to go to test the basic system
5. if you want to use turn restrictions read the docs and ask on the list. This is a lot harder at the moment to use.

-Steve

[1] http://workshop.pgrouting.org/
[2] https://github.com/pgRouting/workshop