I am currently doing an analysis in Arc Map 10 using python, as I am not familiar with this tool, hence I come here to ask your help.
I actually have two shape layers, one is a point layer and the other one is a line layer. The point layer have attributes for point's unique ID, as well as X and Y coordinates (expressed as coord_X, coord_Y). The line layer include line's ID, and its has coordinates for starting point and ending point. Here they are expressed as FromID_X, FromID_Y, ToID_X, ToID_Y. There are also two empty column in line layer's attribute table as FromID and ToID for points.
The all coordinates in both point and line layer are all really know by field calculation, but the FromID and ToID of starting point and ending point in line layer is empty. I want to feature out the ID of point from point layer and fill them in the table of line layer, i.e. FromID and ToID.
I have an idea to compare the coordinates of FromID_X (line's layer) with Coord_X(point's layer), if they are the same, output the Point's ID to line layer as FromID and repeat this for ToID.
But now, I am not familiar with python in ArcMap 10, I am wondering if you can tell how some idea or grammar which I can look into so I could use python in ArcMap to do this work? Or you know some tools for such kind of work?
Many thanks for your help!