MapPoint Forums

MapForums

Community of VE/MapPoint Users and Developers




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 2006/2009 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 ...


Go Back   MapPoint Forums > Map Forums > MapPoint 2006/2009 Discussion

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

Register Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Notices

Notice: Now taking orders for MapPoint 2009!


Click here to register

Reply

 

LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-25-2002
Senior Member
Black Belt
  
Join Date: Jul 2002
Posts: 5,138
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #2 (permalink)  
Old 01-25-2002
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

« Hi, I need help getting MapPoint.Application to.... | I have a list of 200 newspaper customers that is i.... »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 
Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
find area for postal codes Anonymous Wish List 0 01-16-2004 06:13 AM
Find and Export of ZIP Codes Anonymous Wish List 1 01-16-2003 06:22 PM
Find all zip codes in a drivetime zone SolverDS MapPoint 2006/2009 Discussion 0 09-28-2002 12:40 PM
Find all zip codes within drivetime zone SolverDS MapPoint 2006/2009 Discussion 0 09-28-2002 12:39 PM
Given a city find zip codes? amanuel MapPoint 2006/2009 Discussion 0 09-21-2002 12:32 PM


All times are GMT -5. The time now is 12:54 AM.

Marketing Strategy - VSAT - Used Cars - Book a Hotel - Moving Services - Archive - Top

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
MP2K Magazine
Visitor Map

Ski Travel
Holiday Hypermarket wants to make ski travel easy for you. Find out key information about destinations in our travel guides. We search leading tour operators for great value ski travel.

City Breaks
Book a city break with Travel Counsellors. A personal travel advisor will help you make the most of your city break.

Canada Flights
Canada flights are great value flights when you visit dealchecker.co.uk first. Full of surprises, Canada is simply the most astonishingly beautiful country in the world.

Dominican Republic Holidays
Dominican Republic holidays have something to offer for everyone. From water sports, to sun bathing and more, enjoy a holiday there!

Egypt
In Egypt you find an ancient city buzzing with life. There is an abundance of historical sites to see, not just the pyramids. The Opera House is certainly worth a visit and you can enjoy some open-air theatre too.

Package Holidays
With the help of Travel.co.uk you can find the package holidays of your dreams.

Cheap Florida Holidays
You thought American holidays were expensive? No ways! Affordable holidays to Florida, only at On The Beach.


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