Touchstone 2022 Database Reference
tUSCity Table
AIRGeography Database : tUSCity Table
Description
Stores city information for the United States.
Properties
Creation Date2/6/2014 3:05 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows41169
Data Space Used2,568.00 KB
Index Space Used1,624.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

int4   
 GuidExternalGUID of the boundary as supplied from tblAreaExternal. dbo.GUID16   
 OldCountryCode

 CLASIC/2 identifier for the country.

smallint2   
 CountryCode

ISO 2-character code for the country. 

For a complete list of codes, see tCountry Table.

varchar15   
 AreaCode

Area code for the city.

For a complete list of codes, see tGeography Table.

varchar15   
 SubareaCode

Subarea code for the city.

For a complete list of codes, see tGeography Table.

varchar15   
 PostalCode

Postal code for the city.

For a complete list of codes, see tGeography Table.

varchar15   
Primary Key CityNameName of the city.varchar60   
See Also

Related Objects

AIRGeography Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.