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
