Exercise 4: Geocoding addresses in a table and rematching unmatched addresses

Complexity: Beginner Data Requirement: ArcGIS Tutorial Data Setup Data Path: c:\ArcGIS\ArcTutor\Geocoding Goal: To geocode a table of addresses and rematch the geocoded feature class

Geocoding addresses in a table

If you have a table that contains address information, you can geocode all the addresses at once. In this exercise, you will begin with a table containing the addresses of customers and geocode the entire table, showing where the customers are located.

Steps:
  1. Open a new map document in ArcMap. You do not need to save the map you created in the previous task.
  2. Add the Streets feature class and the customers table from your copy of the Atlanta geodatabase to your map.
  3. Right-click the customers table on the List by Source view of the Table of Contents and click Geocode Addresses in the context menu.
  4. Click Add in the Choose an address locator to use dialog box.

    The Add Address Locator dialog box opens.

  5. Navigate to the Atlanta geodatabase, click the Atlanta address locator, then click Add. Click OK.
  6. Click OK.

    The Geocode Addresses: Atlanta dialog box appears.

  7. In the Output section, click the Browse button Browse to define the output feature class.
    Geocoded Addresses: Atlanta dialog box

    The Saving Data dialog box appears.

  8. Click the Save as type drop-down arrow, then click File and Personal Geodatabase feature classes.
  9. Navigate to your copy of the Atlanta geodatabase, then double-click the geodatabase. In the Name text box, type Atlanta_Results.
  10. Click Save.

    A new point feature class named Atlanta_Results will be created in the Atlanta geodatabase. The point features generated by the geocoding process will be saved in the feature class.

  11. Click OK to start geocoding.

    The Geocoding Addresses dialog box is displayed showing the matching statistics and the progress bar for the matching process.

  12. When the geocoding process is finished, the Geocoding Addresses dialog box shows the final statistics of the addresses that were matched or not matched. In this tutorial, three addresses fail to match and one address is tied. You'll rematch the unmatched addresses later in the tutorial.
  13. Click Close to close the Geocoding Addresses dialog box.

    A Geocoding Result layer is added to the map. It shows the points that were added to the Atlanta_Results feature class.

Rematching addresses

Steps:
  1. Select the Geocoding Result: Atlanta_Results layer in the Table of Contents and click the Review/Rematch Addresses button Review/Rematch Addresses on the Geocoding toolbar.

    The Interactive Rematch dialog box opens.

    Interactive Rematch

  2. The Interactive Rematch dialog box may display all the records in the geocoded feature class at the top of the dialog box. In this exercise, there are three addresses that were not matched. To rematch the unmatched address records, click the Show results drop-down arrow and click Unmatched Addresses. The result will show three records, and the first one is automatically selected. Sometimes, an address is not matched because a perfect match cannot be found, but there are close match candidates. The candidates are listed in the Candidates section of the dialog box.
  3. Arrange the ArcMap window and the Interactive Rematch dialog box so you can see the map.

    Near the center of the map, you will notice a few points that are highlighted: one in yellow and the others in cyan. These are the locations of the candidates listed in the bottom window of the Interactive Rematch dialog box. The selected candidate is highlighted in yellow on the map.

  4. Click the Zoom In button Zoom In on the Tools toolbar and drag over the area of the candidates to zoom in on them.
  5. Click the fourth candidate in the candidate list. The location of the yellow highlighted candidate changes on the map.
  6. Click the Match button in the bottom of the dialog box. The selected address is now associated with the fourth candidate in the list at the bottom and the Status field is changed from U to M.

    The list of unmatched addresses is updated.

Rematching addresses by picking a point location on the map

Steps:
  1. The result set shows two addresses that were not matched.
  2. Arrange the ArcMap window and the Interactive Rematch dialog box so you can see the map.
  3. Click the Zoom In Zoom In tool and drag over an area of the map.
  4. Next, you will use Pick Address from Map to match an unmatched address. You can use this tool to match or rematch an address when you know where it should be located on the map.
  5. Click the Pick Address from Map button Pick Address from Map in the Interactive Rematch dialog box.

    Now when you point the mouse cursor on the map, it shows a cross with a blue dot in the center.

  6. Click and hold the mouse button along a street segment to display the nearest qualifying address in a ToolTip box.
  7. Place the mouse pointer on the location you want the address to be matched to.
  8. Right-click the location and click Pick Address from the context menu.
    Pick Address context menu

    The unmatched address is now matched to the point location you just picked.

  9. Click Close to close the Interactive Rematch dialog box.

Geocoding addresses using a composite address locator

In this exercise, the customers address table is geocoded against the composite address locator you created in exercise 2. It shows how addresses are matched against multiple address locators to find best matches.

Steps:
  1. Right-click the customers table on the List by Source view of the table of contents and click Geocode Addresses.
  2. Click Add in the Choose an address locator to use dialog box.

    The Add Address Locator dialog box opens.

  3. In the Add Address Locator dialog box, navigate to the Atlanta geodatabase, click the Atlanta_Composite composite address locator, then click Add to close the Add Address Locator dialog box.
  4. Click OK to close the Choose an address locator to use dialog box.

    The Geocode Addresses: Atlanta_Composite dialog box opens.

  5. In the Output section, edit the path to the Atlanta geodatabase and change the result feature class name to Composite_Results.
  6. Click OK to start geocoding.

    The Geocoding Addresses dialog box is displayed showing the matching statistics and the progress bar for the matching process.

    Geocoding Addresses progress bar

    You can see that only one address is not matched.

  7. Click Close.

    The Geocoding Addresses dialog box closes, and a Geocoding Result layer is added to the map. The layer shows the points that were added to the Composite_Results feature class.

  8. Right-click the Composite_Results layer and click Open Attribute Table.

    You can see that the name of the participating address locator used to match the address is shown in the Loc_name field of the attribute table. Some addresses that failed to match against the Atlanta address locator were instead matched by ZIP Code against the Postal_US locator.

    Attribute table of the geocoded result feature class
  9. Close ArcMap. You do not need to save the map document.

8/18/2010