Touchstone 4.0 Database Documentation
TblSourceTargetMap_BRA Table
Description

Maps source codes to gridID and weightType. Also stores 'look-up' Area codes that are needed for disaggregated locations in Brazil, as well as the weight for each of those locations.

Properties
Creation Date12/8/2014 12:17 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows6805988
Data Space Used473,464.00 KB
Index Space Used2,208.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalSource

GUID of the external source.

Binary16   
Primary Key intGridIDGrid identifierBigInt8   
 intLevel1

Country code for the location.

For a complete list of codes, see tCountry Table.

UnsignedTinyInt1   
 strLevel2

Area or CRESTA code for the location.

For a complete list of codes, see tGeography Table.

VarChar16   
 strLevel3

Subarea code for the location.

For a complete list of codes, see tGeography Table.

VarChar16  
 strLevel4

Postal code for the location.

For a complete list of codes, see tGeography Table.

VarChar16  
 fltGeoLatLatitude coordinate for the grid. Values will be positive for locations north of the equator and negative south of the equator.Single4   
 fltGeoLongLongitude 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.Single4   
Primary Key intWeightTypeId

Identifier for the weight type. 

For a complete list of weight types, see TblAreaWeightType Table.

Integer4   
 fltWeightGrid weight.Numeric9 (10,9)   
 GridGeographySID

Unique system-generated sequential identifier for the geography grid record.

Used internally by Touchstone.

Integer4   
Objects that TblSourceTargetMap_BRA depends on
 Database ObjectObject TypeDescriptionDep Level
TblAreaExternal tableTblAreaExternalTableStored valid area information.1
TblAreaWeightType tableTblAreaWeightTypeTableDefines the area weight type. Used by airsp_DistributeCrestaLocations.1
See Also

Related Objects

AIRGeography Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.