Miscellaneous

The Miscellaneous tab offers a variety of settings that will apply to each job processed.

• Sort file prior to processing—Sorting your file by ZIP Code or city and state greatly optimizes processing. A large, unsorted file can take longer to process than a sorted file. It is strongly recommended that you let Address Coder sort your file unless it is already sorted by either ZIP Code or city and state.
  Remarque :

  Due to certain limitations, delimited text files that don't have a header record will not be sorted. Always attempt to sort by ZIP Code or city/state prior to processing.

• Perform GeoFix—If an address can't be geocoded at the street level (that is, a tract and block group could not be assigned), a best guess is made as to what tract the address is in based on the ZIP Code. The dominant tract within the ZIP Code is assigned to the record.
• Use Negative Longitudes—This will instruct Address Coder to output longitudes with a leading minus sign.
• Automatically open Shapefiles in ArcMap—If you have Esri's ArcMap installed, you can direct Address Coder to open the shapefile it created using ArcMap once processing is complete.
• Treat all fields as text in delimited files—It can be difficult to determine the data type of some fields in text files. If you are having trouble processing a delimited file, try checking this option.
• Play .wav file upon completion—Specify any .wav file you want to make an audible sound upon completion.
• Maximum width of Excel/dBase/SQL text fields—For both Excel and dBASE, this option is usually needed only when you are processing a delimited or Excel file on input where the maximum field widths are unknown. When creating Excel and dBASE files, it can be helpful to place a maximum size on the width of a text field. In Excel this is more cosmetic; it will prevent all the columns from being extremely wide.
  Attention :

  In dBASE (or a shapefile), too many wide columns will exceed the maximum record length that dBASE allows, 4,000 characters, causing Address Coder to fail.

• Significant Digits in Delimited Text Files—This controls the number of digits shown after the decimal point. It defaults to six to show the proper precision for latitude and longitude.
• Output File Text Delimiter—You have a choice of three delimiters that can be used when creating delimited text files: single quote ('), double quote ("), or none.
• Updates—You can be reminded to check for updates and how frequently (in days).
• Address Coder Parameter File— The Address Coder Parameters File (.acpf) contains information required for Address Coder to run. This setting should have been set during installation. As Address Coder begins to process countries other than the US it is possible that you may have a number of .acpf files but for version 10.1 only the US is available.

Remarque :

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