tRemodeledGeographyXref Table

Description

System reference table used to map geographic SIDs.

Properties

Creation Date	3/27/2013 9:37 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	628582
Data Space Used	10,568.00 KB
Index Space Used	40.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	UserGeographySID	Unique system-generated sequential identifier for the user-provided geography record.	int	4
	RemappedGeographySID	Unique system-generated sequential identifier for the remapped geography record.	int	4

Objects that tRemodeledGeographyXref depends on

	Database Object	Object Type	Description	Dep Level
	tGeography	Table	Stores the post-validation geographical area information that the application displays on the user interface. After you import exposure data, the application writes the data to TblAreaExternal Table and validates the data using the airsp_ValidateArea stored procedure. Then, the application updates the records in tGeography to match the content of TblAreaExternal.	1

Database Object

Object Type

Description

Dep Level

tGeography

Table

Stores the post-validation geographical area information that the application displays on the user interface.

After you import exposure data, the application writes the data to TblAreaExternal Table and validates the data using the airsp_ValidateArea stored procedure. Then, the application updates the records in tGeography to match the content of TblAreaExternal.

Related Objects

AIRGeography Database

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.