hello,
another way but it will still take a MB app or wear out the enter key in MBWin select * from streettable order by street name into work walk the work table get the min(fromright,toright) into "address" and "streetname" now do a "find" on that street address if return value <> 1 then insert a "push pin" into cosmetic layer at commandinfox, commandinfoy Trey Pattillo [EMAIL PROTECTED] www.wap3.com -97.665333W 27.799121N ----- Original Message ----- From: "Morrier, Steve" <[EMAIL PROTECTED]> To: "Lista MapInfo Ingles" <[EMAIL PROTECTED]> Sent: 06 November, 2002 14:01 Subject: MI-L Address Range Overlap > 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 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3962
