ArcGIS – Create a Line Layer from a Point Layer and CSV Data File

arcgis-9.3geoprocessingpointpolyline-creation

UPDATED DECEMBER 20

I have a Regular point layer and a csv file that has the same ids as the point layer. The csv file is organized as

ID     From    To     Weight
--     ----    --     ------
01     1234    1235   2
02     1234    1236   4
03     1234    1237   1
04     1235    1234   4
05     1236    1235   3

// etc

the point layer is organized in the following way:

MY_ID
-----
1234
1235
1236
1237

the From / To fields correspond to a my_ID in the point layer. I'd like to create a new line layer, such that the From, To, Weight correspond to both the point and csv files

Best Answer

dassouki, can you work with Hawth's Analysis Tools for ArcGIS 9.x?

---EDIT---

with "Add XY to Table (points)" (in "Table tools" from Hawth's bar), create the fields with the coordinates from each point from the point layer.

in excel, for example, open the csv file and add 4 fields: fromX, fromY, toX, toY and copy the coordinates from each point (work with filters, is quite fast) and then save the csv file

in arcmap, use "Add XY line data from table (in "Table tools" from Hawth's bar) in a line layer using the csv file as source and the various connections are created

in the line layer simbology, use "Multiple attributes - Quantity by category", using Weight field

this is the result of my test:

flow test

Related Question