The Wayback Machine - https://web.archive.org/web/20140627221932/http://www.scribekey.com/EntityAttributes/AREALM.singles.html
TIGER/Line Data Dictionary ReadMe

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

Field Value
No. 1
Short Name STATEFP
Full Name Current state FIPS code
Definition Current state Federal Information Processing Standards (FIPS) code. The census provides specific layers for these areas through Nation and State based Shapefiles.
Data Type Text
Max Chars 2
Key Foreign, Census
Permanent  
SubType  
Allowed Values  
Sample Values 25
Distinct Values 1
Nulls 0
Percent Complete 100
Formats N2
Max Length 2
Min Value 25
Max Value 25

Field Value
No. 2
Short Name COUNTYFP
Full Name Current county FIPS code
Definition Current 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 Type Text
Max Chars 3
Key Foreign, Census
Permanent  
SubType  
Allowed Values  
Sample Values 017
Distinct Values 1
Nulls 0
Percent Complete 100
Formats N3
Max Length 3
Min Value 017
Max Value 017

Field Value
No. 3
Short Name ANSICODE
Full Name GNIS Identifier
Definition Current official Geographic Names Information System (GNIS) code for the landmark for use by federal agencies for data transfer and dissemination, if applicable.
Data Type Text
Max Chars 8
Key Foreign, GNIS
Permanent Y
SubType  
Allowed Values  
Sample Values null
Distinct Values 1
Nulls 38
Percent Complete 0
Formats  
Max Length 1
Min Value  
Max Value  

Field Value
No. 4
Short Name AREAID
Full Name Area landmark identifier
Definition Area landmark identifier.
Data Type Text
Max Chars 22
Key Primary
Permanent  
SubType  
Allowed Values  
Sample Values 110340945888, 110340946108, 110340946147
Distinct Values 38
Nulls 0
Percent Complete 100
Formats N12
Max Length 12
Min Value 110340945888
Max Value 110340951158

Field Value
No. 5
Short Name FULLNAME
Full Name Full Name
Definition 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.
Data Type Text
Max Chars 100
Key  
Permanent  
SubType  
Allowed Values  
Sample Values null, Ashland State Park, Bell Rock Cmtry
Distinct Values 30
Nulls 8
Percent Complete 78.95
Formats U1L6S1U1L4S1U1L3
Max Length 22
Min Value  
Max Value Whittemore Park

Field Value
No. 6
Short Name MTFCC
Full Name MAF/TIGER feature class code
Definition 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).
Data Type Text
Max Chars 5
Key  
Permanent  
SubType  
Allowed Values AREALM.MTFCC
Sample Values C3023, K2180, K2184, K2361, K2451, K2457, K2582
Distinct Values 7
Nulls 0
Percent Complete 100
Formats U1N4
Max Length 5
Min Value C3023
Max Value K2582

Field Value
No. 7
Short Name ALAND
Full Name Current land area in square meters.
Definition  
Data Type Integer
Max Chars -1
Key  
Permanent  
SubType  
Allowed Values AREALM.ALAND
Sample Values 0, 2027, 3399, 3875, 5105, 5240, 5682, 6400, 6484
Distinct Values 38
Nulls 0
Percent Complete 100
Formats N1, N4, N5, N6, N7
Max Length 7
Min Value 0
Max Value 6018144

Field Value
No. 8
Short Name AWATER
Full Name Current water area in square meters
Definition  
Data Type Integer
Max Chars -1
Key  
Permanent  
SubType  
Allowed Values AREALM.AWATER
Sample Values 0, 3881, 4470, 5008, 5333, 5927, 13757, 20294
Distinct Values 9
Nulls 0
Percent Complete 100
Formats N1, N4, N5, N6
Max Length 6
Min Value 0
Max Value 690895

Field Value
No. 9
Short Name INTPTLAT
Full Name Current latitude of the internal point
Definition Y 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 Type Text
Max Chars 11
Key  
Permanent  
SubType  
Allowed Values AREALM.INTPTLAT
Sample Values +42.1579117, +42.1630393, +42.1637218
Distinct Values 38
Nulls 0
Percent Complete 100
Formats S1N2S1N7
Max Length 11
Min Value +42.2406260
Max Value +42.6644839

Field Value
No. 10
Short Name INTPTLON
Full Name Current longitude of the internal point
Definition X 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 Type Text
Max Chars 12
Key  
Permanent  
SubType  
Allowed Values AREALM.INTPTLON
Sample Values -71.0247100, -71.0257343, -71.0259553
Distinct Values 38
Nulls 0
Percent Complete 100
Formats S1N2S1N7
Max Length 11
Min Value -71.0352204
Max Value -71.6533099


www.scribekey.com