Touchstone 4.0 Database Documentation
CITYSTREETZIP5 Table
Description
Stores information regarding the 5-digit ZIP codes associated with a street.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows7480579
Data Space Used148,456.00 KB
Index Space Used199,840.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ZIP55-digit ZIP coded associated with the street.Char5   
Primary Key AIRSTREETIDCode that represents the AIR identifier for the street.Integer4   
Objects that CITYSTREETZIP5 depends on
 Database ObjectObject TypeDescriptionDep Level
CITIES tableCITIESTableStores city information.2
CityStreetsWithoutAliases tableCityStreetsWithoutAliasesTableStores information regarding the streets within a city.1
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.