Relationship between source and results tables, Setting up for related table geocoding, Remote table-to-table geocoding – Pitney Bowes MapMarker USA User Manual

Page 192

Writing Geocoding Output to Another Table

192

MapMarker USA 25

Relationship Between Source and Results Tables

The source and results tables must be linked by a common key. In the source table, the values of the
primary key must match the values in the unique key of the results table. We recommend relating
the tables in a one-to-one relationship. Each address record in the source table has a corresponding
record in the related results table connected by the key values.

Where there is more than one record with the same address (a multiple-to-one relationship), these
records may produce georesults that are written to one record. Each time MapMarker geocodes
another address with the same value, it updates the output record in the results table. As long as
each address record with the same key contains the same address, the output is identical. However,
if two source records with the same key contain different address information, MapMarker geocodes
the first record, writes its results, geocodes the second record, and updates the results with different
information based on the different, and possibly incorrect, input address.

If your source table contains multiple unique keys, MapMarker prompts you to choose which keys
are linked to the keys in the results table.

Setting Up for Related Table Geocoding

Prior to geocoding, the database administrator creates a table for geocoding results that is related to
the source table. The table structure includes at least one key that uniquely identifies an address in
the source table. In addition it contains fields for the geocoding results, and longitude and latitude
coordinates. Other optional output fields include firm, street, city, ZIP Code, ZIP + 4, Carrier Route,
Delivery Point, Check Digit, and Census Block ID. See

Specify Output Address Columns

, for

details on column type and width. Consult your database documentation for information on creating
relational tables and primary keys.

The database administrator must also create a data source for the remote source/results tables. The
data source must include information that enables MapMarker to determine which data to access
and how to access it. See

Preparing to Geocode Remote Databases on page 188

for the

instructions for setting up a data source.

Remote Table-to-Table Geocoding

1. Use this procedure to geocode a remote table and write the results to a related table:

2. In MapMarker, select File > Open ODBC Table.

3. In the Select Data Source dialog box, choose either the File Data Source or Machine Data

Source tab. Enter your user name and password if necessary. Click OK.

4. In the Select Database dialog box, navigate to the source table that contains the addresses you

want to geocode. Enter the password if your data source requires it. For example, an MS Access
database selection might appear as:
For example, if you selected Machine Data Source and MS Access Database, you could
navigate to the folder that contained your addresses.