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.
| Creation Date | 8/10/2012 12:08 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 64645 |
| Data Space Used | 7,264.00 KB |
| Index Space Used | 2,272.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LandmarkSID | Unique system-generated sequential identifier for the landmark record. | int | 4 | |||
| Landmark | Name of the landmark. Note this value is not in human-readable format. | varchar | 340 | ||||
| LandmarkTypeCode | Code that represents the type of landmark. For a complete list of codes, see tLandmarkType Table | varchar | 10 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record. For a complete list of records, see tGeography Table. | int | 4 |  | |||
| MSA | Code that represent the Metropolitan Statistical Area where the landmark resides. | varchar | 8 | | |||
| AreaCode | Area code where the landmark resides. Note this value is not in human-readable format. | varchar | 20 | ||||
| SubAreaCode | Subarea code where the landmark resides. Note this value is not in human-readable format. | varchar | 20 | ||||
| PostalCode | Postal code where the landmark resides. Note this value is not in human-readable format. | varchar | 20 | ||||
| Latitude | Latitude coordinate where the landmark resides. Note this value is not in human-readable format. | varchar | 12 | ||||
| Longitude | Longitude coordinate where the landmark resides. Note this value is not in human-readable format. | varchar | 12 |