Feature Names Relationship File Record Layout
Feature Names Layout (dbf only)
The Feature Names relationship file contains a record for each feature name-edge combination, and includes the feature name attributes. The edge to which a Feature Names relationship file record applies can be determined by linking to the All Lines shapefile on the permanent edge identifier (ID) attribute. Multiple Feature Names relationship table records can link to the same edge. For example, a road edge could link to U.S. Hwy 22 and Rathburn Road. The linear feature to which the feature name applies is identified by the linear feature identifier (LINEARID) attribute. Multiple feature names may exist for the same edge. Linear features are not included in the data set, but could be constructed using the All Lines shapefile and the relationship tables. Note that the FCC in this relationship file refers to the specific Feature Class Code associated with this linear feature and feature name. If the edge is both a road and a rail feature, the name associated with the rail feature will carry a rail feature FCC. If there are any address ranges on the edge, they apply only to the designated street features.
tl_year_stcty_featnames
Feature Names Relationship File Record Layout | |||
tl_year_[state-county FIPS]_featnames.dbf | |||
Field | Length | Type | Description |
TLID | 10 | Integer | Permanent edge ID |
FULLNAME | 100 | String | Concatenation of expanded text for prefix qualifier, prefix direction, prefix type, base name, suffix type, suffix direction, and suffix qualifier (as available) with a space between each expanded text field |
NAME | 100 | String | Base name portion of the standardized name |
PREDIRABRV | 15 | String | Prefix direction description component of the feature name |
PRETYPABRV | 50 | String | Prefix Type Description component of the feature name |
PREQUALABR | 15 | String | Prefix qualifier description component of the feature name |
SUFDIRABRV | 15 | String | Suffix direction description component of the feature name |
SUFTYPABRV | 50 | String | Suffix Type Description component of the feature name |
SUFQUALABR | 15 | String | Suffix qualifier description component of the feature name |
PREDIR | 2 | String | Prefix direction code component of the feature name |
PRETYP | 3 | String | Prefix type code description component of the feature name |
PREQUAL | 2 | String | Prefix qualifier code component of the feature name |
SUFDIR | 2 | String | Suffix direction code component of the feature name |
SUFTYP | 3 | String | Suffix type code description component of the feature name |
SUFQUAL | 2 | String | Suffix qualifier code component of the feature name |
LINEARID | 22 | String | Linear feature identifier |
MTFCC | 5 | String | MAF/TIGER feature class code |
PAFLAG | 1 | String | Primary/alternate flag |
version 2
Field | Length | Type | Description |
ID | 10 | Integer | Permanent edge ID |
FULLNAME | 100 | String | Concatenation of expanded text for prefix qualifier, prefix direction, prefix type, base name, suffix type, suffix direction, and suffix qualifier (as available) with a space between each expanded text field |
NAME | 100 | String | Base name portion of the standardized name |
PREDIRABRV | 15 | String | Prefix direction description component of the feature name |
PRETYPABRV | 50 | String | Prefix type description component of the feature name |
PREQUALABR | 15 | String | Prefix qualifier description component of the feature name |
SUFDIRABRV | 15 | String | Suffix direction description component of the feature name |
SUFTYPABRV | 50 | String | Suffix type description component of the feature name |
SUFQUALABR | 15 | String | Suffix qualifier description component of the feature name |
PREDIR | 2 | String | Prefix direction code component of the feature name |
PRETYP | 3 | String | Prefix type code description component of the feature name |
PREQUAL | 2 | String | Prefix qualifier code component of the feature name |
SUFDIR | 2 | String | Suffix direction code component of the feature name |
SUFTYP | 3 | String | Suffix type code description component of the feature name |
SUFQUAL | 2 | String | Suffix qualifier code component of the feature name |
LINEARID | 22 | String | Linear feature identifier |
FCC | 5 | String | Feature class code |
PAFLAG | 1 | String | Primary/alternate flag |