Touchstone 2022 Database Reference
TblAreaScheme Table
AIRGeography Database : TblAreaScheme Table
Description
Stores internal area scheme definitions.
Properties
Creation Date9/8/2004 2:11 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows58
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Identifier for the area scheme.smallint2   
 

Type of area scheme.

  • 0 = None
  • 1 = FIPS, County
  • 2 = FIPS, State
  • 3 = FIPS, County
  • 4 = ZIP3, Zip3
  • 5 = ZIP5, Zip5
  • 6 = ZIP9, Zip9
  • 7 = AMBEST, State
  • 8 = ISO, State
  • 9 = Standard, Province
  • 10 = Standard, FSA
  • 11 = Standard, FSA-LDU
  • 12 = Standard, Prefecture
  • 13 = Standard, PrefectureKu
  • 14 = CRESTA, CRESTA
  • 100 = AIR, Region
  • 101 = AIR, Country
  • 102 = AIR, State
  • 103 = AIR, County
  • 104 = AIR, Zip3
  • 105 = AIR, StateCountyZip5
  • 106 = AIR, Zip5
  • 107 = AIR, StateCountyZip9
  • 109 = AIR, Prefecture
  • 110 = AIR, PrefectureKu
  • 111 = AIR, CRESTA
  • 112 = AIR, Province
  • 113 = AIR, FSA
  • 114 = AIR, FSA-LDU
  • 115 = AIR,CRESTA2
  • 116 = AIR, NUTS1
  • 117 = AIR, NUTS2
  • 118 = AIR, NUTS3
  • 119 = AIR, District
  • 120 = AIR, Parish
  • 121 = AIR, Municipality
  • 122 = AIR, Postal
  • 123 = AIR, Sector
  • 124 = AIR, District
  • 125 = AIR, Parish
  • 126 = AIR, Municipality
  • 127 = AIR, District Postal
  • 128 = AIR, Parish Postal
  • 129 = AIR, Municipality Postal
  • 130 = AIR, Region2
  • 131 = AIR, Region2 District
  • 132 = AIR,CountyPostal
  • 133 = AIR, Region2DistPostal
  • 134 = AIR, ProvincePostal
  • 135 = AIR, Region2Postal
  • 136 = AIR, Province District
  • 137 = AIR, CRESTA 3
  • 138 = AIR, ProvinceCounty
  • 139 = AIR, ProvinceCountyPostal
  • 140 = AIR, State District
varchar10  
 Name of the area scheme.varchar20   
 Description of the area scheme.varchar100  
See Also

Related Objects

AIRGeography Database