Touchstone 4.0 Database Documentation
tGeoLabel Table
Contains country-level geography label information.   
Creation Date5/10/2011 11:10 AM
Text File Group
System Object
Published for Replication
Data Space Used16.00 KB
Index Space Used16.00 KB
 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.

 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.