Finding the Nearest Point
Jonathan Page
National Grid References.
I need to find the distance from the postcode to the nearest point and
return a value, i'd also like to have a value for the 3rd nearest
point.
I'll probably need to do some analysis then some tinkering in Excel?
just wondered if anyone could point me in the right direction?
Cheers
Greg
HTH
Greg.
Peter Horsbøll Møller
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en
Martin Spiers
" This program calculates the distance from all the objects in one table to all the objects in a second table or itself. It then returns the closest or farthest distance(s)."
In your case, you'll want to find the 3 nearest points in your point table for each postcode centroid. It's probably easiest to use a pivot table in Excel to extract the smallest and largest distance for each point from the results.
Cheers
--
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.To post a message to this group, send email to mapi...@googlegroups.com To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching archives, feature requests, to visit our Wiki, visit the Welcome page at http://groups.google.com/group/mapinfo-l?hl=en
Disclaimer: This electronic communication and its attachments may contain confidential, proprietary and/or legally privileged information which are for the sole use of the intended recipient. If you are not the intended recipient, any use, distribution, or reproduction of this communication is strictly prohibited and may be unlawful; please contact the sender and delete this communication. MWH does not warrant or make any representation regarding this transmission whatsoever nor does it warrant that it is free from viruses or defects, correct or reliable. MWH is not liable for any loss or damage that occurs as a result of this communication entering your computer network.
The views expressed in this message are not necessarily those of MWH. This communication cannot form a binding agreement unless that is the express intent of the parties and they are authorized to make such an agreement. MWH reserves all intellectual property rights contained in this transmission. MWH reserves the right to monitor any electronic communication sent or received by its employees.This communication may come from a variety of legal entities within or associated with the MWH group.
For a full list of details for these entities please see our website at www.mwhglobal.com. Where business communications relate to the MWH UK Limited entity, the registered office is Terriers House, 201 Amersham Rd, High Wycombe, HP13 5AJ Tel: 01494 526240 and the company is registered in England as registration number 01188070. Where business communications relate to the MWH Constructors Limited entity, the registered office is as above and the company is registered in England as registration number 04635724
Jonathan Page
using v7.5..