US Census County Based TIGER/LineĀ® 2009 Data Dictionary

Developed by ScribeKey

Entity, Joins, Attributes, and Domains

ReadMe TIGER/Line Overview Layers and Tables FGDC Dataset Metadata

Entity
Name Full Name Type Definition
FEATNAMES Feature Names Relationship File Table 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 (TLID) 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.

Joins
No. From Entity From Attribute To Entity To Attribute Cardinality Description
1 FEATNAMES LINEARID ADDRFN LINEARID N to N Each edge can have zero, one, or multiple feature names.
2 FEATNAMES TLID EDGES TLID N to 1 Each edge can have zero, one, or multiple feature names.

Attributes

Single Record Layout

Attributes
No. Short Name Full Name Definition Data Type Max Chars Key Permanent Subtype Allowed Values Sample Values Distinct Values Nulls Percent Complete Formats Max Length Min Value Max Value
1 TLID Permanent edge ID   Integer -1 Foreign Y     40031762, 40037470, 40037580, 40038858, 40043028 119,447 0 100 N8 9 40031762 621689801
2 FULLNAME Full name 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. Text 100         null, 10th St, 11th Ave, 11th St, 12th Ave 14,669 29,760 77.29 N2L2S1U1L1 36   Zygouris Rd
3 NAME Base name Base name portion of the standardized name. Text 100         null, 1, 10th, 110, 111, 113, 115, 117, 119 8,458 29,760 77.29 N1 36   Zygouris
4 PREDIRABRV Prefix direction Prefix direction description component of the feature name. Text 15         null, E, N, NE, S, W 6 129,867 0.9 U1, U2 2   W
5 PRETYPABRV Prefix type description Prefix type description component of the feature name. Text 50         null, Ave, Co Rd, I-, Lk, Rd, State Hwy, State Rd 11 119,751 8.62 U1L2, U1L1S1U1L1, U1S1, U1L4S1U1L2 9   Via
6 PREQUALABR Prefix qualifier description Prefix qualifier description component of the feature name. Text 15         null, Old 2 130,184 0.66 U1L2 3   Old
7 SUFDIRABRV Suffix direction description Suffix direction description component of the feature name. Text 15         null, E, N, NW, S, W 6 130,735 0.24 U1, U2 2   W
8 SUFTYPABRV Suffix type description Suffix type description component of the feature name. Text 50         null, Aly, Ave, Blvd, Br, Brg, Brk, Cir, Cmn, Cmns 51 42,629 67.47 U1L2, U1L3, U1L1, U1L5 7   Xing
9 SUFQUALABR Suffix qualifier description Suffix qualifier description component of the feature name. Text 15         null, Acc, Alt, Con, Exd, Exn 6 129,627 1.09 U1L2 3   Exn
10 PREDIR Prefix direction code Prefix direction code component of the feature name. Text 2       FEATNAMES.PREDIR null, 11, 12, 13, 14, 15 6 129,867 0.9 N2 2   15
11 PRETYP Prefix type code description Prefix type code description component of the feature name. Text 3       FEATNAMES.PRETYP null, 125, 214, 344, 361, 531, 579, 585, 605 11 119,751 8.62 N3 3   655
12 PREQUAL Prefix qualifier code Prefix qualifier code component of the feature name. Text 2       FEATNAMES.PREQUAL null, 20 2 130,184 0.66 N2 2   20
13 SUFDIR Suffix direction code Suffix direction code component of the feature name. Text 2       FEATNAMES.SUFDIR null, 11, 12, 13, 14, 16 6 130,735 0.24 N2 2   16
14 SUFTYP Suffix type code Suffix type code description component of the feature name. Text 3       FEATNAMES.SUFTYP null, 112, 125, 142, 146, 147, 148, 165, 183 51 42,629 67.47 N3 3   661
15 SUFQUAL Suffix qualifier code Suffix qualifier code component of the feature name. Text 2       FEATNAMES.SUFQUAL null, 11, 12, 15, 16, 17 6 129,627 1.09 N2 2   17
16 LINEARID Linear feature identifier The linear feature to which the feature name applies is identified by the linear feature identifier attribute. An edge can have several feature names; an address range located on an edge can be associated with one or any combination of the available feature names (an address range can be linked to multiple feature names). The address range is identified by the address range identifier (ARID) attribute, which can be used to link to the Address Ranges Relationship File. The linear feature name is identified by the linear feature identifier (LINEARID) attribute that relates the address range back to the Feature Names Relationship File. Linear features are not included in the data set, but could be constructed using the All Lines shapefile and the relationship tables. Text 22 Foreign, Virtual       1102175503280, 1102175529568, 1102175529594 50,763 0 100 N13 13 1102175503280 110557043995
17 MTFCC MAF/TIGER feature class code The MTFCC is a 5-digit code intended to classify and describe geographic objects or features. The MTFCC replaced the Census Feature Class Code (CFCC) used before 2007 and was expanded to include features that previously did not have codes. MTFCC definitions are available in the metadata files that accompany each shapefile and relationship file and in Appendix F of this document. A crosswalk between CFCC and MTFCC codes can be found on the TIGER/Line website (http://www.census.gov/www/geo/tiger). Text 5       FEATNAMES.MTFCC H1100, H3010, H3020, L4010, L4020, L4110, L4130 21 0 100 U1N4 5 H1100 S1820
18 PAFLAG Primary/alternate flag Code designating the feature name as Primary=P or Alternate=A when more than one name exists. Generally, local street names, e.g., 'Washington St' will be primary and route numbers, e.g., 'Route 16' will be alternate. Text 1     Y FEATNAMES.PAFLAG A, P 2 0 100 U1 1 A P

www.scribekey.com