Touchstone 4.0 Database Documentation
TblProminentLandmarks Table
Description
Defines the prominent landmark. This table is used only by CATStation.
Properties
Creation Date3/14/2006 2:06 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows107
Data Space Used24.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key intLandmarkIDAIR-internal identifier for the landmark.Integer4   
 strNameName of the landmark.VarChar64  
 strAddressStreet address of the landmark.VarChar64  
 intZipcodeFive-digit postal code for the landmark's street address.Integer4  
 strStateTwo-digit area (state) code for the landmark's street address.Char2  
 strLabelHigh-level classification for the landmark.VarChar64  
 strCountySubarea (county) name where the landmark resides.VarChar32  
 strSubclassLow-level classification for the landmark.VarChar64  
 fltGeoLatLatitude coordinate for the landmark. Values will be positive for locations north of the equator and negative south of the equator.Single4  
 fltGeoLongLongitude coordinate for the landmark. 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 meridianSingle4  
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.