Touchstone 2022 Database Reference
tGeoCountry Table
AIRGeography Database : tGeoCountry Table
Description
Stores values that indicate the type of reverse geocoding that the application supports for each country.
Properties
Creation Date1/4/2018 1:18 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows283
Data Space Used24.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

Code for the country.

For a complete list of codes, see tCountry Table.

dbo.AREACODE15   
 CountryNameName of the country.dbo.AREANAME60   
 GeoRegionSid

Unique system-generated sequential identifier for the region that includes the country.

For a complete list of codes, see tGeoRegion Table.

int4   
 intLevel1Code for the country.int4   
 CountryGeographySID

Unique system-generated sequential identifier for the country.

For a complete list of codes, see tGeography Table.

int4   
 IsReverseGeocodeViaAddressService

Indicates whether the application supports reverse geocoding for the country.

  • 1 = Yes (supported)
  • 0 = No (not supported)

Reverse geocoding is the process that the application uses to determine additional geographic data from a user-specified latitude and longitude pair.

bit1   
 ReverseGeocodingType

Code that represents the type of reverse geocoding supported for the country.

For a complete list of codes, see tReverseGeocodingType Table.

tinyint1  
 ReverseGeocodingTolerance

Reserved for future use.

int4  
 CrestaCodeOffshoreFor internal use only.dbo.AREACODE15  
 CrestaCodeOffshoreExportCRESTA code for offshore locations.dbo.AREACODE15  
 IsPremiumGeocodingEligible

Indicates whether PremiumGeocoding is allowed for the country record.

  • Yes = 1 (premium geocoding is allowed)
  • No = 0 (premium geocoding is not allowed)
bit1 
('0')
 
 ReverseGeocodeLevel

Represents the reverse geographic levels for each country.

Inherits the reverse geocode level codes from tGeoLevel table.

varchar10  
Objects that tGeoCountry depends on
 Database ObjectObject TypeDescriptionDep Level
tGeoRegion tabletGeoRegionTableStores region information.1
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.