Touchstone Re 2022 Database Reference
tGeoRegion Table
AIRGeography Database : tGeoRegion Table
Description
Stores region information.
Properties
Creation Date5/10/2011 11:10 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the geographic region record.int4   
 

Region name.

  • 0 = Unknown
  • 1 = North America
  • 2 = Europe
  • 3 = Pacific Rim
  • 4 = South America
  • 5 = Central America
  • 6 = Africa
  • 7 = Asia
  • 8 = Oceania
  • 9 = World
varchar255  
 Region description, often an abbreviation. For example, CA for Central America. varchar4000  
 GUID of the boundary as supplied from tblAreaExternalbinary16  
 

Indicates whether the region is to be used in a geographic region filter.   

  • 1 = Yes (use in a filter)
  • 0 = No (do not use)
bit1  
Objects that depend on tGeoRegion
 Database ObjectObject TypeDescriptionDep Level
tGeoCountry tabletGeoCountryTableStores values that indicate the type of reverse geocoding that the application supports for each country.1
See Also

Related Objects

AIRGeography Database