I got road file with From Node ID and To Node ID in separate fields. I also got another file (point shape file) with Node_ID and Relative Elevation field. I want to add two fields in my road shape file that represents FromNode Elevation (F_ELEV) and ToNode Elevation (T_ELEV) based on the point shape file's relative road elevation field. I tried join first with From Node to Node_ID and saved this file and then performed the same with To Node to Node_ID. The problem with this is it does not take into account coincident nodes with varying relative elevation to model bridge and overpass/underpass. Any suggestions how to handle this problem?
Thanks for your response. Yes, unfortunately, these Node Ids are same for overpass/bridge. They do have different relative elevation but it is very hard to change thousands of relative elevations manually.