Problem: StreetMap: Addresses not matching
Addresses match correctly when interactively matching with the LOCATE ADDRESS tool. The same addresses do not match when using the batch method with the GEOCODE ADDRESS tool; no matches are returned.
One possibility is that the State field contains the full state name instead of the state abbreviation.
Solution or Workaround
Recalculate the State field so that it contains abbreviations. The steps below use Michigan as an example. Repeat for each state in your data set.
- Open the table.
- Select Start Editing from the Table menu.
- Select Query from the Table menu.
- Enter the following equation in the expression box of the Query Builder dialog box and click New Set.
[State] = "MICHIGAN"
- Make the State field active and select Calculate from the Field menu.
- Enter the following value in the expression box of the Field Calculator dialog box and click OK.
All occurences of "Michigan" in the state field should now be "MI".
Last Published: 5/5/2016
Article ID: 000003477