Hi All, I am not sure if this one can be done or not but I am hoping some Street File guru can help me.
Is there a way to find all street segments that have an overlap in their address ranges? For example one block/segment of Main St. may have a FromLeft =20 and ToLeft = 30, I want to check to make sure the next segment in line doesn't have something like FromLeft = 28 and ToLeft = 38. The simple part of the query would be select object where FromLeft < ToLeft of previous segment. My problem is telling the query to look at segments based on line direction and name so that only consecutive streets are compared. TIA Steve
