Running Address Cleansing with ArcGIS

Run address cleansing on your data to identify and correct errors or inconsistencies with ArcGIS.

Procedure

  1. On the project data page, click Address > ArcGIS.
  2. If you have not created a ArcGIS connection, enter your user name and password to connect to ArcGIS, and then click Test Connection in the "ArcGIS configuration" dialog. See Creating an ArcGIS Connection for details.
  3. Select a method to complete the address cleansing from the following options:
    • Click Use single line to cleanse addresses according to specified columns.

      If Use single line is selected, the Columns area is displayed.

      Select the check boxes before the column names to be used for address cleansing.

    • Click Use multiple field input to cleanse addresses with specified map columns.

      If the Use multiple field input radio button is selected, the Map columns area is displayed.

      Map the source columns to the destination columns in the Map columns area:
      • Automatic mapping: click Auto map. Occasionally, automatic mapping is not able to match all columns.
      • Manual mapping: drag the source and destination columns to the mapping area manually.
    Note: If you do not map the country column in the mapping area, then US is used as the default country.
  4. Specify the number of matched results for each address to be returned:
    • Pick the best result: only one best result is returned.
    • Take the best n results for each address: the specified number of best results are returned.
  5. Move the percentage slider to specify the similarity threshold or specify a number manually.
  6. Click Run to launch the address cleansing operation.