Touchstone 4.0 Database Documentation
ZIP5 Table
Description
Stores 5-digit ZIP Code information.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows45449
Data Space Used1,928.00 KB
Index Space Used24.00 KB
Columns
 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  
 curr

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

  • N = No
  • Y = Yes
Char1  
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.