PDA

View Full Version : Generate a List of Points of Interest



Eric Frost
09-17-2009, 09:35 AM
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 (http://www.mp2kmag.com/a53--poi.points.interest.mappoint.html)

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

Eric Frost
09-21-2009, 01:39 PM
Fixed a couple minor things, new file attached above.

Eric