spacer1
spacer2 1_1 1_2
2_1
 Subscribe
 The MP2K Update!
 
 
 
 Magazine
Front Cover
What's New
Articles
News
Sample Data
Gallery
Advertise
About
 Features
MapPoint 2013
Press Releases
MapPoint Forums
Companies
Link to MP2Kmag
Wish List
MapPoint Trial
Authors
 Earlier Content
Past News Items
Past What's New Announcements
 Sponsors
 Order

MapPoint 2013

Programming MapPoint in .NET

MapPoint Book

  Spatial Community
SVG Tutorials
MapPoint

Map Visitors

  ARTICLES  


Improving On The MapPoint Geocoding Algorithm - Pt. II

Rainer Barthels database and executable for advanced geocoding in MapPoint

The previous article discussed the limitations of MapPoint's built-in geocoding and presented a strategy using FindAddressResults to work around these limitations. Now we take a look at the executable and database you can use for your own geocoding.

First, download the database and examine the structure.

Geocoding Database Structure

This is a sample database, the database actually used by the executable need not have these names, but this is the essence of what the program works with. The first several fields are used as input, and the last several fields are output by the program. The database is in Access 2000 format.

Now, download the program (help file included) and place them in the same folder as the database.

When you first start the program it will prompt you for the location of the database and table as well the columns for input and output.

You will also need to specify the version of MapPoint that you will use for geocoding. This version must be installed on your computer. Note that the sample addresses in the customer.mdb database are all in Germany. If you only have the North American version of MapPoint you may want to stop at this point, go back to the database and type in several sample North American addresses before proceeding.

The program then goes into an interactive mode where you can see and edit records as well as see the output from the geocoding. Click the pushpin in the corner to load MapPoint and perform the geocoding.

That's it! This program is unsupported and for demonstration purposes only, your mileage may vary. However, feel free to leave feedback and any comments or questions in the forum below.

  - Eric Frost

Discuss this story in the forum.

Author: Rainer Barthels
Email: rbarthels(AT)gmx.de
Rainer Barthels is working for 10 years in the field of optimization of vehicles (VRP=vehicle routing problem). He studied phyiscs at the university of Stuttgart and is now senior project manager at Kempten/Germany but heavily involved in programming (Delphi, C++).



Google
 
MP2Kmag Internet


 Recent Discussion
 Resources
Browse GIS books and periodicals
Find a MapPoint Partner or Consultant
Real Estate Columbia, MO
Excellent Great Loop Travel Guide


Want Your Site To Appear Here?

   © 1999-2012 MP2K. Questions and comments to: website@mp2kmag.com
  Microsoft and MapPoint 2002/2004/2006/2009/2010/2011/2013 are either trademarks or registered trademarks of Microsoft.