Touchstone 4.0 Database Documentation
TblProminentLandmarks Table
Defines the prominent landmark. This table is used only by CATStation.
Creation Date3/14/2006 2:06 PM
Text File Group
System Object
Published for Replication
Data Space Used24.00 KB
Index Space Used16.00 KB
 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.