Welcome to MapForums!

Register, sign in, or use Facebook Connect above to join in and participate in the forum.

When you are signed in, this message, the ads in this row, and the red-underlined link ads all go away.

 Subscribe to receive our newsletter. Subscribe Unsubscribe

## I have a dataset of 390 hospitals with zipcodes, d....

This is a discussion on I have a dataset of 390 hospitals with zipcodes, d.... within the MapPoint Desktop Discussion forums, part of the Map Forums category; I have a dataset of 390 hospitals with zipcodes, divided into high and low volume categories. I would like to ...

1. Senior Member Black Belt
Join Date
Jul 2002
Posts
5,137
I have a dataset of 390 hospitals with zipcodes, divided into high and low volume categories. I would like to be able to calculate the average distance from any given low-volume hospital to the closer high-volume hospital. I tried to look at Gilles Kohl message cited in the answer to another question here with a similar problem, but was not able to find it in the newgroup. Thanks!

2. Senior Member Green Belt
Join Date
Aug 2002
Posts
124
This is a fairly brute force problem. First I assume you have MapPoint
datasets with this data, right? Also, what distance do you want, crow flight
or driving? Basically you would have to do code with an outer loop to access
each low-volume hospital, and inner loop to process each high-volume
hospital. Then calculate the distance you want between each outer-inner loop
pair. Either use the Distance method to get the crow flight distance, or
create a route with each set of inner-outer loop points as waypoints to get
the driving distance. Save the results to a database. Then you can run a
query to find the minimum distance for each low-volume hospital. Not too
hard, but a fair number of steps involved.

- Walt Cygan

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•