Touchstone 4.0 Database Documentation
tGeoLabel Table
Description
Contains country-level geography label information.   
Properties
Creation Date5/10/2011 11:10 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows247
Data Space Used16.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar30   
 CrestaLabelLabel for the CRESTA within the country.VarChar255  
 AreaLabelLabel for the area within the country, such as "State" or "District"..VarChar255  
 SubAreaLabelLabel for the subarea within the country, such as "County" or "Municipality".VarChar255  
 PostalLabelLabel for the postal code within the country, such as "ZIP5" or "4-digit postal code".VarChar255  
 SubArea2LabelLabel for the level that is  at a finer resolution than postal, such as "6-digit Area Unit Code " or "Sonpo code".VarChar255  
See Also

Related Objects

AIRGeography Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.