Hi All. I'm looking for gaps in address ranges between two connected line segments. what I''m looking to accomplish is something along the lines of what the geometry on geometry check could ALMOST do, if it allowed me to do any calculations to the attributes I'm comparing
for example: I have two line segments that touch. each line segment has two long integer fields 'first right house' and 'last right house' that store the numeric part of the first and last addresses for that segment.
the check I want to create would be something like: for any touching lines, is the last house in segment 1 < (first house in segment 2 - 2). This would tell me if theres a gap in the address numbers of more than 2 digits.
the geometry on geometry check allows me to compare attributes for touching lines, but not compare one attribute against another attribute value - 2.
I don't see this in the Data Reviewer for addresses batch checks available under the Local Government material.
Anyone have any ideas of a check I could use to accomplish this?