Touchstone 4.0 Database Documentation
TblAreaCatmap Table
Description
Contains valid internal area information.
Properties
Creation Date10/6/2008 3:58 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows22011
Data Space Used1,856.00 KB
Index Space Used5,752.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key intAreaCatmapCATRADER record identifier.Integer4   
 guidInternalGUID of the record, reserved for internal use only. Binary16  
 tuidSchemePathIdentifier for the area scheme path code.SmallInt2  
 intLevelId

Geographic level identifiers.

For a complete list of level types, see TblAreaExternal Table

SmallInt2  
 intYearYear of the data.SmallInt2   
 intSchemeArea scheme path codes, which describe a country’s geography. For instance, locations in the United States can be described using a POSTAL scheme (ZIP Code) or a CENSUS scheme (county, census tract).SmallInt2   
 intLevel0Internal mapping code used for CLFs.SmallInt2  
 intLevel1Country identifier.SmallInt2  
 intLevel2Area or CRESTA identifier.SmallInt2  
 intLevel3Subarea identifier.SmallInt2  
 intLevel4Internal mapping code used for CLFs.SmallInt2  
 intAltCode1Internal mapping code used for CLFs.SmallInt2  
 intAltCode2Internal mapping code used for CLFs.SmallInt2  
 intAltCode3Internal mapping code used for CLFs.SmallInt2  
 intAltCode4Internal mapping code used for CLFs.SmallInt2  
 strAltCode1Internal mapping code used for CLFs.VarChar10  
 strAltCode2Internal mapping code used for CLFs.VarChar10  
 strNameName of the area.VarChar60  
 strBriefNameBrief name of the area.VarChar10  
 intSortOrderSort order, for internal use only.SmallInt2  
 intSubLevelSchemeCountNumber of supported sub-level schemes.SmallInt2  
 binSubLevelInfoSub-level scheme structures.VarBinary40  
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.