connection-lines between two points

Hi there,

I'm using the educational version of ESRI ArcView 9.1, but I think, the
problem can be solved with any other GIS.

I've got two datasets, which should be combined to a road-network.

Dataset 1:
columns: code of motorway junction; coordinates of motorway junction
example: RBVM; 23.431, 4.312

Dataset 2:
columns: code of motorway junction; directly connected junctions
example: RBVM; RNBK; RJGB

It's possible to join the two datasets using the "code", but how do I
draw the roads (the connections) between to points?

Best regards,
Tobias

ps: Follow-Up to comp.infosystems.gis

Tobias,

you should have a look at Hawth Tools
http://www.spatialecology.com/htools/addxylinedata.php

Indeed, I believe you would have to do 3 joins and maybe to work a bit
on your table 2 so every record contains only two junctions ID.

table 1: Junction ID - Coordinates
table 2: junction ID - connected Junction ID

then you take table 2 and join the junctionID and the connected Junction
ID to table 1. You will end up with a table like:
table2.jID table2.connectedJID table1.JID table1.coordinate
table1.connectedJID table1.connectedJ_Coordinates

Hope it helps!
Jean

Hi Jean,

thanks for help.

Am 06.11.2007 22:59, Jean H schrieb:

Unbelievable ... a $$$$ application doesn't include this basic features?

Best regards,
Tobias

Have you tried Network Analyst extension.

AGP

Am 07.11.2007 07:13, AGP schrieb:

I think, it's not available to students :-(

In my eyes, automatic connections between two points is a basic
function, which shouldn't need an add-on.

Anyway, I'll try Jean's solution. XTools should also have a function
like this. I installed the trial some days ago and I'm surprised.

Best regards,
Tobias