Fields Tab

The Fields tab indicates what fields contain the information needed to geocode a record. Based on their names, Address Coder will attempt to assign them to the proper fields. If you are processing a fixed field file, a Fields button appears that will allow you to indicate how to parse the record. For Excel and delimited files, a check box appears indicating whether or not there is a header record.

If a Volumetric field is specified, the field must contain numeric data. Each record will be weighted by this data on Tapestry Profile reports.

注意:

Some options and data variables may vary based on the locator being used.

Fixed Field

When processing a fixed field file, it is necessary to define the width of every field in the file. Initially, Address Coder will show one field having the full width of the record. You will need to add sufficient column definitions for every field in your file, then adjust their widths. The lower box shows you how the current definitions are breaking up the record.

To add a new column definition, simply enter the name and width and click Add New and it will be added to the list on the left. To make changes, select an item on the left, make the needed adjustments in the Name and Width text boxes, then click Replace.

ヒント:

Address Coder will attempt to assign the address fields based on the column/field labels that exist in your file. If your file does not have column/field labels (generally this applies to text files), you should determine the layout ahead of time by viewing the file in a text editor.

Address Coder looks for key words like Address, Street, City, Town, State, ZIP, Postal, Company, and Firm when trying to assign the fields in your file. In most files, address fields can be broken into two types: those fields that pertain to the street address and those that pertain to the last line (city, state, and ZIP Code).

The address list boxes should be used to assign the fields that contain the street address, apartment number, and any other information that will help locate the record excluding the city, state, and ZIP Code fields. Fields that contain the city, state, and ZIP Code should be assigned in that order; that is, city before state and state before ZIP Code. If your file contains one field for both the city and state, that should be listed before the field containing the ZIP Code.

If your file has a free floating address—in other words, the person's name, address, city, state, and ZIP Code appear in a number of columns—you will need to use just the Address boxes on the Fields tab. See the following comma-delimited records as examples:

John Jones,123 Main St,Anytown,CA,99987,
Mary Smith,1458 65th St,Apt 2,Anytown,CA,99987
Alice Martin,Tom Martin,432 High St,Anytown CA,,99987

In this example, no single piece of information can be found in the same field on every record. In this case, you would supply all 6 fields to Address Coder in the Address boxes and leave the City/State/ZIP Code boxes as None Specified. Address Coder will look at each record individually and determine the street address, city, state, and ZIP Code.