Touchstone 2022 Database Reference
TblCountryMappingAreacode Table
AIRGeography Database : TblCountryMappingAreacode Table
Description
Stores valid scheme paths for each country and area code record. 
Properties
Creation Date4/9/2020 2:21 PM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows2873
Data Space Used160.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key intArealevel1

Area level1 identifier.

For example: country identifier.  

smallint2   
Primary Key intArealevel2

Area level 2 identifier.

For example: area or cresta identifier.

smallint2   
Primary Key intArealevel3

Area level 3 identifier.

For example: subarea identifier.

smallint2   
Primary Key intCityCity identifier.smallint2   
Primary Key intAreaSchemeArea 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   
 strCityName of the street and city.nvarchar16  
See Also

Related Objects

AIRGeography Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.