Touchstone 4.0 Database Documentation
ZIP5 Table
Stores 5-digit ZIP Code information.
Creation Date12/14/2006 4:57 PM
Text File Group
System Object
Published for Replication
Data Space Used1,928.00 KB
Index Space Used24.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ZIP55-digit ZIP Code.Char5   
 currentzipboundaryIdentifies the ZIP Code boundary currently associated with the 5-digit ZIP Code.Char5  
 CENTROIDLATITUDELatitude for the 5-digit ZIP Code. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 CENTROIDLONGITUDELongitude for the 5-digit ZIP Code. 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)  
 PREFCITYWhen more than one city name (i.e. an alias) is associated with the 5-digit ZIP Code, this field identifies the preferred city name.VarChar28  

Indicates whether the 5-digit ZIP Code is in use.

  • N = No
  • Y = Yes
Objects that depend on ZIP5
 Database ObjectObject TypeDescriptionDep Level
ZIP9 tableZIP9TableStores 9-digit ZIP Code information.1
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.