Touchstone 4.0 Database Documentation
AIRGeography Database
Description

The AIRGeography database stores geography-based information for use by the Touchstone application.

Schema Diagram

 To view the database schema diagrams for the AIRGeography database, see Schema Diagrams.

Tables
TableDescription
TblAreaBoundariesUsed to draw state and counties for Google Earth implementation. It is also used by airfn_GeoCodeInBoundaries to determine if a user-provided latitude and longitude is within the specified area.
TblAreaCatmapContains valid internal area information.
TblAreaCityStores city information.
TblAreaCountrySchemePathStores valid scheme paths for each country.
TblAreaDistribution_xref

System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted areas. This value is used to assign values to areas that do not have a high enough weight.

TblAreaExternalStored valid area information.
TblAreaModelStores the mapping between an area and its corresponding model for the current Touchstone version.
tblAreaMOdel_BeforeStores the mapping between an area and its corresponding model for previous versions of Touchstone.
TblAreaSchemeStores the internal scheme definitions.
TblAreaSchemePathStores the scheme path definition, including its chain.
TblAreaWeightTypeDefines the area weight type. Used by airsp_DistributeCrestaLocations.
TblCountryAliasStores the alias information for countries; used by AIR ImportExpress to resolve country names.
TblCountryGeoToleranceContains the tolerance value for each country, used by airsp_FindClosestArea. Reserved for future use.
TblGridPartitionRefStores the disaggregation partitions.
TblMarineCraftPostalMapStores information for relocating location from inland to the ocean when the construction class is Marine Craft. Used when the relocate marine craft flag is set.
TblMexicoHUEQ_XrefSystem reference table that stores information used to map Mexico's hurricane and earthquake CRESTA codes between Touchstone and CATRADER. Used for UNICEDE export.
TblOccAirWeightType_xrefSystem reference table used by airsp_DistributeCrestaLocations that defines the mapping between the occupancy code and weight type.
TblProminentLandmarksDefines the prominent landmark. This table is used only by CATStation.
TblSourceDefaultTarget_XrefSystem reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions. This value is used to assign values to regions that do not have a high enough weight.
TblSourceDefaultTargetWc_Xref

System reference table used by airsp_EA_PagingPrepare to retrieve the highest weighted regions for Workers' Compensation. This value is used to assign values to regions that do not have a high enough weight.

TblSourceTargetMap_ANZMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Australia and New Zealand, as well as the weight for each of those locations.
TblSourceTargetMap_BRA

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Brazil, as well as the weight for each of those locations.

TblSourceTargetMap_CAM

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Central America, as well as the weight for each of those locations.

TblSourceTargetMap_CANMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Canada, as well as the weight for each of those locations.
TblSourceTargetMap_CHIMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in China, as well as the weight for each of those locations.
TblSourceTargetMap_EURMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Europe, as well as the weight for each of those locations.
TblSourceTargetMap_INDMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in India, as well as the weight for each of those locations.
TblSourceTargetMap_JAPMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations.
TblSourceTargetMap_MEUMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated mid-European locations, as well as the weight for each of those locations.
TblSourceTargetMap_MEXMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Mexico, as well as the weight for each of those locations.
TblSourceTargetMap_SAMMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in South America, as well as the weight for each of those locations.
TblSourceTargetMap_SEAMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Southeast Asia, as well as the weight for each of those locations.
TblSourceTargetMap_SEUMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated southern-European locations, as well as the weight for each of those locations.
TblSourceTargetMap_USMaps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in the United States, as well as the weight for each of those locations.
TblSourceTargetMapWC_JAPUsed for Workers' Compensation. Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Japan, as well as the weight for each of those locations. 
tCentroidCheckRequiredStores geo-level centroids in Japan for use during disaggregation.
tConvertCL2Country

Stores information regarding the county names used in CLASIC/2. This information is used to convert CLASIC/2 country names to Touchstone country names.

tCountryGeoRegionXref

System reference table used to map countries to geographic regions.  

tDBVersionDefines the version of the database.
tDisaggregatedGeoLevelStores the geographic resolution to which Touchstone disaggregates for each country.
tEncoderMetaDataReserved for future use.
tGeography

Stores the post-validation geographical area information used for display on the user interface. Imported exposure data is written to tblAreaExternal, which is validated using stored procedure airsp_ValidateArea. After validation, records in tGeography are updated to match the content of tblAreaExternal.

tGeography_Upgradelist

Stores the geography SIDS that have changed between versions.

tGeoLabelContains country-level geography label information.   
tGeoRegionStores region information.
tRemodeledGeographyXrefSystem reference table used to map geographic SIDs.
tSIDControl

Contains a list of all SID tables and the last SID value in use for each table.  After each insert operation, the SID value will update.

tUpxAreaSchemeMappingStores the mapping between UPX area scheme and level types.  
tUSCityStores city information for the United States.

 

 


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.