Geocoding

Strategies

ArcMap & ArcGIS Pro was used to perform the analysis. Client provided customer data was imported from their Excel spreadsheet and the address locator geoprocessing tool and geocode address tool were used to geolocate their customers first by zip code and then by street address. Reference data used for the analysis included a Wake County boundary line, Wake County zip codes and Wake County streets all of which are obtained from Wake county’s publicly available website.

Methods

I was provided an excel spreadsheet of the client’s customer data. I imported it into ArcGIS Pro and set up an address locator using US Address - ZIP 5-Digit and the Wake County zip code shapefile for reference. I then ran a batch geocoding process on the customer data using the locator. I then reviewed, fixed and rematched the results as needed.

I then created a second address locator using the US Address – Dual Ranges style and the Wake County Streets shapefile for reference. I then ran batch geocoding using the newly created locator and reviewed the results noting that no matches were made. This was due to the fact that the street number and name were not contained in one cell, so I added a field in the attribute table (this all took place in ArcMap because I couldn’t get it to work in ArcGIS Pro) and combined the fields before rerunning the batch geocoding process. I then reviewed, fixed and rematched the results as needed. Three addresses had to be manually located. I labeled them and created a map layout for both: customers geocoded to streets & customers geocoded to zip codes.