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.
- Add two 1-char columns to your TAB file. Naming each column, for example, Ind_Right and Ind_Left.
- 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=""