IN MI Pro ver 8 there is a nifty tool in the tools menu called 'Distance
Calculator'.
If you are on an earlier version you can do it with the Distance function in
SQL select but it is a bit cumbersome...you need a common ID in both tables
for joining, then can put the following in your SQL selct columns up top:
Select table1.id, table2.id,
Distance(table1.Lon, table1.Lat,
Table2.Lon, table2.Lat, "mi") "Distance"
(You can also use centroid X and X instead of Lon/Lat fields)
Will Mitchell
Mitchell Geographics, Inc.
496 Congress St.
Portland, ME 04101
P 207.879.7769
F 207.221.5861 (new)
www.mitchellgeo.com
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Tracey
Sent: Wednesday, February 01, 2006 4:07 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] calculating distances
Hi all,
I have 2 tables, one of them has one point on it (table 1), and the other
has approximately 500 points (table 2). I was wondering if there was an easy
way of calculating the distance of all the points in table 2 to the one
point in table 1, and then automatically adding an extra field in table 2
with that value.
Any help would be greatly appreciated.
Regards,
Andrew Tracey
Information Support Officer
Corporate Information
Corporate Development
South Tyneside Council
Westoe Road
South Shields
NE33 2RL
Tel: 0191 4247561
E-Mail : [EMAIL PROTECTED]
****************************************************************************
********************
****************************************************************************
********************
Please do not print this e-mail if you can help it - and help protect the
environment.
****************************************************************************
********************
This Message may contain confidential information and is protected by
copyright.
If you receive it in error please notify us and delete it without making use
of or copying it.
The addressee and other employees within the Council may read and copy any
e-mail
reply to this message and other e-mails you send to us.
Whilst we use virus checking procedures we accept no liability for viruses
and recipients
must rely on their own virus checking procedures.
****************************************************************************
********************
The Council's web site address is www.southtyneside.info
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
