An important part of the process of creating a User Dictionary is to specify a mapping of fields from your source data. See the MapInfo User Dictionary Utility Product Guide, for a complete discussion. 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" and "Right Odd/Even" fields. If these are not populated, the results from address point interpolation is less accurate.
Please be aware that aforementioned fields are not populated by source data obtained via MapInfo StreetPro. You must modify the source TAB file by adding the "Left Odd/Even" 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" and "Right Odd/Even" indicator fields to a source TAB file, you must add them and 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:
- 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=""
- Update <tablename>