Stores prominent landmarks, which are used only by CATStation.
Touchstone 2022 Database Reference
TblProminentLandmarks Table
| Creation Date | 3/14/2006 2:06 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 107 |
| Data Space Used | 16.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | intLandmarkID | AIR-internal identifier for the landmark. | int | 4 | |||
| strName | Name of the landmark. | varchar | 64 |  | |||
| strAddress | Street address of the landmark. | varchar | 64 | | |||
| intZipcode | Five-digit postal code for the landmark's street address. | int | 4 | | |||
| strState | Two-digit area (state) code for the landmark's street address. | char | 2 | | |||
| strLabel | High-level classification for the landmark. | varchar | 64 | | |||
| strCounty | Subarea (county) name where the landmark resides. | varchar | 32 | | |||
| strSubclass | Low-level classification for the landmark. | varchar | 64 | | |||
| fltGeoLat | Latitude coordinate for the landmark. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | | |||
| fltGeoLong | Longitude 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 meridian | real | 4 | |