Stores information that the application uses to draw states and counties for the Google Earth implementation.
The application also uses the information in the airfn_GeoCodeInBoundaries function to determine whether a user-specified latitude and longitude pair is within the specified area.
| Creation Date | 6/3/2008 1:18 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 1049929 |
| Data Space Used | 50,912.00 KB |
| Index Space Used | 224.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidExternal | GUID of the boundary as supplied from tblAreaExternal. | dbo.GUID | 16 | |||
| | PolyGonId | The unique identifier for the polygon. | int | 4 | |||
| | NodeSequenceId | Sort order for this boundary shape. | int | 4 | |||
| fltGeoLat | Latitude coordinate for the start of the boundary shape. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | ||||
| fltGeoLong | Longitude coordinate for the start of the boundary shape. 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 | ||||
| fltGeoLatEnd | Latitude coordinate for the end of the boundary shape. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 |  | |||
| fltGeoLongEnd | Longitude coordinate for the end of the boundary shape. 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 | |