RE: Help with pgRouting & PostGIS

Hey Green,

I have fiddled with this some time ago... (and I also was left scratching my head for a while :] )

Here’s what I’ve concocted:

Using OpenJump:

There a tool called ‘Planar Graph’ under tools->analysis

(uncheck create faces)

You’re give two layers à one with all the nodes (and their IDs) and the other with the edges.

The latter gives you the start and end nodes for each segment…

Since pgrouting works by setting turning costs for each node… You just have to add another field to this layer and set each node’s turning cost… ;-)

(you could, of course, transfer the attributes from the original layer (such as labels, names, etc…) to this layer…)

From this point on it’s a matter of deciding what you want to do under a programmatical point of view…

So you see you don’t have to go nuts with all that unfinished topology support… ;-)

HTH,

Pedro Doria Meunier

Hi,

I have been using PostGIS for a while and it works great for my requirement. I have roads & streets as shapefile and now, I wanted to a find the shortest route between locations.

I found pgRouting during the search process. There they talk about topology. They have suggested to use 3 tools for creating data for pgRouting and I don't have access to 2 of them. The one that is familiar to me is PostGIS. I intalled the topology functions and I am struck without any direction. Now what ?

I request any one of you help me and I would greatly appreciate.

I have shapefiles of roads and how do I create data for pgRouting ?

Thanks
Green