Identical Overlapping Lines not being deleted after upgrading ArcMap Fabric to Pro Fabric
Accepted Solutions
Hey @RobertChaney
So I did some investigating of the data and here is what I found. It doesn't look like the Distance rounding is the primary culprit. It looks like it's the Direction field.
Let me start with what I think might be path forward for your data then I'll get into the nitty gritty of what is happening behind the scenes.
I would suggest not running the Delete Identical option during the Upgrade. Instead, run it manually after upgrade is complete. The Upgrade ArcMap tool simply runs the GP Delete Identical so running it after will be basically the same except you can control the fields it uses to compare more specifically. If you do not care about the Direction and Distance field values, you can just run the Delete Identical tool and use SHAPE as the field it checks against.
However, if you are concerned about the Distance fields you can run the delete identical against: SHAPE, DISTANCE, ARCLENGTH, and even CREATEDBYRECORD. However you might need to round your distance fields to a lower decimal place, and if you don't want to modify the surveyed data you can create a new field and compute the Distance values over there and round the values in that field. Then use that newly created field in the Delete Identical.
Let me know if that will be a good workflow for you!
Ok... now for some nerdy numbers...
When looking at the Direction field I noticed the decimal values went over 10 places. And during the Upgrade ArcMap tool what happens if you choose to Delete Identical is that I will create two new fields; one that stores the Direction field minus 180 if it's a angle that is greater than 180 and two a distance field that is rounded to 4 decimal places. I then use those two fields, plus the CREATEDBYRECORD, RETIREDBYRECORD and SHAPE field in the parameter for Delete Identical.
With that being said looking at the Direction Field, rounding to 6 decimal places the values still differed between the two lines. Use these lines as an example
You can see on the left the UpgradeDirectionMinus180 fields differ between the two lines. And the Direction values that are stored have huge precision. Seeing this makes me think that these full raw values aren't necessarily important to you so running Delete Identical simply against the shape of the line features might be a viable option for you.
Hopefully all this makes some sense. Let me know if you have any other questions.
As a test, I went ahead and copied the ArcMap Fabric to a fgdb, set the properties of the distance field on the lines to 3 decimal places.
ran the Upgrade ArcMap Parcel Fabric tool and got the same result as before in the Pro Fabric.
It would seem the upgrade tool is not honoring the change to the field properties.
I think I'll just have to use the Delete Identical tool as Jason described, but choose the Shape_Length field.
Robert
That is correct that the GP Script tool doesn't look at map properties for field formatting as the tool can be run without any maps open.
One other thing you can do is modify the script.
Here are the steps:
1. Go to your Pro install location and browse to this fodler: C:\Program Files\ArcGIS\Pro\Resources\ArcToolBox\Scripts
Then find the FabricForArcMapToArcGISPro.py file
2. Copy that file to another location, like your desktop.
3. Right click on the file and Open it with Notepad or any other editor of your choice.
4. Once the file is open scroll all the way to the bottom and you will find a variable called IDENTICAL_ROUND_VALUE. It is currently set to 4. Change the 4 to what ever rounding value you decide
5. Save you changes and close the editor
6. Copy and paste the .py file back to the original directory in step one and overwrite the existing file.
Let me know how this works out for you.
