Touchstone 4.0 Database Documentation
tSSDepth Table
Description

Stores the possible measurement ranges used to define the storm surge depth.

Properties
Creation Date10/30/2015 11:20 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows24
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SSDepthCode

Code that represents the frequency in which wind results in damage.

  • 0 = 0-1
  • 1 = 1-2 
  • 2 = 2-3
  • 3 = 3-4
  • 4 = 4-5 
  • 5 = 5-6
  • 6 = 6-7
  • 7 = 7-8
  • 8 = 8-9
  • 9 = 9-10   
  • 10 = 10-12 
  • 11 = 12-14 
  • 12 = 14-16
  • 13 = 16-18
  • 14 = 18-20
  • 15 = 20-25 
  • 16 = 25-30
  • 17 = 30-35
  • 18 = 35-40 
  • 19 = 40-45
  • 20 = 45-50
  • 21 = 50-55
  • 22 = >55 
  • 23 = No Data
SmallInt2   
 SSDepth

Storm surge depth range, in feet.

Corresponds to the code in SSDepthCode.

VarChar40  
 MinValue

Minimum value in the depth range.

Corresponds to the first number in the SSDepthCode range. 

Integer4  
 MaxValue

Maximum value in the depth range.

Corresponds to the second number in the SSDepthCode range. 

Integer4  
 Description

Description of the depth range.

VarChar1024  
See Also

Related Objects

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