Touchstone 4.0 Database Documentation
xtLandmark Table
Description

Stores geographic information used to define the exact location of landmarks for display on a map.  For example, the mapping program refers to the area details stored within this table to place Boston Logan Airport at the appropriate location on a map.

Properties
Creation Date8/10/2012 12:08 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows64645
Data Space Used7,264.00 KB
Index Space Used2,272.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LandmarkSID

Unique system-generated sequential identifier for the landmark record.

Integer4   
 Landmark

Name of the landmark. Note this value is not in human-readable format.

VarChar340   
 LandmarkTypeCode

Code that represents the type of landmark. 

For a complete list of codes, see tLandmarkType Table

VarChar10   
 GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4  
 MSA

Code that represent the Metropolitan Statistical Area where the landmark resides.

VarChar8  
 AreaCodeArea code where the landmark resides.  Note this value is not in human-readable format.VarChar20   
 SubAreaCodeSubarea code where the landmark resides.  Note this value is not in human-readable format.VarChar20   
 PostalCodePostal code where the landmark resides.  Note this value is not in human-readable format.VarChar20   
 LatitudeLatitude coordinate where the landmark resides.  Note this value is not in human-readable format.VarChar12   
 LongitudeLongitude coordinate where the landmark resides.  Note this value is not in human-readable format.VarChar12   
See Also

Related Objects

AIRReference 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.