Touchstone 4.0 Database Documentation
STATECOUNTIES Table
Description
Stores county (subarea) information.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3317
Data Space Used136.00 KB
Index Space Used96.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key STATECDCode that represents the state (area) where the county resides.Char2   
Primary Key AIRCOUNTYIDCode that represents the county (subarea) where the city resides.Integer4   
 COUNTYNMName of the county.VarChar40  
 CENTROIDLATITUDELatitude for the county centroid. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)  
 CENTROIDLONGITUDELongitude for the county centroid. 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 (9,6)  
Objects that depend on STATECOUNTIES
 Database ObjectObject TypeDescriptionDep Level
CENSUSCITYSTREETNODE tableCENSUSCITYSTREETNODETableStores information regarding the city street node.4
CENSUSCITYSTREETSEG tableCENSUSCITYSTREETSEGTableStores information regarding the city street segment.4
CITIES tableCITIESTableStores city information.2
CITYALIAS tableCITYALIASTableStores city alias information.3
CityStreets tableCityStreetsTableStores information regarding the streets within a city.3
CityStreetsWithoutAliases tableCityStreetsWithoutAliasesTableStores information regarding the streets within a city.1
CITYSTREETZIP5 tableCITYSTREETZIP5TableStores information regarding the 5-digit ZIP codes associated with a street.4
CITYZIP5 tableCITYZIP5TableStores information regarding the 5-digit ZIP Codes associated with a city.3
USPSCITYSTREETSEG tableUSPSCITYSTREETSEGTableStores information regarding the city streets as used by the United States Postal Service.4
Objects that STATECOUNTIES depends on
 Database ObjectObject TypeDescriptionDep Level
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.