Touchstone 4.0 Database Documentation
tFEMAFloodZone Table
Description

Stores the possible Federal Emergency Management Agency (FEMA) flood zones. Used during the Hazard analysis.

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

Code that represents the FEMA flood zone.

  • 0 = No zone provided 
  • 1 = V
  • 2 = VE
  • 3 = A
  • 4 = AE
  • 5 = AO
  • 6 = AOVEL
  • 7 = AH
  • 8 = A99
  • 9 = D
  • 10 = AR
  • 11 = X500
  • 12 = X
  • 13 = 100IC
  • 14 = 500IC
  • 15 = FWIC
  • 16 = FPQ
  • 17 = IN
  • 18 = OUT
  • 19 = No zone provided 
  • 20 = UNDES
  • 21  = No zone provided 
  • 22  = No zone provided 
SmallInt2   
 FloodZoneCode

Code that represents the Touchstone flood zone code.

For a complete list of codes, see tFloodZone Table.

SmallInt2   
 FEMAFloodZone

Name of the flood zone.

Corresponds to the code in FEMAFloodZoneCode. 

VarChar40  
 DescriptionDescription of the flood code.VarChar1024  
Objects that tFEMAFloodZone depends on
 Database ObjectObject TypeDescriptionDep Level
tFloodZone tabletFloodZoneTable

Stores the possible flood zone categories. Used during the Hazard analysis.

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