Hands On The composite address locator should generate 20 ties and 12 unmatched addresses. gate to \Lakewood\SHPFiles\StatePlane and load only Composite_Parcel_Street_ TIGER. Close the Locator Manager window. 2. Open the TOC Source tab, right-click the Inc_2008_Address table, and select Geocode Addresses. 3. Set the output file location and name to \Lakewood\SHPFiles\StatePlane\Inc_2008_ GC1. Using a numeric counter in the file name will make it easier to rerun the model or test it with differing parameters. Click the Geocoding Options button to verify that all three individual locators participate in the composite address locator. Update or adjust properties, such as spelling sensitivities and threshold scores, at the same time if necessary. Click OK to continue and watch the geocoding process. 4. If the three address locators were built according to the specifications given, they should generate a high percentage of matches. Only about 20 ties and 12 unmatched addresses should be left from the set of 6,976 incidents. 5. The sample dataset includes a Microsoft Excel spreadsheet containing suggested fixes for known addressing errors. Navigate to \Lakewood\Utility and load the Database worksheet, Fixes1.xls. Review its contents. In the real world, records management at a fire station is never perfect, and this spreadsheet contains fixes for several nongeocoded records. 6. To update these unmatched or tied records, click the Rematch button. Let’s repair unmatched addresses. Under Interactive Rematch, look at the Show results area and select Unmatched Addresses. In the results window, locate an improperly geocoded address and find its corresponding entry in the Fixes1 table. Copy the ADDRESS2_F string into the text box next to Address on the left side of the Interactive Rematch dialog box. Click the address in the Candidates list and select the record with the highest percentage (which will Click the Rematch button and under Interactive Rematch, select Unmatched Addresses. Use the Fixes1 table to fi x unmatched addresses by copying the ADDRESS2_F string into the text box next to Address on the left side of the Interactive Rematch dialog box. likely be the one with the highest order, e.g., 1_, 2_, or 3_) and click Match. The score will change from U to M, and the Loc_name field now lists reference data, providing the best fit. Continue down the list, making repairs, selecting the best reference data and building matches. When finished, all records should match. 7. Review tied records next. In Show results, select Matched Addresses with Candidates Tied. Locate the ADDRESS2 window and sort its contents so identical tied addresses are grouped. Ties often occur in clusters, so fixing one will often fix others. 8. Click one of the candidates in the window. The selected record is displayed as a larger yellow dot on the map. Below the Candidates window, click the Zoom to Candidates button. If you could access the actual incident records, you could select the appropriate point. However, that is not the case in this exercise, so select the westernmost or northernmost point (as long as these points are in close proximity— Continued on page 52 www.esri.com ArcUser Spring 2010 51