[pgrouting-users] Calculating the shortest way between pairs
carsten.hogertz at gmail.com
Fri Mar 14 07:26:09 PDT 2014
Maybe to clearify.
I've got the following two tables:
Table at_2po_4pgr with the columns:
id integer NOT NULL,
osm_name character varying,
osm_meta character varying,
km double precision,
cost2 double precision,
reverse_cost double precision,
x1 double precision,
y1 double precision,
x2 double precision,
y2 double precision,
and Table routing_pair with the columns:
lat_htl double precision,
lon_htl double precision,
lat_bhf double precision,
lon_bhf double precision,
The routing_pair table hold three important information:
All columns are filled (source + target are calculated from at_2po_4pgr.
The task seems to be quite simple: I want for each row from the
routing_pair the distance between soure + target (and if possible its geom).
Could you please help me how to solve this?
Thank you very very much!
2014-03-13 17:56 GMT+01:00 Carsten Hogertz <carsten.hogertz at gmail.com>:
> Hi everybody,
> I have a table with about lets say 1.000 rows of pairs of
> origin/destination and a routable network table.
> The origin/destination table (my_route) has a
> - pair_id
> - source (calculated nearest node from the network table)
> - target (also calculated from the network table)
> Where do I have to start or what do I have to do to get the shortest path
> between these pairs?
> Could anybody please help me to solve this?
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Pgrouting-users