I have a line that has points evenly spaced on the line. The points are numbered in increasing order along the line. When I use Split Line at Points, my line segments are not ordered with the points. They are appear to be randomly ordered.

Is there someway to fix this? I need to at least have the lines numbered such that they are numbered in order so I can extract data to other programs.

If this isn't possible, is there a way to create an attribute for each line segment that is equal to the average of the points that are connected to each end of the line.

Thanks

Is there someway to fix this? I need to at least have the lines numbered such that they are numbered in order so I can extract data to other programs.

If this isn't possible, is there a way to create an attribute for each line segment that is equal to the average of the points that are connected to each end of the line.

Thanks

For example if it is line called XXY sort it Linename and then your sort.

at the end of cell create ToX and ToY

for the example.

LineName column A

Sort column B

FromX column C

FromY column D

ToX column E

ToY column F

in E2 (ToX first blank cell under the headers)

=if((A2=A3),C3,"")

This will say IF linename for point 1 is the same as point 2 then populate the ToX with the FromX of the 2nd point. If not leave it blank. You can then fill in the rest of the rows by dragging it down. If done correctly you should see blank values for ToX and ToY at all the end points. Fill in appropriately for ToY and drag it in.

Now save it as a .csv. this will write the values into the cells and remove the formulas. Then open it back up in excel and delete all the rows with no values in the ToX and ToY

Bring the spreadsheet into ArcGIS and use the XY to Line tool and it will build your polylines in correct sorted order and you can attribute them as you wish.

This does work. I had to create 65000 some spans between all of our transmission structures in our system in sequential order from Structure 1 to whatever on each different line.