When you add and select the Geocoder layer in MapInfo Pro Layer Control, black lines are rendered over the existing streets.
Now, when you use the Info tool to point at a particular road with address range information, and then click on the Geocoder link at the top of the resultant box:
The associated address range information opens, together with Road Class information and an indicator (True or False) of whether the selected feature is a Toll road:
Click the double arrow symbol to view the miCode,
Longitude and Latitude, and A2_Code, is a numeric code
consisting of the state FIPS + county FIPS code.
The Geocoder table is a view table and has no structure, it opens the geocode1 and geocode2 tables and joins them on MI_Refnum to create a table view.
Field Name | Data Type (Length) | Index | Description |
---|---|---|---|
FROMLEFT | DECIMAL (10,0) | No | First address number on left side of street segment in direction of coordinates |
TOLEFT | DECIMAL (10,0) | No | Last address number on the left side of street segment in direction of coordinates |
FROMRIGHT | DECIMAL (10,0) | No | First address number on the right side of the street segment in direction of coordinates |
TORIGHT | DECIMAL (10,0) | No | Last address number on the right side of street segment in direction of coordinates |
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 - Alpha numeric 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 - Alphanumeric mixed |
NAME_LNG | CHAR (3) | No | 3-character ISO language code |
NAME_TYPE | DECIMAL (3,0) | No | Street name type (bit mask): 0 - No name 1 - Official name 2 - Alternate name 4 - Route name 8 - Brunnel name 16 - Street name 17 - Street name (16) and Official name (1) (i.e. a value of '17' represents a NAME_TYPE which is a Street name (16) as well as an Official name (1)) 32 - Locality name 64 - Postal street name |
PC_LEFT | CHAR (10) | No | Postcode on left side of segment |
PC_RIGHT | CHAR (10) | No | Postcode on right side of segment |
CITYLEFT | CHAR (100) | No | City name on left side of segment |
CITYRIGHT | CHAR (100) | No | City name on right side of segment |
STATELEFT | CHAR (2) | No | 2 character state abbreviation on left side of segment |
STATERIGHT | CHAR (2) | No | 2 character state abbreviation on right side of segment |
MICODE | INTEGER | No | MapInfo feature code |
ROAD_CLASS | SMALLINT | No | Functional road class: 1 - Major road less important than a motorway 2 - Other major road3 - Secondary road 4 - Local connecting road 5 - Local road of high importance 6 - Local road 7 - Local road of minor importance 8 - Other road |
TOLL | LOGICAL | No | Logical flag indicating if segment is part of a toll road |
ID | CHAR (36) | No | Universally unique feature identifier |
MI_REFNUM | INTEGER | Yes | Primary key index linking street names with segment data |
Field Name | Data Type (Length) | Index | Description |
---|---|---|---|
NAME | CHAR (100) | No | Street name |
MI_REFNUM | INTEGER | Yes | Primary key index linking street names with segment data |