Touchstone 4.0 Database Documentation
ZIP9 Table
Description
Stores 9-digit ZIP Code information.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows23505794
Data Space Used897,328.00 KB
Index Space Used3,328.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ZIP55-digit ZIP Code.Char5   
Primary Key ZIPPLUS4Four-digit code that follows the 5-digit ZIP Code.  Together, these make the 9-digit ZIP Code.Char4   
 CENTROIDLATITUDELatitude for the 9-digit ZIP Code. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (10,6)   
 CENTROIDLONGITUDELongitude for the 9-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 (10,6)   
Objects that ZIP9 depends on
 Database ObjectObject TypeDescriptionDep Level
ZIP5 tableZIP5TableStores 5-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.