Touchstone 4.0 Database Documentation
STATES Table
Description
Stores state (area) information.
Properties
Creation Date12/14/2006 4:57 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows60
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key STATECDCode that represents the state (area) code.Char2   
 REGIONNMRegion where the state (area) resides.VarChar20  
 STATEFIPSCDCode that represents the state FIPS.Char2  
 STATENMName of the state.VarChar15  
 ISNEWENGLAND

Identifies whether the state is in New England:

  • Yes = Yes (state resides in New England)
  • No = No (state is not in New England)
Char1  
Objects that depend on STATES
 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
STATECOUNTIES tableSTATECOUNTIESTableStores county (subarea) information.3
STATEREGIONS tableSTATEREGIONSTableStores information regarding the geographic regions in which the states (areas) reside.1
USPSCITYSTREETSEG tableUSPSCITYSTREETSEGTableStores information regarding the city streets as used by the United States Postal Service.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.