Touchstone 4.0 Database Documentation
tBaseFloodElevation Table
Description

Stores the possible measurement ranges used to define the elevation, in feet above sea level, for the base flood options.  

Properties
Creation Date3/7/2014 10:59 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows34
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key BaseFloodElevationCode

Code that represents the elevation of the base flood.

  • 1 =  1 Foot
  • 2 = 1 - 2 Feet
  • 3 = 2 - 3 Feet
  • 4 = 3 - 4 Feet
  • 5 = 4 - 5 Feet
  • 6 = 5 - 6 Feet
  • 7 = 6 - 7 Feet
  • 8 = 7 - 8 Feet
  • 9 = 8 - 9 Feet
  • 10 = 9 - 10 Feet
  • 11 = 10 - 12 Feet
  • 12 = 12 - 14 Feet
  • 13 = 14 - 16 Feet
  • 14 = 16 - 18 Feet
  • 15 = 18 - 20 Feet
  • 16 = 20 - 25 Feet
  • 17 = 25 - 30 Feet
  • 18 = 30 - 35 Feet
  • 19 = 35 - 40 Feet
  • 20 = 40 - 45 Feet
  • 21 = 50 - 75 Feet
  • 22 = 75 - 100 Feet
  • 23 = 100 - 150 Feet
  • 24 = 150 - 200 Feet
  • 25 = 200 - 250 Feet
  • 26 = 250 - 300 Feet
  • 27 = 300 - 350 Feet
  • 28 = 350 - 400 Feet
  • 28 = 400 - 450 Feet
  • 30 = 450 - 500 Feet
  • 31 = 500 - 750 Feet
  • 32 = 750 - 1000 Feet
  • 33 = > 1000 Feet 
SmallInt2   
 BaseFloodElevation

Elevation values.

Corresponds to the code in BaseFloodElevationCode.

VarChar40  
 MinValue

Minimum value in the elevation range.

Corresponds to the first number in the BaseFloodElevationCode range. 

Double9  
 MaxValue

Maximum value in the elevation range.

Corresponds to the last number in the BaseFloodElevationCode range. 

Double9  
 DescriptionDescription of the base flood elevation 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.