[pgrouting-users] Calculating the shortest way between pairs
Carsten Hogertz
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_id bigint,
osm_name character varying,
osm_meta character varying,
osm_source_id bigint,
osm_target_id bigint,
clazz integer,
flags integer,
source integer,
target integer,
km double precision,
kmh integer,
cost2 double precision,
reverse_cost double precision,
x1 double precision,
y1 double precision,
x2 double precision,
y2 double precision,
geom_way geometry(LineString,4326)
and Table routing_pair with the columns:
id integer,
h_key integer,
lat_htl double precision,
lon_htl double precision,
source integer,
geom_htl geometry(Point,4326),
lat_bhf double precision,
lon_bhf double precision,
target integer,
geom_bhf geometry(Point,4326)
The routing_pair table hold three important information:
ID
SOURCE
TARGET
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!
ch
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?
>
> Thanks
> ch
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20140314/805ae155/attachment.html>
More information about the Pgrouting-users
mailing list