Hello Steven, We have a "Where's the Nearest...?" (WTN) application (for Pro v4.5+) which can do this. It is a commercial product rather than freeware, but it is a feature rich tool. It's been specific to the UK for the past couple of years but I am just about to complete the generic conversion so that it will work anywhere and with any coordinate system. In the following description, "origin" refers to a table that you would search "from" (i.e. your stores) and "destination" refers to locations to find (i.e. your customers). Features include:
- Interactive Single WTN's by placename, zip/postcode lookup (from your data) or map click. - Display up to 15 user chosen fields, plus distances. - Button to change map to origin or any destination point. - Find up to 100 destination locations - UK Edition has built-in full postcode look-ups to 100m accuracy (QAS data) - Batch mode WTN's between any source and destination table. - Easy to use Wizard to collect settings from user. - Option to specify "where" clause for origin and destination tables. - Maximum search distance (miles or kms) - Direct or routed distance (routing in UK edition only at this time) - Choice to ignore zero-distance match (which may be origin=destination). - Match up to 32,000 destination locations per origin. - Choose any/all fields from origin or destination to pass through to output table. - Choose distance (miles/kms), rank or normalised Inverse Distance Weighting (IDW) factor to pass through to output table. - Output to text file or MapInfo table. With latter, option to draw "satellite links" from origin to destinations - useful for visual linking. The application work only with point data a the moment but there are plans to support poly-/lines and regions in the future. The product will be available in February. Price: TBA. If you have any question, please do not hesitate to contact me. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Steven J. Murphy Sent: Tuesday, January 29, 2002 2:07 PM To: MapInfo List Subject: MI-L finding set of closest objects Hello List- I have 2 geocoded tables. One representing store locations and another = representing prospective customers. Now my questions: 1) If I select 1 store location, is there a query statement that will = select the closest 250 prospective customers? 2) Expanding on the above idea, is there a current program that will do = this automatically? I have 600 store locations and 160,000 prospective = customers. I do not want to do each store individually. Prospective = customers can be assigned to more than 1 store. thanks, Steven _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
