Touchstone 2022 Database Reference
tSoilType Table
AIRReference Database : tSoilType Table
Description
Stores the soil types.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows11
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SoilTypeCode

Code that represents the soil type.

  • 0 = Very Hard Rock
  • 1 = Hard Rock
  • 2 = Firm to Hard Rock
  • 3 = Firm Rock
  • 4 = Soft to Firm Rock (stiff soil)
  • 5 = Soft Rock
  • 6 = Stiff clay and Sandy soil (firm soil)
  • 7 = Soft Soil to Firm Soil
  • 8 = Soft Soil (shallow soil)
  • 9 = Soft Soil
  • 10 = Water
smallint2   
 SoilType

Name of the soil type.

Corresponds to the code in SoilTypeCode.

varchar40  
 Description

Description of the soil type.

varchar1024  
See Also

Related Objects

AIRReference 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.