Touchstone 4.0 Database Documentation
CITYALIAS Table
Description
Stores city alias information.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows37220
Data Space Used2,104.00 KB
Index Space Used2,880.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key STATECDCode that represents the state (area) where the city resides.Char2   
Primary Key AIRCOUNTYIDCode that represents the county (subarea) where the city resides.Integer4   
Primary Key CITYName of the city.VarChar40   
Primary Key CITYALIASAlias for the city name.VarChar40   
 CENTROIDLATITUDELatitude for the city centroid. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 CENTROIDLONGITUDELongitude for the city centroid.  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.Numeric9 (9,6)  
Objects that CITYALIAS depends on
 Database ObjectObject TypeDescriptionDep Level
CITIES tableCITIESTableStores city information.2
STATECOUNTIES tableSTATECOUNTIESTableStores county (subarea) information.3
STATES tableSTATESTableStores state (area) information.4
See Also

Related Objects

AIRAddressServer 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.