Polyline Attributes 'from feature' & 'to feature'

Discussion created by gambrels on Dec 14, 2012
Latest reply on Dec 18, 2012 by gambrels

I am trying to do somethnig that I believe is fairly simple but I need a push in the right direction.  We would like to add an attribute to our road centerlines that indicate which road a given segment goes from and to.  Our centerlines are not in a network dataset but are directionally correct, segmented at intersections, and are not multi-part features.  

So for instance, the attributes for the block of Main Street between 1st and 2nd Streets would indicate
FROM: 1st
TO:  2nd
If an intersecting street is a different name on either side (i.e. "N 1st" on one side of Main St and "S 1st" on the other), it doesn't matter which value we use.  This is basically just a reference for staff who will be using a tabular output from the attribute data. 

I'm thinking that perhaps I can do some sort of intersect or spatial join based on the start and end point of a polyline segment, but I have no idea how to do so.  Any suggestions?

We are still using 9.31 and features are in an SDE geodatabase.