Touchstone 4.0 Database Documentation
tEffectiveDistanceToCoast Table
Description

Stores the possible options to measure the distance between the exposure and the closest water body, which includes oceans, very large lakes, and very large rivers. Used during the Hazard analysis.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows16
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EffectiveDistanceToCoastCode

Code that represents the distance from the closest body of water.

  • 0 = 0  - 500 feet
  • 1 = 500  - 1000 feet
  • 2 = 1000  - 1500 feet
  • 3 = 1500  - 2000 feet
  • 4 = 2000  - 2500 feet
  • 5 = 2500 feet - 1 miles
  • 6 = 1  - 2 miles
  • 7 = 2  - 3 miles
  • 8 = 3  - 4 miles
  • 9 = 4  - 5 miles
  • 10 = 5 - 10 miles
  • 11 = 10 - 15 miles
  • 12 = 15 - 20 miles
  • 13 = 20 - 25 miles
  • 14 = 25 - 50 miles
  • 15 = > 50 miles
SmallInt2   
 EffectiveDistanceToCoast

Distance values.

Corresponds to the code in EffectiveDistanceToCoastCode.

VarChar40  
 MinValue

Minimum value in the distance range.

Corresponds to the first number in the EffectiveDistanceToCoastCode range. 

Integer4  
 MaxValue

Maximum value in the distance range.

Corresponds to the second number in the EffectiveDistanceToCoastCode range. 

Integer4  
 DescriptionDescription of the distance to coast 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.