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

Generate a List of Points of Interest

This is a discussion on Generate a List of Points of Interest within the MapForums Plus Downloads forums, part of the MapForums Plus category; Here's a preliminary copy of a tool I'm working on to generate a list of the points of interest around ...

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

    Generate a List of Points of Interest

    Here's a preliminary copy of a tool I'm working on to generate a list of the points of interest around an area.

    Instructions:

    Open MapPoint and go to View | Show or Hide Places to turn on/off the POI's you want.

    Run the macro in the attached spreadsheet by going to Tools | Macros.

    A list will be generated in Excel for all the POI's.

    (Note that it's currently hard coded to do a single lat/lon 40, -90. This can be adjusted in the code.)

    The tool is based roughly on this article --
    Extracting the Mappoint 2002 Points of Interest - MapPoint Articles - MP2K Magazine

    Note that if you want to extract a large area or ALL the POI's in MapPoint, it does make more sense to export to a database than Excel as the article is written. A database can do automatic deduping (set a unique key on a few columns such as name/lat/lon/category) and does not have a row limit.

    Eric
    Attached Files Attached Files
    Last edited by Eric Frost; 09-21-2009 at 01:38 PM.
    ~ Order MapPoint MapPoint 2013 Here and Get Free Access to the MapForums Downloads ~
    ~~
    ~ Upgrade to Get Access to the MapForums Downloads ~

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

    Revised 9/21

    Fixed a couple minor things, new file attached above.

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

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can I add custom points of interest to mappoint
    By jshroff in forum MapPoint Desktop Discussion
    Replies: 4
    Last Post: 09-24-2009, 08:03 AM
  2. Points of interest
    By zanifu in forum Development
    Replies: 3
    Last Post: 01-31-2009, 07:42 AM
  3. Neet Points of Interest database
    By dylanthered in forum MapPoint Desktop Discussion
    Replies: 5
    Last Post: 09-15-2005, 02:11 PM
  4. Editing points of interest balloons
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 05-13-2003, 03:08 PM
  5. Add Points of interest
    By Anonymous in forum MapPoint Desktop Discussion
    Replies: 0
    Last Post: 04-23-2003, 01:03 AM

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 84 85 86 87 88 89 90 91 92