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
AREALM Area Landmark Polygon The Census Bureau includes landmarks in the MAF/TIGER database for locating special features and to help enumerators during field operations. Some of the more common landmark types include area landmarks such as airports, cemeteries, parks, and educational facilities and point landmarks such as schools and churches.

Joins
No. From Entity From Attribute To Entity To Attribute Cardinality Description
1 AREALM AREAID FACESAL AREAID 1 to N An area landmark may consist of multiple faces.

Attributes

Table Layout

FieldValue
No.1
Short NameSTATEFP
Full NameCurrent state FIPS code
DefinitionCurrent state Federal Information Processing Standards (FIPS) code. The census provides specific layers for these areas through Nation and State based Shapefiles.
Data TypeText
Max Chars2
KeyForeign, Census
Permanent 
SubType 
Allowed Values 
Sample Values25
Distinct Values1
Nulls0
Percent Complete100
FormatsN2
Max Length2
Min Value25
Max Value25

FieldValue
No.2
Short NameCOUNTYFP
Full NameCurrent county FIPS code
DefinitionCurrent county Federal Information Processing Standards (FIPS) code, unique by state. The census provides specific layers for these areas through Nation and State based Shapefiles.
Data TypeText
Max Chars3
KeyForeign, Census
Permanent 
SubType 
Allowed Values 
Sample Values017
Distinct Values1
Nulls0
Percent Complete100
FormatsN3
Max Length3
Min Value017
Max Value017

FieldValue
No.3
Short NameANSICODE
Full NameGNIS Identifier
DefinitionCurrent official Geographic Names Information System (GNIS) code for the landmark for use by federal agencies for data transfer and dissemination, if applicable.
Data TypeText
Max Chars8
KeyForeign, GNIS
PermanentY
SubType 
Allowed Values 
Sample Valuesnull
Distinct Values1
Nulls38
Percent Complete0
Formats 
Max Length1
Min Value 
Max Value 

FieldValue
No.4
Short NameAREAID
Full NameArea landmark identifier
DefinitionArea landmark identifier.
Data TypeText
Max Chars22
KeyPrimary
Permanent 
SubType 
Allowed Values 
Sample Values110340945888, 110340946108, 110340946147
Distinct Values38
Nulls0
Percent Complete100
FormatsN12
Max Length12
Min Value110340945888
Max Value110340951158

FieldValue
No.5
Short NameFULLNAME
Full NameFull Name
DefinitionConcatenation 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.
Data TypeText
Max Chars100
Key 
Permanent 
SubType 
Allowed Values 
Sample Valuesnull, Ashland State Park, Bell Rock Cmtry
Distinct Values30
Nulls8
Percent Complete78.95
FormatsU1L6S1U1L4S1U1L3
Max Length22
Min Value 
Max ValueWhittemore Park

FieldValue
No.6
Short NameMTFCC
Full NameMAF/TIGER feature class code
DefinitionThe 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).
Data TypeText
Max Chars5
Key 
Permanent 
SubType 
Allowed ValuesAREALM.MTFCC
Sample ValuesC3023, K2180, K2184, K2361, K2451, K2457, K2582
Distinct Values7
Nulls0
Percent Complete100
FormatsU1N4
Max Length5
Min ValueC3023
Max ValueK2582

FieldValue
No.7
Short NameALAND
Full NameCurrent land area in square meters.
Definition 
Data TypeInteger
Max Chars-1
Key 
Permanent 
SubType 
Allowed ValuesAREALM.ALAND
Sample Values0, 2027, 3399, 3875, 5105, 5240, 5682, 6400, 6484
Distinct Values38
Nulls0
Percent Complete100
FormatsN1, N4, N5, N6, N7
Max Length7
Min Value0
Max Value6018144

FieldValue
No.8
Short NameAWATER
Full NameCurrent water area in square meters
Definition 
Data TypeInteger
Max Chars-1
Key 
Permanent 
SubType 
Allowed ValuesAREALM.AWATER
Sample Values0, 3881, 4470, 5008, 5333, 5927, 13757, 20294
Distinct Values9
Nulls0
Percent Complete100
FormatsN1, N4, N5, N6
Max Length6
Min Value0
Max Value690895

FieldValue
No.9
Short NameINTPTLAT
Full NameCurrent latitude of the internal point
DefinitionY centroid value which can be used to generate or display point features representing polygon areas. The Census represents these as text fields containing +/- signs which generally need to be converted into floating point data types before being used with XY based utilities.
Data TypeText
Max Chars11
Key 
Permanent 
SubType 
Allowed ValuesAREALM.INTPTLAT
Sample Values+42.1579117, +42.1630393, +42.1637218
Distinct Values38
Nulls0
Percent Complete100
FormatsS1N2S1N7
Max Length11
Min Value+42.2406260
Max Value+42.6644839

FieldValue
No.10
Short NameINTPTLON
Full NameCurrent longitude of the internal point
DefinitionX centroid value which can be used to generate or display point features representing polygon areas. The Census represents these as text fields containing +/- signs which generally need to be changed into floating point data types before being usedwith XY based utilities.
Data TypeText
Max Chars12
Key 
Permanent 
SubType 
Allowed ValuesAREALM.INTPTLON
Sample Values-71.0247100, -71.0257343, -71.0259553
Distinct Values38
Nulls0
Percent Complete100
FormatsS1N2S1N7
Max Length11
Min Value-71.0352204
Max Value-71.6533099


www.scribekey.com