The Geocode Locations from Table tool is a convenient way to geocode large tables of addresses into points. The output is a feature layer in your ArcGIS Enterprise portal contents that can be used for analysis in ArcGIS Enterprise, ArcGIS Desktop, or other products. Geocode Locations from Table creates an item in your contents containing the geocoded data.
Workflow diagram
Examples
A national chain has multiple CSV files, each containing addresses of 100,000 transactions. The marketing director wants to know where the transactions are densely concentrated to determine where to locate new stores. The GIS analyst could use Geocode Locations from Table to geocode the 100,000 addresses. Once the feature layer has been geocoded, the analyst could then use the tool to find areas that would support another store.
Usage notes
The Geocode Locations from Table tool requires a tabular input. You can use a tabular dataset from a big data file share, or a tabular layer in a feature service with at least one table or file. If you do not have any tables, CSV files, or XLS files in Content, the tool will be unavailable. You can add files to Content using the Add Item button.
Note:
You cannot upload a CSV file or XLS file to be geocoded by ArcGIS GeoAnalytics Server. Use the standard tool Geocode Locations from Table if you want to upload a dataset to be geocoded. To learn more about the tool, see Geocode Locations from Table.
The Country option only appears when the Esri World Geocoder is selected. Using the Esri World Geocoder with the Geocode Locations from Table tool consumes credits.
If the input data is all in one field, click Single Field. If the table has multiple data fields that all contain different address information, click Multiple Fields.
Any features that are not matched in the geocoding process will be included in the output without a geometry.
You can choose to return additional geocoding fields that are provided by the locator. If you do not return these fields, your results will include the following:
- Your original input data
- Point geometry of geocoded locations
- A new object ID field, as well as a globalid field if you store results in the spatiotemporal data store
If you decide to return the additional geocoding information, you will have additional fields returned. To see a sample of fields that may be returned by your locator, see Service output.
Limitations
- A locator can only be used if it is configured as a utility service by an administrator. For more information, see Configure the portal to geocode addresses.
- You cannot use the Esri World Geocoder with GeoAnalytics Tools. To use the Esri World Geocoder, use the standard analysis tool Geocode Locations from Table.
How Geocode Locations from Table works
Locators must be configured for batch geocoding
For a locator to appear in the list of available locators, the locator must be configured for batch geocoding. The locator should be configured as follows:
- The locator must be a portal utility service.
- The locator should have the numThreads property configured on the locator service. The numThreads property is not required, but it may speed up the analysis job.
Similar tools
Use Geocode Locations from Tables to geocode tabular locations stored in tables in big data file shares and services. Other tools may be useful in solving similar but slightly different problems.
Map Viewer analysis tools
If you would like to geocode a CSV or XLS file, or use the Esri World Geocoder, use the standard tool Geocode Locations from Table.
ArcGIS Desktop analysis tools
The standard tool Geocode Locations from Table is available in ArcGIS Pro.