Output column type/width requirements – Pitney Bowes MapMarker USA User Manual

Page 57

Advertising
background image

Chapter 3:

Understanding the Geocoding Process

MapMarker USA 25

57

User Guide

For instructions on selecting output columns, see

Selecting Output Columns on page 75

.

See the following topics:

Supported File Formats
Geocoding Flexibility and Trade-offs
General Guidelines for Optimizing Geocoding
Specify Input Address Columns
Output Column Type/Width Requirements
Interpreting Census Block IDs
Output Field Size and Column Names
Mixed Case Street Output
Setting Startup Preferences

Output Column Type/Width Requirements

The

Output Column Width Requirements

table lists the type and width requirements for output

columns.

The asterisked columns always optional. All other columns are required for generating a CASS™
report (not required for geocoding to CASS standards, but for generating the report.)

For more information on LACS

Link®

and DPV

®

output requirements, see the following topics.

LACSLink Output Columns on page 142

DPV Output Columns on page 146

Output Column Width Requirements

Output Column

Type (Width)

Result Code

char(13)

Match Code

char(4)

Location Code

char(4)

Long (X)

Decimal (11,6) or Float

Lat (Y)

Decimal (10,6) or Float

Firm

char(30)

Address

char(64)

Address2

char(64)

City

*

char(30)

State

*

char(2)

Output County

char (40)

Advertising