Touchstone 4.0 Database Documentation
CENSUSCITYSTREETSEG Table
Description
Stores information regarding the city street segment.
Properties
Creation Date12/8/2010 2:42 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows57704252
Data Space Used2,308,272.00 KB
Index Space Used19,160.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key airstreetidCode that represents the AIR identifier for the street segment.Integer4   
Primary Key citystreetsegidCode that represents the  identifier for the city street segment.Numeric9 (17,2)   
Primary Key streetnumstartNumber at the start of the street.Integer4   
 streetnumendNumber at the end of the street.Integer4  
 side

Side of the street where the numbering occurs.

  • R = Right
  • L = Left
Char1  
Primary Key streetnumstart_nonnumericNon-numeric numbering at the start of the street, when applicable.VarChar15   
 streetnumend_nonnumericNon-numeric numbering at the end of the street, when applicable.VarChar15  
Objects that CENSUSCITYSTREETSEG 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.