Auditing address fields

You can validate address data in selected GIS attribute fields against the corresponding fields in Infor Operations and Regulations. This ensures that a consistent set of values is displayed in these fields for all address records. For example, you may want to validate street suffixes to ensure that all addresses use the same abbreviations.

  1. Under Validate Address GIS field, select a GIS field from the Address field list.
  2. Select the Infor Operations and Regulations field that corresponds to this field from the Infor PS field list.
    For example, to validate street suffixes in the GIS table against the Infor Operations and Regulations database, select Suffix from the first list and SUFFIX (string) from the second one.
  3. Click Audit Address Fields.
    GeoAdministrator checks the values in the specified field in each database and shows the results in a dialog box. The Mismatched values list shows each value in the GIS table that isn’t found in the Infor Operations and Regulations table. The Contents of Infor PS Code Table list shows each value for this field that exists in the Infor Operations and Regulations table.
  4. To change a mismatched GIS value, select the value in the Infor PS table that you want to replace it with and click the arrow button between the two lists. The selected value is displayed in the Alternative column in the Mismatched values list.
  5. Click Replace to update the values in the GIS table with the selected Infor Operations and Regulations values.