Pitney Bowes MapMarker USA - Manual (Page 195)

Chapter 8:
Writing Geocoding Output to Another Table
MapMarker USA 25
195
User Guide
Optimizing MapMarker for Related Table Geocoding
You may be writing the geocoding results to a new output table or may be updating previously
geocoded records in an existing related table. To get the best performance from MapMarker, you
can optimize for one situation over the other. In the Geocode dialog, choose from two settings in the
Related Table tab: Optimize for Insertion or Optimize for Update.
As a general rule, select Optimize for Insertion when the results table is empty or nearly so. Select
Optimize for Update when the results table already contains many records that are likely to be
updated. The default setting is Insertion.
L
This feature does not apply to geocoding to a table in a remote database where the input and
the output results are stored in the same table. In these instances, the Related Table tab is
not visible in the Geocode dialog.
Remote Database Views
MapMarker enables you to geocode views of remote tables if you are writing the geocoding output to
another table. A view is a subset of a table that is typically the result of a select statement. For
example, you may create a view of a nationwide table that includes only records for California. Refer
to your database documentation when creating views.
Once your view is created and you are ready to geocode, follow these steps: This example uses a
machine data source
1. Select File > Open ODBC Table. The Data Source dialog is displayed.
2. From the Machine Data Source tab, choose the data source (such as DBF files or Excel files).
Click OK.
3. From the Select Table dialog, click Filter. Select the Views check box and click OK. The Select
Table dialog is displayed again with a list of views for the data source.
4. Choose the view that shows the input table and click OK.
5. Answer Yes to using a different table for the outputs from geocoding.
6. From the Select Table dialog, choose the view for the output table and click OK.
7. At the Select Input and Output Column dialogs, choose your columns and click OK.
8. Select Table > Geocode and proceed with the normal geocoding process. See Geocoding with
MapMarker in Chapter 3 on page 49 , for complete information on the geocoding process.
Related Table Considerations
MapMarker can write geocoding results to remote related tables using MapMarker ODBC support.
All addresses must be contained in the source table, while all results must be written to a related
results table.