Using User Dictionaries with address point interpolation

An important part of the process of creating a User Dictionary is to specify a mapping of fields from your source data. There are two main categories of data fields: required and optional.

Of the optional fields, there are two that have an impact on the address point interpolation feature. These are the Left Odd/Even Indicator and Right Odd/Even Indicator fields. If these are not populated, the results from address point interpolation is less accurate.

Be aware that the aforementioned fields are not populated by source data obtained via MapInfo Pro. You must modify the source TAB file by adding the Left Odd/Even Indicator and Right Odd/Even Indicator fields, and create queries to populate them. Source data obtained from other products, or your own data, may have similar issues.

To add the Left Odd/Even Indicator and Right Odd/Even Indicator fields to a source TAB file, you must add them, then run a series of SQL update queries to populate them. The fields should be filled in with O (odd), E (even), or B (both). Below are the steps for adding these fields:
  1. Add two 1-char columns to your TAB file. Naming each column, for example, Ind_Right and Ind_Left.
  2. Perform the following updates to populate these fields:
    • Update <tablename>. Set Ind_Left="E", Ind_Right="O". Where From_Left mod 2=0 AND To_Left mod 2=0
    • Update <tablename>. Set Ind_Left="O", Ind_Right="E". Where From_Left mod 2=1 AND To_Left mod 2=1
    • Update <tablename>. Set Ind_Left="B", Ind_Right="B". Where From_Left="" AND To_Left=""
Note: These example queries are simplified for illustrative purposes. Your actual queries may need to be more complex.