Hi Steve, There is no simple approach to this. One of the problems is to sort the streets according to the housenumbers since left and right side of the street may not create the same sort order. Another is fromleft may be bigger than toleft, if the road has been digitized in the reverse direction of the house numbers. What if you have fromleft = 10 and toleft = 19 ? What house numbers does that involve?
One approach is for every streetname to create a list of possible house numbers and then check if you find a number already on the list. In your example you would start marking 20, 22, 24, 26, 28 and 30. On the next segment you will find that 28 and 30 has already been marked. When a streetname is done you clear the list and start with a new streetname. Watch out for very large house numbers (USA habit) as Mapbasic only allow 32000 elements in an array, so you will have to do this in something else than mapbasic. Or store the results in a table, which would be slow. But it requires programming in any case. Kind regards Uffe Kousgaard www.routeware.dk ----- Original Message ----- From: "Morrier, Steve" <[EMAIL PROTECTED]> To: "Lista MapInfo Ingles" <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 9:01 PM 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: 3957
