Peter, How about it indeed...
This worked like a charm and I am currently pouring a nice pint of beer into my PC to transmit with this email! Thank you. David -----Original Message----- From: Peter Horsbøll Møller [mailto:[EMAIL PROTECTED] Sent: 11 May 2004 17:38 To: Eagle, David A; [EMAIL PROTECTED] Subject: RE: MI-L Proximity How about this one: Make a copy of your ROAD table, name it eg. ROADBUFFER Open the copy Open the MapBasic window and enter the following followed by hitting the ENTER-button Update ROADBUFFER Set OBJ = Buffer(OBJ, 12, 1, "km") Now you have created a 1 km buffer on all roads. Now using SQL Select: Columns: ROADBUFFER.ID, SITES.ID From tables: ROADBUFFER and SITES Where: ROADBUFFER.OBJ Contains SITES.OBJ Order By: ROADBUFFER.ID, SITES.ID HTH, Peter Horsbøll Møller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk -----Original Message----- From: Eagle, David A [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 6:23 PM To: '[EMAIL PROTECTED]' Subject: MI-L Proximity Listers, I am working on a couple of approaches to this problem but I'd like to see if anyone out there has a solution to this. I have two tables Roads.Tab and Sites.Tab. Each link of the road has an ID and each site has an ID. I would like to output a file that tells me for each link which sites are within 1km. It would read something like: Link Site 1 23 1 47 1 100 2 1 2 4 3 560 4 57 4 48 4 900 I think I have to query each link, one at a time, i.e. create a buffer, find out what's inside, write the info out, dump the buffer, move to the next link. However, I really need a quick solution! Can anyone make a contribution? Can I write a fancy query for this or do I need to write some code? Thanks. Dave This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11697 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11698 This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11717