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

Hi! I am looking for a way to find all zip codes ....

This is a discussion on Hi! I am looking for a way to find all zip codes .... within the MapPoint Desktop Discussion forums, part of the Map Forums category; Hi! I am looking for a way to find all zip codes within 10, 50 and 200 miles of a ...

  1. #1
    Anonymous is offline Senior Member Black Belt
    Join Date
    Jul 2002
    Posts
    5,137
    Hi! I am looking for a way to find all zip codes within 10, 50 and 200 miles of a specific zip code. After I know how to do this for one, I would like to do it for all of the zip codes in the US and put them into an Access Database creating seperate tables for 10, 50 and 200 miles within a zip code. For example: The within 10 miles table will contain 2 columns, in one all of the US Zips and in the other Zips within 10 miles of the one in the first column, just like a relational db.

    If you know how to do this please reply. I need this info as soon as possible.

    Thanks,

    Tim

  2. #2
    Walt Cygan is offline Senior Member Green Belt
    Join Date
    Aug 2002
    Posts
    124
    First, I'm not quite sure if Access is up to the task. There are slightly more than 35,000 zip codes that MapPoint knows about. The area of the U.S. is about 3.7 million square miles, a radius of 200 miles contains an area of about 125,000 square miles or a little more than 3% of the U.S. That means for within a 200-mile radius around each zip code, I would guess that you will probably find another 1000 zip codes. That works out to a 35,000,000 row table. Not something that you probably want Access to chew on.


    I think Gilles Kohl has responded to this question on the microsoft.public.mappoint newsgroup, with a fairly complete answer. There is no simple answer. This will take a fair amount of cycles to grind out the final matrix of results.


    - Walt Cygan

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. find area for postal codes
    By Anonymous in forum Wish List
    Replies: 0
    Last Post: 01-16-2004, 06:13 AM
  2. Find and Export of ZIP Codes
    By Anonymous in forum Wish List
    Replies: 1
    Last Post: 01-16-2003, 06:22 PM
  3. Find all zip codes in a drivetime zone
    By SolverDS in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-28-2002, 12:40 PM
  4. Find all zip codes within drivetime zone
    By SolverDS in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-28-2002, 12:39 PM
  5. Given a city find zip codes?
    By amanuel in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 09-21-2002, 12:32 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