Touchstone 2022 Database Reference
tSubareaCentroidToPostal Table
AIRGeography Database : tSubareaCentroidToPostal Table
Description
Stores the mapping between subareas and postal codes in the United States. Touchstone uses the mappings during reverse geocoding operations.
Properties
Creation Date10/7/2016 2:30 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3148
Data Space Used200.00 KB
Index Space Used32.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GuidExternal_SubareaGUID of the subarea  from TblAreaExternal.dbo.GUID16   
 GuidExternal_PostalGUID of the corresponding postal code from TblAreaExternal.dbo.GUID16  
 PostalCodeCorresponding postal code.dbo.AREACODE15  
 AreaNameName of the corresponding area.dbo.AREANAME60  
 PostalNameName of the corresponding postal code.dbo.AREANAME60  
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.