I have a pointfile of some 200 electrical boxes throughout the county. While the electrical boxes are "mapped", they are done so by using township range section data, so there actual location is not known. They are simply at the centroid of a section or subsection. My task is to verify their real world location and move them from the cetroid of the section or subsection to that real location.
I have a 2nd pointfile of electrical boxes that have been GPS located by workers from a utility company. This pointfile contains some 70 features that I know their location is correct. However, only 40 of the points in this file correspond to the 200 in the above file.
Both files contain a unique identifying number for all of the electrical boxes allowing for a 1:1 join of the files to be completed as the GPS points need the attribute data that is present on the county dat. However, since a tabular join like that doesn't actually change any spatial data, it isn't enough to call the job finished. I need to get the attribute data from the 200 to the matching 40, while eliminating those 40 points from the 200. I then need merge the 40 GPS'd points into the county dataset, so all my points are unified in one single file.
I cannot do a spatial join on these two files, because the distances between the GPS verified and the 200 from the county are not uniform due to the TSR mapping of the county data. In other words, joining them based off distance X wouldn't work because the closest points will not necessarily match in real life.
What I really need is to be able to select attributes across two different datasets. I tried merging the two and then running a selection of where UNIQUE_NO = UNIQUE_NO1, but while it was verified it returned no results.
Any idea how to move forward on this? Working in ArcMap 10.2