Hi Johnathan!
I have an answer to your query.
First, make a copy of your table of points. It will become your circle
table. Open it.
In the MapBasic Window:
Set Distance Units "mi"
Update <circle_table> set obj = CreateCircle(CentroidX(obj),
CentroidY(obj), 100)
Save the circle table.
In the SQL Query window:
Select Columns: <point>.ID, <circle>.ID, Distance
(centroidX(<point>.obj), CentroidY(<point>.obj), CentroidX(<circle>.obj),
CentroidY(<circle>.obj), "mi") "distance"
from Tables: <point>, <circle> 'order is important
where Condition : <point>.obj within <circle>.obj
into Table named : Results
I think there will be no problem with that. I hope my explanation are cleat
enough.
Have a nice week-end!
-----Message d'origine-----
De: Jonathan Stokes [mailto:[EMAIL PROTECTED]]
Date: 23 juillet, 1999 09:01
À: 'mapinfo mailing list'
Objet: MI Distance Tables
Hello list
does anyine know of a method/utility whereby i can do the following.
i have a coverage of 2800 points and i need to have for each record in
the file the distances to every other point in the coverage within 100
miles. obviously there will be multiple records in the ouput file
i.e record1 record2 20
record1 record3 35
etc etc
anyone got any bright ideas ???
cheers
jonathan
>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
