Stores city information.
Touchstone 2022 Database Reference
TblAreaCity Table
| Creation Date | 5/4/2009 3:06 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 386563 |
| Data Space Used | 24,608.00 KB |
| Index Space Used | 37,320.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidExternal | GUID of the boundary as supplied from tblAreaExternal. | dbo.GUID | 16 | |||
| intLevel1 | Country identifier. | smallint | 2 |  | |||
| strLevel2 | Area or CRESTA identifier. | varchar | 15 | | |||
| strLevel3 | Subarea identifier. | varchar | 15 | | |||
| strLevel4 | Postal code identifier. | varchar | 15 | | |||
| | strCityName | Name of the city. | varchar | 60 | |||
| fltGeoLat | Latitude coordinate for the city. Values will be positive for locations north of the equator and negative south of the equator. | real | 4 | ||||
| fltGeoLong | Longitude coordinate for the city. 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 |