Geocoding a Table using a Geocoding Service - MapInfo_Pro - 2023

MapInfo Pro Help

Product type
Software
Portfolio
Locate
Product family
MapInfo
Product
MapInfo > MapInfo Pro
Version
2023
Language
English
Product name
MapInfo Pro
Title
MapInfo Pro Help
First publish date
1985
Last updated
2023-09-12
Published on
2023-09-12T16:39:16.995549

The process for geocoding a table of addresses is the same using an Envinsa, MapMarker, Precisely Global Geocoder, or the Global Geocoder service. There are two processes for geocoding. The instructions in this section describes both of these processes.

  1. You can geocode a table automatically, which means the service does its best to match the addresses in the table without your help.
  2. You can geocode a table interactively, which means the service gives you choices when there are multiple matches and you select the best match.

Frequently, users perform an automatic geocode and then an interactive one to match the records that the service could not match the first time. This method has been very successful in achieving the most accurate geocoding results.

To geocode a table of data using a geocoding service:

  1. Open the table that contains the data you want to geocode.
  2. On the SPATIAL tab, in the Create group, click Geocode, and Geocode Using Server to open the Geocode using Server dialog box.
    Note: You may notice that the Add button in the Create Driving Regions dialog box or the Geocode using Server dialog box is disabled if you have reached the limit on the number of request values (number of address batches, times, or distances) you have sent to the server. Newer versions of Envinsa allow the server to set limits on the server side, and MapInfo Pro uses these limits. You may see some changes in behavior when you switch servers and the new server has different limits. Another difference you may see is that a particular quantity of address batches, times or distances may work for one server but not for another.
  3. Select a service from the Geocoding Server drop-down list and select the table you want to geocode in the Geocode from Table list.
  4. From the Store Results in Table box, select one of the following:
    • Select Update Input Table to update the current column information with the newly geocoded data.
    • Select Insert into Table and then choose the name of the table you want to use from the drop-down list to store the geocoding results into. Selecting <New> from the drop-down will allow you to create a new table for storing the geocoding results.
      Note: The output table must be writable.
  5. Select the type of geocode you want to perform from these options:
    Street Level - Use street data as the basis for geocoding the data in the selected table.
    Note: Street Level type of geocoding is not allowed when you select Precisely Global Geocoder City/Postal Level in the Geocoding Server drop-down list.

    Postal Centroid Level - Use postal code data as the basis for geocoding the data in the selected table.

    Geographic Centroid Level - Use the City/Town Subdivision as the basis for geocoding the data in the selected table.

    Note: The option you select in this list determines which data (fields) are enabled and required in the next dialog box. The Fallback options are disabled if you select the Postal- or Geographic-level geocoding methods.
  6. To specify the country, select one of the following options. This option is required.

    Specify Country - Use this option to select the appropriate country abbreviation for the data you are geocoding from the drop-down list. Click Get Countries to retrieve a list of countries available from the selected geocoding service.

    From Column - Use this option if the country you are geocoding is listed in a column of the table you are geocoding.

  7. Click Next to continue. The Geocode Properties dialog box displays.


    Note: To change a geocode type or service selection, click Back to return to the Geocode using Server dialog box.

    For more information about the options of the Geocoding Properties tabs, see:

  8. When you have set your options and selections in the tabs of this dialog box click Geocode to begin the geocoding process. A progress bar displays the status of the geocoding process. A summary dialog box displays to report the geocoding results.
    • If you selected Automatic mode, the geocoding process runs to completion.
    • If you selected Interactive mode, and there is more than one matching record for an entry an Interactive Geocode dialog box displays.


      Note: The column widths in this interactive list are maintained throughout the session. Any changes you make here remain.
    • If you do not like the results returned by the geocoding server, enter more complete address data in the selection fields or change the options you selected in the Options dialog box. Then click Search to perform the geocode again.
    • Review the entries on the list to determine which is the closest match. Then do one of the following:

      Highlight the closest match and click Accept to move on to the next record.

      If none of the matches is close enough, click Ignore. If you want to skip the interactive mode process, click Ignore All to run the rest of the process in automatic mode.

    • Once you have matched all of the records in interactive mode, the summary dialog box displays reporting the results of the geocoding process. Click OK to close this dialog box.


      Geocoding Server Results

Note: If you geocode a table and then geocode it a second time using different switches, you may see fewer results compared to the first time. Records with a geocoding result of N (No close match) have output, so that they are not left blank. They contain the input address, which the geocode process does not delete. Results are not left blank so that you can specify the same columns for your input and output to clean the input addresses. To work around this, select all rows that did not geocode and delete the information in their output columns.