The Linked Address file is a view table used in MapInfo Pro. This table has no structure. It opens the address range street segments (xxxxX1*) and Street Names (xxxxX2*) tables using a join on the MI_REFNUM field, allowing for geocoding in MapInfo Pro.
Field Name | Data Type (Length) | Index | Description |
---|---|---|---|
FROMLEFT | INTEGER | No | First address number on left side of street segment in direction of coordinates |
TOLEFT | INTEGER | No | Last address number on the left side of street segment in direction of coordinates |
FROMRIGHT | INTEGER | No | First address number on the right side of the street segment in direction of coordinates |
TORIGHT | INTEGER | No | Last address number on the right side of street segment in direction of coordinates |
ST_NM_LNG | CHAR (3) | No | 3-character ISO language code for street name |
DISTRICT | CHAR (50) | No | Name of first admin level on the street segment |
TOWN | CHAR (50) | No | Name of second admin level on the street segment |
LOCALITY | CHAR (50) | No | Name of third admin level on the street segment |
PC_LEFT | CHAR (10) | No | Postcode on left side of the street segment |
PC_RIGHT | CHAR (10) | No | Postcode on right side of the street segment |
MICODE | INTEGER | No | MapInfo feature code |
FEATUREID | CHAR (36) | Yes | Universally unique feature identifier |
L_STRUCT | INTEGER | No | Left house number structure 0-Not applicable (default) 1-No house numbers at all 2-Even 3-Odd 4-Mixed 5-Irregular house number structure 6-Alphanumeric mixed |
R_STRUCT | INTEGER | No | Right house number structure 0-Not applicable (default) 1-No house numbers at all 2-Even 3-Odd 4-Mixed 5-Irregular house number structure 6-Alpha numeric mixed |
ST_NM | CHAR (70) | Yes | Street Names |
MI_REFNUM | INTEGER | Yes | Primary key index linking street names with street segment |