Re: Help with pgRouting & PostGIS
Hi - I know you posted this months ago, but -
I created my topology using ArcInfo - exported my roads shapefile as a coverage, then typed 'build' + coverage name at the command prompt and you get the to and from nodes - all you need. export as shapefile, export to postgis then rename f_node to source and t_node to target - and off you go.
I was confused to begin with about the nodes - they are abstract in that there is no requirement for a separate nodes table - the source and target fields just show which edges connect to one another.
I had trouble with PostGis topology functions which is why I used ArcInfo.
Cheers
Will