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
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Import Multiple Radii Points and export all zip codes in each radius

This is a discussion on Import Multiple Radii Points and export all zip codes in each radius within the Wish List forums, part of the MapPoint Desktop Discussion category; I need to be able to plot multiple radius from an adress or lat/long then export all the zip codes ...

  1. #1
    roxannebmiller is offline Roxmille White Belt
    Join Date
    May 2011
    Posts
    5

    Import Multiple Radii Points and export all zip codes in each radius

    I need to be able to plot multiple radius from an adress or lat/long then export all the zip codes in each radius.

  2. #2
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Re: Import Multiple Radii Points and export all zip codes in each radius

    How many are there? Would your project be good candidate for automation or are there few enough it would be feasible to do manually? It's just a few steps to do each one.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  3. #3
    roxannebmiller is offline Roxmille White Belt
    Join Date
    May 2011
    Posts
    5

    Re: Import Multiple Radii Points and export all zip codes in each radius

    Multiple points 1500 plus....

    Each point - can the zip be pulled back serperately even if the radius overlap?

  4. #4
    roxannebmiller is offline Roxmille White Belt
    Join Date
    May 2011
    Posts
    5

    Re: Import Multiple Radii Points and export all zip codes in each radius

    What are the steps if we are looking at one at a time?

  5. #5
    PROFIT100 Consulting is offline Member Green Belt
    Join Date
    Sep 2009
    Location
    Darmstadt, Germany
    Posts
    94

    Re: Import Multiple Radii Points and export all zip codes in each radius

    MapPoint® - IC-GeoAnalysis™ Suite
    The program "IC-DistanceAnalysis (Professional)" will fit your task.

    It´s part of the
    IC-GeoAnalysis™ Suite
    (When you become a BETA-Tester, you will get a full license and we will show you how it works.)

    IC
    -GeoAnalysis™ Suite:

    The ultimative collection of programs, addIns and macros designed for working with MapPoint,
    115 pages of - documentation - with hundreds of tutorials and screenshots.

    There is a 30 day free trial available for - download (40MB) - .
    We are looking for BETA-Tester , BETA-Tester will get a 50% discount and many benefits.

    With kind regards
    Manfred


    PROFIT1oo™ Consulting - Microsoft® MapPoint ISV (Independent Software Vendor)
    Seitersweg 55, D-64287 Darmstadt, Germany, Tel.: +49 (6151) 9815-56 , GM: Jürgen Käsemann, Manfred Sündorf,
    Email: info@profit100.eu - Internet: http://www.mappoint2010.info

  6. #6
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Re: Import Multiple Radii Points and export all zip codes in each radius

    Quote Originally Posted by roxannebmiller View Post
    Multiple points 1500 plus....
    Yes, it's probably worthwhile to automate Do you want the output all in a single table or how should it be formatted?

    Quote Originally Posted by roxannebmiller View Post
    Each point - can the zip be pulled back serperately even if the radius overlap?
    Not sure what you mean, do you want each zip code to be associated with no more than one of your points? This would be do-able and could be done by looking at either the straight-line distance or the driving distance between your point and the center of each zip code.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  7. #7
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Re: Import Multiple Radii Points and export all zip codes in each radius

    Quote Originally Posted by roxannebmiller View Post
    What are the steps if we are looking at one at a time?
    The trick is to first map any demographic variable by zip code, then you could draw your radius and then right-click on the edge and select "Export to Excel". What you would end up with is 1500 separate worksheets however, it's probably best to explore a custom macro that will generate the results you need in an easier-to-use format.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  8. #8
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Zip Code List Database

    Depending on your budget and need for accuracy, I'd also mention you can buy updated zip code databases with lat/lon's for fairly cheap that might be more up-to-date than MapPoint and use this as your source for the zip data.

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

  9. #9
    nolster is offline Junior Member White Belt
    Join Date
    Aug 2012
    Posts
    4

    Re: Zip Code List Database

    Interested if the requested project was ever done. We have several thousand points of presence, for each we have drive time calculations. We would like to be able to determine the population coverage we have. Currently utilizing Map Point 2013, with 2007 census data. Looking for a rough overall number that can be recalculated as we add (or subtract) locations in the future. Close counts, as this is a government related project.

  10. #10
    Eric Frost's Avatar
    Eric Frost is offline Administrator Black Belt
    Join Date
    Jul 1992
    Posts
    5,090
    Blog Entries
    4

    Re: Zip Code List Database

    This project was not done, but I've lately been working with Census 2010 demographic data and have done similar projects, so it's certainly doable if you are interested!

    Eric
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Need advice: creating multiple radii and exporting zips within each
    By jls in forum MapPoint Desktop Discussion
    Replies: 2
    Last Post: 01-13-2010, 10:15 PM
  2. need macro to export points inside multiple radi on map to excel
    By RandyG in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 07-08-2009, 08:30 PM
  3. Exporting data from multiple radii
    By dfairbanks in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 10-28-2008, 02:57 AM
  4. Exporting Multiple Radii
    By tjgray06 in forum MapPoint Desktop Discussion
    Replies: 3
    Last Post: 10-19-2007, 01:58 PM
  5. Is this possible? Identifying points within radius of terr.
    By Kogenta in forum MapPoint Desktop Discussion
    Replies: 1
    Last Post: 01-17-2006, 12:56 PM

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