Touchstone 2022 Database Reference
tEnhancedGeoMatchLevel Table
AIRReference Database : tEnhancedGeoMatchLevel Table
Description

Stores the supported geocode match levels.

For more information about geocoding in Touchstone, refer Using Geocoding on AIR's Client Portal. The document describes how to use the EnhancedGeoMatchlevelCode and GeoMatchLevelCode to understand the quality of the geocoding results.

Properties
Creation Date12/14/2011 1:40 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows15
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EnhancedGeoMatchLevelCode

Code that represents the geocode match level.

  • BLCK = Block
  • CITY = City Centroid
  • COUN = Country
  • NONE = Not Found
  • POST = Postal Centroid
  • PRCL = Parcel
  • PT = Point
  • SEGI = Street Segment Imputed
  • STRC = Street Centroid
  • STRI = Street Imputed
  • SUB2 - Subarea 2 Centroid
  • SUBA = Subarea Centroid
  • USER = User-Supplied
varchar10   
 EnhancedGeoMatchLevel

Name of the match level.

Corresponds to the code in EnhancedGeoMatchLevelCode.

varchar40   
 DescriptionDescription of the match level.varchar1024  
 DisplayOrder

Order in which geocode match level results are displayed.

For example, a Parcel match is displayed first, followed by Block.

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.