Geocoding

Prior to conducting a geocoding operation, you should make an effort to clean your input data table in order to:

• Remove erroneous records
• Clean up column headers to remove spaces and special characters (e.g. ~!@#$%^&*()-.?><,)
• Remove rows that do not contain valid records (except for the header row).
• Format the address information for the target locator
• Store the table in CSV format

See below for step-by-step workflows or video demonstrations for some of the most common applications.

Individual address can be found using the Locate - Search function and the default locator.
Batch processing relies on access to an address locator and WashU has several available; see the Address Locators page for details and links.

1. Add cleaned address table to ArcGIS Pro
2. Right click table in the Table of Contents panel and "Geocode Table"
3. Follow the steps on the Tool panel 
4. Run tool and evaluate results

AGOL will automatically geocode a table of addresses (or other locational information) when the table is added to a map page. Users can drag and drop comma separated value (csv) files into an AGOL map and point features will be added based on those records.The table must have columns containing locational information; coordinates, street addresses, city, state, or zipcode. You will be prompted to select the geocoding type and to specify the columns to use for the operation. 

This process does consume credits (40 credits per 1000 geocoded records) so this is not an appropriate solution for more than 4000 records. 

Contact Data Services if you have a large project and we will help you find the best geocoding solution.