Touchstone 2022 Database Reference
tEffectiveDistanceToCoast Table
AIRReference Database : 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 

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   
 

Distance values.

Corresponds to the code in EffectiveDistanceToCoastCode.

varchar40  
 

Minimum value in the distance range.

Corresponds to the first number in the EffectiveDistanceToCoastCode range. 

int4  
 

Maximum value in the distance range.

Corresponds to the second number in the EffectiveDistanceToCoastCode range. 

int4  
 Description of the distance to coast range.varchar1024  
See Also

Related Objects

AIRReference Database