This topic describes the table structure and file naming conventions of the Supplemental
Address File layers.
Where the Supplemental Address file tables are organized on state. The file
naming convention is sssa.tab where the first two "ss" denotes the two-letter
state abbreviation, suffix with "sa" which is the census tract layer identifier. For
example, the file name for Washington state supplemental address file is
wasa.tab.
Note:
- This file is only included with the StreetPro Navigation Premium products.
- Not all states contain a Supplemental Address File layers.
- This file does not have a geographic (mappable) component to the table. To make use of this table you will need to join the Address Street layers table geocode1.tab to SA (Supplemental Address) table using the ID field.
| Field Name | Data Type (Length) | Index | Description |
|---|---|---|---|
| ID | CHAR (36) | No | Universally unique feature identifier |
| FROMLEFTALPHA | CHAR (36) | No | First alphanumeric address on left side of street segment in direction of coordinates |
| TOLEFTALPHA | CHAR (36) | No | Last alphanumeric address on left side of street segment indirection of coordinates |
| FROMRIGHTALPHA | CHAR (36) | No | First alphanumeric address on right side of street segment in direction of coordinates |
| TORIGHTALPHA | CHAR (13) | No | Last alphanumeric address on right side of street segment in direction of coordinates |