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

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)