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
Results 1 to 2 of 2

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. #1
    Anonymous is offline 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. #2
    Walt Cygan is offline 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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. zipcodes
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 02-16-2005, 08:31 AM
  2. Extract all zipcodes from MapPoint via C#.NET
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 08-09-2004, 09:56 PM
  3. Mapping Zipcodes in Puerto Rico
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 11-19-2003, 10:22 PM
  4. Possible to Locate all Hospitals in 1 mile radius?
    By ChrisC in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-08-2003, 05:09 PM
  5. Showing Zipcodes
    By shaistasohail in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-03-2002, 06:03 PM

Tags for this Thread

Posting Permissions

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


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83