TblSourceTargetMap

Description

Stores the grid identifier and weight type that corresponds to each source code. The table also stores 'look-up' area codes that the application uses for disaggregated locations in the United States and the weight for each location.

Properties

Creation Date	1/22/2015 7:10 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	1599139
Data Space Used	124,080.00 KB
Index Space Used	592.00 KB

Columns

Column Name	Description	Datatype	Length
guidExternalSource	GUID of the external source.	dbo.GUID	16
intGridID	Grid identifier.	bigint	8
intLevel1	Country code for the location. For a complete list of codes, see tCountry Table.	smallint	2
strLevel2	Area or CRESTA code for the location. For a complete list of codes, see tGeography Table.	varchar	16
strLevel3	Subarea code for the location. For a complete list of codes, see tGeography Table.	varchar	16
strLevel4	Postal code for the location. For a complete list of codes, see tGeography Table.	varchar	16
fltGeoLat	Latitude coordinate for the grid. Values will be positive for locations north of the equator and negative south of the equator.	real	4
fltGeoLong	Longitude coordinate for the grid. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.	real	4
intWeightTypeId	Identifier for the weight type. For a complete list of weight types, see TblAreaWeightType Table.	int	4
fltWeight	Grid weight.	decimal	9 (10,9)
GridGeographySID	Unique system-generated sequential identifier for the geography grid record. Used internally by Touchstone.	int	4

Objects that TblSourceTargetMap_US depends on

	Database Object	Object Type	Description	Dep Level
	TblAreaExternal	Table	Stores valid area information.	1
	TblAreaWeightType	Table	Stores a list of supported area weight types.	1

Related Objects

AIRGeography Database