Convert a table to locations on the map

Address table formats with results in the map

To geocode a table of addresses using the Geocode Table pane in ArcGIS Pro, complete the following steps:

  1. Add the table you want to geocode to your map.
    1. Expand the Add Data Add Data drop-down menu on the Map tab on the ribbon, and click Data.
    2. Browse to your table, and double-click the table to add it to the map.

      The table is listed in the Contents pane.

  2. Open the Geocode Table pane, and begin the guided workflow.
    1. Right-click your table in the Contents pane of your map, and choose Geocode Table.

      Geocode table

      The Geocode Table pane appears. It displays a list of steps to geocode your table.

    2. Click Start.

      The guided workflow begins.

  3. Complete the About your table step of the guided workflow.
    1. Confirm that the correct table is displayed in the Input Table text box.
    2. Answer the question regarding the number of fields you want to geocode in your data, and select the corresponding option in the drop-down menu.

      If you are unsure about the number of fields that need to be geocoded, click the Attribute table button Attributes to view the table.

    3. Click Next.
  4. Complete the What locator are you using? step of the guided workflow.
    1. From the Input Locator drop-down menu, choose the input locator you want to use for geocoding.

      Locators added to the project that support batch geocoding automatically appear in the Input Locator drop-down menu of the Geocode Table pane, or you can browse to a different locator by clicking the Browse button Browse.

      Note:

      Performing geocoding operations using the ArcGIS World Geocoding Service requires an ArcGIS Online organizational subscription and consumes credits. The organizational account must have enough credits to complete the entire geocoding request.

    2. Click Next.
  5. Complete the Mapping the fields in your table step of the guided workflow.
    1. For each of the fields in your data that you want to use in geocoding, find the corresponding locator field and choose the appropriate data field in the drop-down menu.

      The field mapping will be completed automatically, but you should review the field mapping to ensure that you do not want to make any changes or map additional fields.

      To review the fields in your data that need to be geocoded, click the Attribute table button Attributes to view the table.

    2. Click Next.
  6. Complete the Output step of the guided workflow.
    1. An output location and name are assigned automatically.

      To change the output, click the Browse button Browse. Then, you can either select a new location or change the name.

      Note:

      Depending on the locator type you chose for geocoding, output may be limited to either a location on disk or a location on your active portal. However, you can still change the name or the location in the folder structure of your designated output location.

      Note:

      By default, your output feature class will be created using the same spatial reference as your locator. Optionally, if you want your output feature class to be created using a different spatial reference, you can adjust it using the Select coordinate system button Select coordinate system. Then, you can choose an output coordinate system.

    2. Optionally, check the Add output to map check box after completion.

      Depending on the size of your table and the location of output, this operation may be time-consuming.

    3. Choose an option for Preferred Location Type from the available drop-down menu.

      When performing geocoding, you may be using the geocoding results to display on a map or for further analysis. In this case, you may want to change the Preferred Location Type setting to Address Location so that the points represent the rooftop or parcel centroid for the address. The point displayed is closest to the center of the feature that represents the address. By contrast, you may be using the geocoding results in a routing application where you want the points to be located on the side of the street for better routing, in which case Routing Location is the better option. With this option, the point displayed is typically closer to the street and closer to where a vehicle would arrive at the location.

    4. Click Next.
  7. Optionally, complete the Limit by Country step of the guided workflow.
    1. If available, choose any combination of countries from the displayed list.

      The capability to limit geocoding by country is determined by the locator you chose and is not always available. If your locator does not support the Country setting, this page of the guided workflow does not appear.

      When using the World Geocoding Service or other locators that support multiple countries, you may want to specify that geocoding should only happen in specific countries. This is important because it can improve geocoding performance and reduce the potential for an address to false-positively match in another country. It is possible for an address in one country to look very similar to an address in another country. Geocode Table allows you to choose one or more countries to limit the results of the geocoding. In some cases, your table may contain addresses for many countries, in which case you should have a country field in the data and map that field in the field mapping section of the tool as opposed to selecting multiple countries in this step. Mapping a country field from the table will help to pinpoint the country for each record.

    2. Click Next.
  8. Optionally, complete the Limit by category step of the guided workflow.
    1. If available, choose any combination of categories from the displayed list.

      The capability to limit geocoding by category is determined by the locator you chose and is not always available. If your locator does not support the Category setting, this page of the guided workflow does not appear.

      You may want to limit the results of geocoding to specific categories, such as only address matches, because the geocoding results are for parcel delivery. Another example is if you know the entire table consists of cities, and you don’t want New York to match to New York State or even New York County. Using this parameter limits matches to a specific type of location.

  9. Review all inputs in the final step of the guided workflow, and run Geocode Table.
    1. Make sure all the inputs on the final page of the guided workflow display the inputs you chose in the previous steps.
    2. Click Run.

      The progress of the tool is displayed at the bottom of the pane.

      If you selected the Add output to map option in the Output step of the guided workflow, the output is added to the map automatically.

      Geocode Table completed tool

Once you have a geocoded feature class, you can optionally add individual geocoding results from the Locate pane.

To review or change any of the results, add the feature class to the map if necessary, right-click the new feature class in the Table of Contents pane, and click Data > Rematch Addresses Rematch Addresses.

Related topics