Touchstone 4.0 Database Documentation
TblAreaCity Table
Description
Stores city information.
Properties
Creation Date5/4/2009 3:06 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows315186
Data Space Used32,928.00 KB
Index Space Used27,848.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidExternalGUID of the boundary as supplied from tblAreaExternalBinary16   
 intLevel1Country identifier.SmallInt2  
 strLevel2Area or CRESTA identifier.VarChar15  
 strLevel3Subarea identifier.VarChar15  
 strLevel4Postal code identifier.VarChar15  
Primary Key strCityNameName of the city.VarChar60   
 fltGeoLatLatitude coordinate for the city.  Values will be positive for locations north of the equator and negative south of the equator.Single4   
 fltGeoLongLongitude 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.Single4   
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.