Touchstone 4.0 Database Documentation
USPSCITYSTREETSEG Table
Description
Stores information regarding the city streets as used by the United States Postal Service.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows47159234
Data Space Used2,108,872.00 KB
Index Space Used1,502,376.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 AIRSTREETIDCode that represents the AIR identifier for the street.Integer4   
 STREETSEQNUMSTARTStarting value in the sequence of street numbers.Integer4   
 STREETSEQNUMENDEnding value in the sequence of street numbers.Integer4   
 ZIP95-digit ZIP Code.VarChar9  
 ISODD

Indicates whether the street number is odd.

  • 1 - Yes (odd)
  • 0 = No (even)
There can be multiple rows for each AIRSTREETID, one indicating odd and another even.
Char1  
Objects that USPSCITYSTREETSEG 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.