I have a line dataset that was produced from ModelBuilder (not built by me) that involves splitting lines into individual segments using existing Point dataset in between as the split zone. However, the process has a little "flaw" and it created two extra duplicates that retains the incorrect attributes from other Point on the original line.
So what I ended up with is 3 short lines (with identical length but incorrect attributes) on top of each points and only one of them has the correct attributes that I want to keep.
I've attached couple images below for clarity-
Figure 1: 3 Line feature stacked atop a single Point feature.
Figure 2: Table for the 3 selected identical lines
If you look to the far right of the table, the Shape_Length are identical, but the 3rd from the top is the only attribute that is correct based on its location. The other two lines have CROSS_PRCN and LENGTH taken from the purple Point to the right on the same original Line shown in Figure 1 which I want to remove.
Is there any way to remove the other two lines that have the incorrect attributes? There are over 600,000 line segments so I can't remove them manually. I tried using Delete Identical but because of their identical shape length, it doesn't select the ones I want to remove correctly. The single Point has one field (SplitID) that matches the correct Line segment but I'm still quite an amateur at GIS so I don't know if there is a tool that can select matching attributes from two dataset and delete the duplicates.
I have ArcGIS 10.2.2 w/ ArcInfo license installed. Available extensions are - 3D Analyst, ArcScan, Geostatistical Analyst, Network Analyst, Publisher, Schematics, Spatial Analyst, and Tracking Analyst.