Touchstone 4.0 Database Documentation
CityStreetsWithoutAliases Table
Stores information regarding the streets within a city.
Creation Date1/27/2010 2:28 PM
Text File Group
System Object
Published for Replication
Data Space Used571,216.00 KB
Index Space Used978,872.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AIRSTREETIDCode that represents the AIR identifier for the street.Integer4   
 STATECDCode that represents the state (area) where the city resides.Char2   
 AIRCOUNTYIDCode that represents the  county (subarea) where the city resides.Integer4   
 CITYName of the city where the street resides.VarChar40   
 STREETPREFIXPrefix as part of the street name (i.e. N for North)VarChar15   
 STREETNMName of the street.VarWChar200   
 STREETSUFFIXSuffix as part of the street name (i.e. SW for Southwest)VarChar15   

Code that represents the type of street.  Values include:

  • AVE = Avenue
  • BLVD = Boulevard
  • CT = Court
  • CIR = Circle
  • DR = Drive
  • HWY = Highway
  • LN = Lane
  • LOOP = Loop
  • PL = Place
  • RD = Road
  • ST = Street
  • TRL = Trail
  • WAY = Way
 CENTROIDLATITUDELatitude for the street centroid. Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (10,6)  
 CENTROIDLONGITUDELongitude for the street 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 (10,6)  
Objects that depend on CityStreetsWithoutAliases
 Database ObjectObject TypeDescriptionDep Level
CENSUSCITYSTREETNODE tableCENSUSCITYSTREETNODETableStores information regarding the city street node.4
CENSUSCITYSTREETSEG tableCENSUSCITYSTREETSEGTableStores information regarding the city street segment.4
CityStreets tableCityStreetsTableStores information regarding the streets within a city.3
CITYSTREETZIP5 tableCITYSTREETZIP5TableStores information regarding the 5-digit ZIP codes associated with a street.4
USPSCITYSTREETSEG tableUSPSCITYSTREETSEGTableStores information regarding the city streets as used by the United States Postal Service.4
Objects that CityStreetsWithoutAliases depends on
 Database ObjectObject TypeDescriptionDep Level
CITIES tableCITIESTableStores city information.2
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.