Distance Mismatch Layers and Definition Query Configurations

JasonBessert — Wed, 05 Mar 2025 22:02:44 GMT

We love the distance mismatch quality layers offered by the quality ribbon in pro where lines can be added with pre-written definition queries to expose lines that deviate between COGO and shape length by a distance factor that can be adjusted.

(ABS(ArcLength - Shape_Length) >(0.05 + 0.001*ArcLength) AND RetiredByRecord IS NULL) OR (ABS(Distance - Shape_Length)>(0.5 + 0.001*Distance) AND RetiredByRecord IS NULL)

We are trying to work on language that a definition query can be similarly written, but adjusted to expose lines that deviate from the shape length by a certain percentage, as opposed to an entered footage distance length (0.05 feet in the above query expression). We prefer this means of finding faulty lines, since our accuracy QC generally dictates we should seek out and verify/correct lines that are deviating in measurement apart from their COGO by a percentage, since, the longer the line is in length, the less of a problem that it is a half foot or one foot, or whatever the threshold is set to. If you set a threshold of 2%, you can find problematic lines that have COGO of 500', 750' or 2000' or more if their measurements are off by more than one foot.

Re: Distance Mismatch Layers and Definition Query Configurations

LucasBeauchamp — Mon, 07 Apr 2025 19:48:21 GMT

This would indeed be very useful. This has been something I have had on my list to figure out but have never had the time to research or test. It would be nice if the quality ribbon had this for both fixed distance and by percentage.

topic Re: Distance Mismatch Layers and Definition Query Configurations in ArcGIS Parcel Fabric Questions

Distance Mismatch Layers and Definition Query Configurations

Re: Distance Mismatch Layers and Definition Query Configurations