TblAreaCatmap Table

Description

Stores valid internal area information.

Properties

Creation Date	10/6/2008 3:58 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	22068
Data Space Used	2,160.00 KB
Index Space Used	4,016.00 KB

Columns

Column Name	Description	Datatype	Length
intAreaCatmap	CATRADER record identifier.	int	4
guidInternal	GUID of the record, reserved for internal use only.	dbo.GUID	16
tuidSchemePath	Identifier for the area scheme path code.	smallint	2
intLevelId	Geographic level identifiers. For a complete list of level types, see TblAreaExternal Table.	smallint	2
intYear	Year of the data.	smallint	2
intScheme	Area scheme path codes, which describe a country’s geography. For instance, locations in the United States can be described using a POSTAL scheme (ZIP Code) or a CENSUS scheme (county, census tract).	smallint	2
intLevel0	Internal mapping code used for CLFs.	smallint	2
intLevel1	Country identifier.	smallint	2
intLevel2	Area or CRESTA identifier.	smallint	2
intLevel3	Subarea identifier.	smallint	2
intLevel4	Internal mapping code used for CLFs.	smallint	2
intAltCode1	Internal mapping code used for CLFs.	smallint	2
intAltCode2	Internal mapping code used for CLFs.	smallint	2
intAltCode3	Internal mapping code used for CLFs.	smallint	2
intAltCode4	Internal mapping code used for CLFs.	smallint	2
strAltCode1	Internal mapping code used for CLFs.	varchar	10
strAltCode2	Internal mapping code used for CLFs.	varchar	10
strName	Name of the area.	varchar	60
strBriefName	Brief name of the area.	varchar	10
intSortOrder	Sort order, for internal use only.	smallint	2
intSubLevelSchemeCount	Number of supported sub-level schemes.	smallint	2
binSubLevelInfo	Sub-level scheme structures.	varbinary	40

Related Objects

AIRGeography Database

Verisk Analytics Client Confidential

Please contact Verisk Analytics with questions or comments.