ArcMap Address Matching Lab
Due in two weeks
The objective of this lab is to expose you to another of ArcMap's
capabilities: address matching, sometimes called geocoding.
The notion is to convert street addresses (like 231 Nanana Street)
to coordinates. This is done by matching the addresses
against a database of street segment records, conceptually
like those in GBF/DIME, to find the data record with the best
matching street name and address range, and then interpolate
along the segment to associate a geometric point with the address.
This functionality is provided under the Tools -> Geocoding menu.
In this lab you will:
Create an "Address Locator" (arc-speak for making an indexed database
out of a street segment shapefile for address matching),
match an existing file of addresses against that "Address Locator"
to produce a shapefile from the list of addresses,
plot the matched addresses on a map and examine the unmatched addresses
to gain insight into what constitutes 'problem addresses'.
practice reading the 'help' in ArcGIS.
The data are in \\Odin\Data\Geog_488.
You may already have that drive "mapped" or the data copied to
your own disk.
allroad3.shp - the Oahu street segment data (Or try the C&C
Street data that you have been using.)
restaura.txt - a list of restaurants extracted from a recent yellow-pages
In ArcMap's and/or ArcCatalog's Help function(s),
particularly about the
address locator until you have a feel for
how Arc is going to do this. The material indexed under
"addresses, locator style" and "addressess, matching"
(the latter is an external .pdf file that tells about
the rule base for address matching) is especially useful.
Create your "address locator" from the allroad3 shapefile by
following the directions in the "Creating an address locator"
In ArcMap, geocode the addresses by following the directions
in the "Geocoding a table of addresses" help.
(Basically, add the addresses to the project and activate
Geocoding from the "Tools" menu. Select the "address locator"
and the table to geocode. Indicate which fields to use and
where to save the result.
(U:\Geocoding_Result for instance).
Run it, and it should add the output to your map on screen.
Produce the deliverables and answer the questions below.
- A map showing the distribution of matched restaurants.
- A table showing the counts of the matched, the unmatched,
and the partially matched addresses (summarize on status)
for each of the "address styles"
- A one page write up indicating:
- what address information was in the file that you geocoded?
- which "styles" of address locators would best fit these data,
which of those you tried, and
which of those seemed to work best with these data?
- An assessment of the apparent kinds of problems the software had in
matching the unmatched addresses.
- Your observations on what might make this work better.
Help - is on the main menu. You will be better off getting used to using it
to help solve problems than not doing so.
Making new "address locators" takes only a few seconds and greatly
affects the results. In one recent class test case, just switching from
"US Streets" to "US hyphenated ranges" increased the match rate by
more than 50%.