Hello Mike, Catalist Ltd. (whose data you're probably using) can supply a "Where's the Nearest..." application for MapInfo Pro which will do exactly what you need. For wider deployments, they also have a Intranet application, Catanet, which can perform your proximity analysis functions.
Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: Collard, Mike MB SUKOP-UORM/232 [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 24, 2002 12:10 PM To: '[EMAIL PROTECTED]' Subject: MI-L Query to identify neighbouring locations This is a resend of a message I sent yesterday to [EMAIL PROTECTED] that has not been posted I have a map that plots the locations of petrol filling stations. The table on which it is based includes the brand name e.g. BP, Esso etc. of each location. How can I create a query that will display all Shell sites and any other brand of site that is within x miles of each Shell site? Could this be further refined to display all Shell sites and only say Esso sites, that are within x miles of a Shell site. Thanks Mike Collard Retail Pricing Desk Manager Shell U.K. Oil Products Limited PO Box 403, Staines, TW18 3ZB, United Kingdom Tel: +44 1784 89 7846 Fax: +44 1784 89 7845 Email: [EMAIL PROTECTED] Internet: http://www.shell.com/uk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
