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.
