Touchstone Re 2022 Database Reference
tGeoMatchLevel Table
AIRReference Database : tGeoMatchLevel Table
Description

Stores codes that represent the levels at which a geocode match can occur.

To best interpret the GeoMatchLevelCode in regards to the geocoding results, refer to the document Using Geocoding in Touchstone, which is available on AIR's Client Portal. This document provides details on how to use the GeoMatchLevelCode, together with the EnhancedGeoMatchlevelCode, to understand the quality of the geocoding results.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GeoMatchLevelCode

Code that represents the level at which a geocode match may occur.

  • ADDR =  Exact Address
  • AREA = Area Centroid
  • CITY = City Centroid
  • CNTY = County Centroid
  • COUN = Country
  • CRES  =CRESTA Centroid
  • DISAG = Disaggregated
  • NONE = None
  • POINT = Point
  • POST = Postal Code Centroid
  • RLXA = Relaxed Address
  • SUB2 = Subarea 2
  • USER = User Supplied
  • ZIP9 = ZIP9 Centroid
varchar10   
 GeoMatchLevel

Name of the geocode match level.

Corresponds to the code in GeoMatchLevelCode.

varchar40   
 Description

Description of the geocode match level.

varchar1024  
 DisplayOrder

Order in which geocode match level results are displayed on the user interface.

For example, a ZIP9 Centroid match is displayed first, followed by Relaxed Address.

tinyint1   
See Also

Related Objects

AIRReference 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.