Touchstone 4.0 Database Documentation
CENSUSCITYSTREETNODE Table
Description
Stores information regarding the city street node.
Properties
Creation Date12/8/2010 2:41 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows226271916
Data Space Used11,957,520.00 KB
Index Space Used6,848,024.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key airstreetidCode that represents the AIR identifier for the street node.Integer4   
Primary Key citystreetsegidCode that represents the identifier for the city street segment.Numeric9 (17,2)   
Primary Key sequenceidOrder in which the street segment occurs within the street node.Integer4   
 latitudeLatitude coordinate for the street node.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 longitudeLatitude coordinate for the street node.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 cumulativepercent

Percent of the entire street node that is comprised of this street segment.

Numeric9 (6,2)  
Objects that CENSUSCITYSTREETNODE 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.