Pitney Bowes MapMarker USA - Manual (Page 156)

Geocoding Remote Tables
MapMarker USA 25
156
User Guide
For MapMarker input purposes, PO BOX 123 is the Address1 input field and 1 MAIN STREET is the
Address2 input field.
When you geocode the table, a two-line dual address is matched to the address in the Address1
field if both addresses produce a close match.
One-Line Dual Addresses
A one-line dual address might appear like this:
1 MAIN STREET PO BOX 123
In CASS mode, for one-line dual addresses, MapMarker chooses a single close match based on the
following priority, if both addresses produce a close match:
• P.O. Box
• Street
• Rural Route
• General Delivery
When you geocode a table in CASS™ mode, the address that is not used for the single close match
is output to the Address2 field for both types of dual addresses.
In non-CASS geocoding, the street address is always preferred if both addresses produce close
matches.
Geocoding Remote Tables
MapMarker supports ODBC tables in Microsoft Access, Oracle, and SQL Server formats. See your
MapMarker release notes for version-specific support information.
If you are geocoding your ODBC table, you or your database administrator must first add the fields
for GeoResult, Latitude, and Longitude. A georesult column is highly recommended and coordinate
columns are recommended. If you plan for MapMarker to write additional address information to
your table, prepare columns for them as well.
To access your remote database:
1. Choose File > Open ODBC Table to display the Select Data Source dialog. (If you set File >
Open Startup Options for ODBC Tables from the System Preferences dialog, the Select Data
Source dialog appears automatically when you start MapMarker.
2. From the Select Data Source dialog, click the Machine Data Source tab.
3. Choose your data source. Your data source is the location of the specified database. For
example, CUSTOMER could be the name of the data source that provides access to one or
more Oracle tables located in a specified directory. Once connected to the CUSTOMER data
source, you could access information from any Oracle table associated with that data source.
4. Sign on to your data source in the usual way. This procedure differs depending on what type of
ODBC table you are using.