Geocoding

To maintain growth and profitability, a Wake County business wants to expand its customer base. It is important for the business to analyze the locations of its current customers spatially so that it can identify local areas where new customers can be found and organize an effective advertising campaign. This assignment's objective is to visualize the location of the company's customers based on the addresses provided by the company.

Method: Address locator styles can be used to visualize customer data by geocoding address data. In this project, I created two separate address locators using both the US Address - ZIP codes and the US Address - Dual Ranges style. The first step was to create an address locator using the US Address, Zip codes that uses the Zip Code shapefile as a reference to assign input address ZIP codes to Zip Code Polygon Centroids. After running a batch geocoding process, I reviewed the geocoded Matched, Unmatched, and Tied results using the Geocode Address tool. Using the Rematch Addresses geocoding tool, I corrected errors (for Zip codes) in several unmatched records and manually matched geospatial locations based on the highest matching score.

Process Diagram

The purpose of this assignment is to teach me how to geocode tabular addresses so that they can be represented spatially. During the completion of this assignment, I learn how to effectively map collected data represented on an excel spreadsheet using tabular data as a reference data. I leaned about tools such as the geocoding which I could use if I was conducting a survey of any kind and trying to figure out the demographic of the survey people who answered a specific question.

New Problem Description: An outpatient clinic is being established in an underserved community by a regional hospital. Find underserved regions with a need for a new clinic location by analyzing patient address locations.

Data required: Shapefiles of streets obtained from local government GIS repositories or US Census Bureau TIGER/Line Shapefiles for location reference. CSV or Excel file containing tabular patient address information. Once the address data has been geocoded, polygon shapefiles can be used to visually reference the data.

Analysis procedures: Modify tabular data columns to match Address Locator styles. Use ArcMap to create a US Address-Dual Range style Address Locator. Activate the Address Locator to batch geocode the tabular patient data. reviewed the geocoded Matched, Unmatched, and Tied results using the Geocode Address tool. Using the Rematch Addresses geocoding tool, I corrected errors (for Zip codes) in several unmatched records and manually matched geospatial locations based on the highest matching score