Hi, You do need to use buffers, but in an all-in-one SQL operation using a sub-select clause which builds the buffers and then discards them dynamically:
Select * from fat_food_outlet where obj within any (select buffer(obj,12,1,"mi") from highways) This should also be pretty quick. Check out Buffer and Select in the MapBasic Reference pdf which is (I think) on the MapInfo installation CD. Hope this helps. Best Regards, Martin Higham Avantra Geosystems ph (61 3) 8504 0428 0425-730-428 fx (61 3) 9596 7997 www.avantra.com.au > -----Original Message----- > From: Phillips, Frank [mailto:[EMAIL PROTECTED] > Sent: Thursday, 18 March 2004 04:28 > To: 'MapInfo-L' > Subject: MI-L Proximity Selecting without Using Buffer? > > > In MapInfo, is it possible to do a proximity selection without using > buffering? For example, let's say I have a database of McDonalds > restaurants and a database of interstate highways. If I want to > select all > of the McDonalds that are within 1 mile of the Interstates, do I > HAVE to do > this by buffering, or is there a faster, simpler way to do this selection? > In ArcView this is incredibly quick and easy. > > Frank Phillips > Manager of Marketing GIS > Vulcan Materials Company (NYSE:VMC) > Birmingham, AL, USA > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 10920 > > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.587 / Virus Database: 371 - Release Date: 12-02-2004 > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.587 / Virus Database: 371 - Release Date: 12-02-2004 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10925
