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

Complexity:

Beginner

Data Requirement:

ArcGIS Tutorial Data for Desktop

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.

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. Browse to the Atlanta geodatabase, click the Atlanta address locator, and click Add. Click OK.
6. Click OK.

   The Geocode Addresses: Atlanta dialog box appears.

7. In the Address Input Fields section, click Multiple Fields and select the input fields accordingly, if they are not already selected.
8. In the Output section, click the browse button to define the output feature class.

   

   The Saving Data dialog box appears.

9. Click the Save as type drop-down arrow and click File and Personal Geodatabase feature classes.
10. Browse to your copy of the Atlanta geodatabase and double-click the geodatabase. In the Name text box, type Atlanta_Results.
11. 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.

12. Click OK to start geocoding.

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

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 failed 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

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

   The Interactive Rematch dialog box opens.

   

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 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

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 tool and drag over an area of the map.
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.
4. Click the Pick Address from Map button in the Interactive Rematch dialog box.

   Now, when you hover over the map, it shows a cross with a blue dot in the center.

5. Click and hold the mouse button along a street segment to display the nearest qualifying address in a ToolTip box.
6. Hover over the location you want the address to be matched to.
7. Right-click the location and click Pick Address.

   

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

8. 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.

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, browse to the Atlanta geodatabase, click the Atlanta_Composite composite address locator, and 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 Address Input Fields section, if it is not already chosen, click the Street or Intersection drop-down list and choose ADDRESS. Select CITY for the City or Placename field, STATE for State, and ZIP for the ZIP Code field.
6. In the Output section, edit the path to the Atlanta geodatabase and change the result feature class name to Composite_Results.
7. Click OK to start geocoding.

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

   

   You can see that only one address is not matched.

8. 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.

9. 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.

   

10. Close ArcMap. You do not need to save the map document.

Feedback on this topic?